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 |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2006-10-25 : 07:50:19
|
| Hi all,Im running few applications connected to SQL Server 2005. Very often in the server machine ,the CPU usage goes to 100 and the memory usage too increased leading to very poor performanceand finally killing the application.When I do a profiling , I would see below given output (only few lines I have pasted).Duration TextData ApplicationName NTUserName LoginName CPU Reads Writes23759823000 NULL .Net SqlClient Data Provider NULL user1 0 104 023460740000 NULL .Net SqlClient Data Provider NULL user1 1125 40737 263118226000 NULL Microsoft SQL Server Management Studio NULL user1 32 66 0759290000 NULL Microsoft SQL Server Management Studio NULL user1 499 14333 0610303000 NULL Microsoft SQL Server Management Studio NULL user1 47 153 0603743000 NULL Microsoft SQL Server Management Studio NULL user1 47 66 0439973000 NULL Microsoft SQL Server Management Studio NULL user1 0 52 0439193000 NULL .Net SqlClient Data Provider NULL user1 0 0 0Could any guess what might be the issue ?Thanks in advance,HHA |
|
|
Luis Martin
Yak Posting Veteran
54 Posts |
Posted - 2006-10-25 : 10:44:14
|
| What Events are you trancing?All in Love is Fair Stevie Wonder |
 |
|
|
|
|
|
Performance issue.