Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2005-11-07 : 04:39:22
|
| Hello friends...I have problem with my application...sometimes that may happened I donot why...see when I opened my application that took some more time to open..when I check for CPU utilization it showed me 25% and also sql server mem Uilization was 2,809,524K and at same time my three jobs were running and they took some extra time to complete....as compare to previous job history i found that.....the jobs running somehow relation to each other...my point is wheather that cause my application too slow?????or any other possibility that affect my application???? or which factor should i check then to find what cause my application too slow?????Please help me out!!!! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-07 : 08:37:33
|
| try using the profiler to see what is being actioned on the server.Also run http://www.mindsdoor.net/SQLAdmin/sp_nrInfo.htmlto see what is happening.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
My application was too slow!!!!