• Slava Oks's WebLog

    SQLOS helps SQL Server to leverage hardware capabilities

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

    Be Aware: VirtualAlloc with MEM_RESERVE can fail even if you have plenty of VAS inside of the process

    • 0 Comments
    Many developers assume that if you have plenty of free VAS in your process VirtualAlloc ( http://msdn.microsoft.com/library/default.asp?url=/library/en-us/memory/base/virtualalloc.asp ) and VirtualAllocEx ( http://msdn.microsoft.com/library/default.asp...
  • Slava Oks's WebLog

    Q and A: Controlling size of a single cache in SQL 2005

    • 2 Comments
    Q: I have teaching a class on Yukon for the Ascend program, and the class had a question I wanted to double check before answering. On an Itanium with 1 TB of RAM, the class’ curiosity asked, “If plan cache is very large “Then how does Plan Cache lookups...
  • Slava Oks's WebLog

    Q and A: Max memory with sql server 2000 / win2003 x64

    • 3 Comments
    Today, I received following question Q: Slava, I have a question for you. Sql 2000 is documented to support a maximum of 64GB when used with 2000 datacenter edition. I assume this is the limit of 2000 Datacenter, but is it also a limit defined in sql...
  • Slava Oks's WebLog

    Be Aware: Using AWE, locked pages in memory, on 64 bit

    • 9 Comments
    We have already talked about Windows AWE mechanism on 32 bit and how SQL Server utilizes it. Today I would like to go over AWE & related mechanism on 64 bit platforms. To some people it comes as a surprise that AWE mechanism is still present...
  • Slava Oks's WebLog

    Be Aware: IA64 Stack Size

    • 11 Comments
    Stack subject in Windows OS is fascinating. There are so many interesting technical problems surrounding it. The moment you think you fully understand everything about stack you suddenly discover yet another mystery. And so it goes. In the last couple...
  • Slava Oks's WebLog

    SQLOS Caching

    • 7 Comments
    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...
  • 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...
  • 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

    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

    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'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 - 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

    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

    Getting an exception call stack from the catch block (C++)

    • 12 Comments
    This is my first post in this category so I am really looking forward to your comments :-) Today I would like to cover a specific feature related to our implementation of C++ exception handling. Every day I realize that not many people are familiar with...
  • Slava Oks's WebLog

    A look at Windows Virtual Memory mechanisms (continuation of "A look at Virtual Address Space - VAS")

    • 11 Comments
    As I promised last time here comes next post on memory J . Remember, my eventual goal is to reveal how memory management works in SQL Server but for you to really appreciate it, I think, you do need to get good feeling on how Windows manages memory. Understanding...
  • Slava Oks's WebLog

    Tracking VAS in Yukon, cont...

    • 0 Comments
    Some of you could have gotten bored with my previous post http://blogs.msdn.com/slavao/archive/2005/01/27/361678.aspx . Yea, I know that VAS subject was covered multiple times and by multiple authors in the past and you probably know about it more than...
  • Slava Oks's WebLog

    A look at Virtual Address Space - VAS

    • 7 Comments
    Memory is a set of common resources shared by applications, their components and operating system. One needs to be very specific when referring to a given memory resource. Mistakenly, in many cases, developers, users, DBAs refer to different memory resources...
  • Slava Oks's WebLog

    Tracking VAS in Yukon

    • 5 Comments
    When we started working on the next release of SQL Server, Yukon, we realized that supportability features are keys to our success. Eventually I am planning on covering ones that are related to low level "stuff", something that many of you, I know, really...
Page 2 of 2 (45 items) 12