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 |
|
igormarchenko
Starting Member
5 Posts |
 Posted - 2009-12-09 : 19:59:30
|
| Hello! I am in the process of familiarizing myself with SQL Server 2008 features. We have just installed and configured SQL Server 2008 64-bit Standard Edition Active/Active cluster. I was trying to run some query tests while monitoring perfmon counters and wait stats information. I was trying to use track_waitstats_2005 and get_waitstats_2005 stored procedures from SQL Server 2005, but apparently they do not report correct info in 2008. For example, CPU resource waits % is consistently 36% indicating CPU bottleneck, although CPU usage on the box was barely 5-10 %. get_waitstats_2005 consistently report high resource wait % for LOGMGR_QUEUE,FT_IFTS_SCHEDULER_IDLE_WAIT. I was wondering what is the proper way of monitoring wait stats in SQL Server 2008 since old stored procedure from 2005 do not work correctly. I am trying to understand how to interpret high resource wait % for two aforementioned wait types.Help on this matter is greatly appreciated,Igor |
|
|
|
|
|
analyze wait_stats in SQL Server 2008