February, 2005

  • Slava Oks's WebLog

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

    • 15 Comments
    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 -...
  • Slava Oks's WebLog

    SQLOS's memory manager: responding to memory pressure

    • 16 Comments
    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...
  • Slava Oks's WebLog

    Memory Pressure - Classified

    • 11 Comments
    So far I touched on subjects that have been widely discussed in the industry. Today I would like to talk about a subject that you would hardly find information about: memory pressure.. On a surface the subject appears simple but in reality this is not...
  • Slava Oks's WebLog

    Changes in dbcc memorystatus in Yukon

    • 6 Comments
    You probably have used dbcc memory status command in SQL2000. In Yukon we have changed output of dbcc memorystatus to reflect new memory manager design, covered in my previous post. The first part of the output represents overall amount of memory consumed...
  • Slava Oks's WebLog

    SQLOS - unleashed

    • 6 Comments
    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...
  • Slava Oks's WebLog

    Look at Memory Leaks - Classify and Identify

    • 1 Comments
    In my previous post I talked about type of Memory Pressures. Today I would like to talk about related subject – Memory Leaks. Before you continue reading please make sure that you are familiar with how memory is managed on Windows. Memory leaks are bugs...
  • Slava Oks's WebLog

    Be aware: a new section in my blog

    • 2 Comments
    Periodically, I bump into unusual behavior, features, of compiler, operating system, strange design and coding decisions made by someone else that makes me wonder. After giving it some thought, I often come to the conclusion that behavior or observed...
  • Slava Oks's WebLog

    Be aware: FLS-Fiber Local Storage

    • 2 Comments
    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...
Page 1 of 1 (8 items)