December 31, 2004 at 4:56 am
I have an application that runs a long forecasting process. When I run the application on a client machine against the SQL server database it completes normally. When run on the server, it eventually slows to a crawl with little or no disk or CPU activity. How should I analyze what is happening?
December 31, 2004 at 6:01 am
I would check the memory usage on the server. If this is a long running application then it will be fighting for memory from the same hardware as SQL and that can always be fun. Another thing to do it evaluate the CPUTime and other information in sp_who2 to try and get a feel for the program.
Another thing you could do is run profiler against the server and get information from that as to what is going on behind the scenes.
With all that said however, it sounds like between SQL, users going after the SQL server, and your long running application that everything is just going to crawl because of (n) resources (memory, CPUs, etc...)
Good Hunting!
AJ Ahrens
webmaster@kritter.net
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply