Browse by Tags

Tagged Content List
  • Blog Post: 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 of your queries have correct plan. The latter...
  • Blog Post: 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? What questions you can answer using DMVs? So...
  • Blog Post: 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 that some of you might be interested to take a...
  • Blog Post: 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 become very important. Before we jump into how applications...
  • Blog Post: 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 cache, Buffer Pool, and the rest of the...
  • Blog Post: 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 might be interesting to everyone. If you were...
  • Blog Post: 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 like to go over both Windows's and SQL Server...
  • Blog Post: 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
  • Blog Post: 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 procedure cache are very tightly coupled. For example...
  • Blog Post: 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 robust in the fiber environment. As you know, when...
  • Blog Post: 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 why it is important. Memory pressure is categorized...
  • Blog Post: 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 ---------------- | Page Allocator | ---------------...
  • Blog Post: 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 in latest version? Have we removed non-preemptive...
Page 1 of 1 (13 items)