Browse by Tags

• Be Aware
• SQL Server Memory Management
• 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

• Set of new features in SQL Server 2005 enabled by SQLOS

  Couple of weeks ago I had a chance to visit set of our customers and talk to them directly. It was an unforgettable experience. As a part of the visit I made set of presentations related to SQLOS and new features it enables in SQL Server 2005. I thought Read More... Posted Wednesday, April 12, 2006 2:57 PM by slavao | 4 Comments Filed under: SQL Server Memory Management, SQL Server Scheduling, SQLOS

• SQL Server 2005 NUMA support & troubleshooting

  SQL Server 2005 has been designed to take advantage of NUMA features exposed by both hardware and the Windows operating system. There are several caveats that you need to be aware when attempting to run SQL Server on NUMA platforms. In this post I would Read More... Posted Tuesday, August 02, 2005 11:43 AM by slavao | 4 Comments Filed under: SQL Server Memory Management, SQL Server Scheduling, SQLOS

• SQLOS helps SQL Server to leverage hardware capabilities

  I just finished an article on how SQLOS helps SQL Server to leverage hardware capabilities http://blogs.msdn.com/slavao/articles/441058.aspx . It will be interesting to hear your comments, thoughts. Thanks a lot in advance Read More... Posted Wednesday, July 20, 2005 2:50 PM by slavao | 0 Comments Filed under: SQL Server Memory Management, SQL Server Scheduling, SQLOS

• Be aware: FLS-Fiber Local Storage

  Problem: In the last several months there were several publications describing usage of fibers. When covering SQLOS's scheduling I will go into more details about them. Today I would like to touch on the subject on how to make your dlls/libraries more Read More... Posted Monday, February 28, 2005 11:23 AM by slavao | 2 Comments Filed under: SQL Server Scheduling, SQLOS, Be Aware

• SQLOS - unleashed

  With SQL Server 2005 Beta 1 and Beta 2 you might have noticed that there is no ums.dll in the bin directory. The reason is simple it is no longer exists. In SQL2000 ums.dll provided SQL Server with user mode non-preemptive scheduling. So what happened Read More... Posted Saturday, February 05, 2005 4:38 PM by slavao | 6 Comments Filed under: SQL Server Memory Management, SQL Server Scheduling, SQLOS