Browse by Tags

• SQLOS

• SQLOSDMV's Continue

  sys.dm_os_waiting_tasks One can run lots of interesting queries using this view. You can even use this view to perform deadlock detection that is not resolvable by deadlock monitor, DM. For example if you have tasks waiting on external resources such Read More... Posted Tuesday, November 14, 2006 1:26 PM by slavao | 1 Comments Filed under: SQL Server Scheduling, SQLOS's DMVs

• SQLOS's DMVs Continue

  sys.dm_os_schedulers Q. Do I need to by more CPUs? In order to answer this question you have to find out if your load is really CPU bounded. Your load is really CPU bounded if a number of runnable tasks per each scheduler always greater than 1 and all Read More... Posted Thursday, September 28, 2006 10:22 PM by slavao | 6 Comments Filed under: SQL Server Scheduling, SQLOS, SQLOS's DMVs