While reading Will disabling hyperthreading improve performance on our SQL Server install I started wondering what the values I get for Jeff's first query:
SELECT * FROM sys.dm_os_wait_stats
order by signal_wait_time_ms desc
Which gives me a result for which I have no idea if I am headed for trouble or not (I don't seem to be having any performance issues yet). What would be considered a red flag for impending performance issues?
My top values are LATCH_EX, SOS_SCHEDULER_YEILD, CXPACKET, ASYNC_NETWORK_IO and PAGELATCH_EX.