Browse by Tags

• Be Aware
• Coding & Debugging tips
• SQL Server Memory Management
• 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

• 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

• 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

• Retrieving information about CPUs' relationships

  In order for server side applications to run efficiently on modern hardware they have to understand hardware layout. As we are moving towards multicore and multi node NUMA systems, understanding relationships amongst cores, logical and physical CPU has Read More... Posted Sunday, March 12, 2006 5:52 PM by slavao | 6 Comments Filed under: Coding & Debugging tips, SQLOS Attachment(s): cpulayout.cpp

• Q and A: Clock Hands - what are they for?

  Q1 I read in your blog about the new algorithm with two clock hands to control memory consumption, but I really would like to understand exactly what the hands are doing and if they relate to the lazywriter. A1. In SQL Server 2005 we have separated database Read More... Posted Sunday, November 20, 2005 1:56 PM by slavao | 0 Comments Filed under: SQL Server Memory Management, SQLOS

• Talking Points around Memory Manager in SQL Server 2005

  Yesterday I gave a talk around SQL Server 2005's memory manager. The talk was rather chalk talk. It included memory manager changes in SQL 2005 as well as changes post CTP15. For the talk I prepared several slides - basically talking points that I thought Read More... Posted Tuesday, August 30, 2005 12:59 PM by slavao | 10 Comments Filed under: SQL Server Memory Management, 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

• SQLOS Caching

  Yukon caching vs SQL2000 What makes Yukon memory management different from SQL2000 is elaborative caching framework. In SQL2000 there are two major caches: data page cache, called Buffer Pool and procedure cache, cache of query plans. Buffer Pool and Read More... Posted Friday, March 18, 2005 12:19 PM by slavao | 7 Comments Filed under: SQL Server Memory Management, 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's memory manager: responding to memory pressure

  Resource Monitor and Memory Pressure When configuring SQL Server it is very important to understand how it reacts to memory pressure. I have already spent significant amount of time describing types of memory pressure. In this post you will understand Read More... Posted Saturday, February 19, 2005 4:25 PM by slavao | 16 Comments Filed under: SQL Server Memory Management, SQLOS

• SQLOS's memory manager and SQL Server's Buffer Pool

  SQLOS's memory manager consists of several components such as memory nodes, memory clerks, memory caches, and memory objects. Fig 1. depicts memory manager components and their relationship: ---------------- | Memory Object | ---------------- | | V ---------------- Read More... Posted Friday, February 11, 2005 10:33 AM by slavao | 15 Comments Filed under: SQL Server Memory Management, SQLOS

• 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