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 |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-04-26 : 03:50:22
|
| Hi, In one of our servers all inserts in all databases takes too much time (almost application hangs). As I'm new in DBA field, please let me know what details you need to recognize the problem. Maybe helpful to add that SQLTRACE_BUFFER_FLUSH takes 99.9% waitingThanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-26 : 10:27:30
|
| Use 'sp_who2 active' to check if has blocking. |
 |
|
|
|
|
|
Performance Problem