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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2004-08-20 : 10:48:05
|
| Hi,We are evaluating performance of SQL Server database and with all the sp_lock,sp_who2, etc and performance monitor also trying to use dbcc sqlperf(waitstats). But somehow all the stats shown by DBCC sqlperf(waitstats) is 0 even when we know that there is waiting going on the system..so we even try to force waiting scenario from query analyzer but still all stats are 0. Do we need to start some option to use this command or why all the stats are 0?Thanks--rubs |
|
|
mbroodbakker
Starting Member
1 Post |
Posted - 2004-09-20 : 07:54:40
|
| If during sqlserver startup, it somehow could create the perfmon shared memory, all stats collection is turned of (you might see an error message in the log about this) you can 'correct' this with dbcc collectstats(on). |
 |
|
|
AmadeusC
Starting Member
1 Post |
Posted - 2004-09-29 : 18:31:58
|
| I noticed same behavior on a cluster server. dbcc sqlperf(waitstats) works fine on every other server I tried. |
|
|
|
|
|
|
DBCC sqlperf(waitstats)