Browse by Tags

• SQL Server Scheduling

• 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

• SQLOS's DMVs

  SQL Server 2005 has a large number of DMVs that you can take advantage of especially when you try to understand behavioral characteristics of your SQL Server 2005 installation. DMVs expose enormous amount of information but how can you make use of it? Read More... Posted Tuesday, August 22, 2006 7:54 PM by slavao | 8 Comments Filed under: SQLOS, SQLOS's DMVs