M trying to get the data from sql server using web services in every 5 seconds at that time some time services is stop and time period of get data from sql server is more then 3 to 4 minute.That data are get from machines and save it to in sql table after that data display at software screen. There are almost 25 to 30 machine set up and that numbers can be increase.
My recommendation is to stop using WebServices to interrogate SQL server to put in tables. Just do it by stored procedures scheduled by the SQL Agent.
Either way, understand that if there's a lot of code running and the machine is busy (especially if there's a lot of performance challenged code), the your WebServices or the SQL Agent are going to have to wait their turn just like everything else.
17 People are following this question.
