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…


Q and A: Virtual Address Space, VAS, reservation – why bother?

Seems like today is a question day :-). I will attempt to answer several questions about VAS I got today: Q1.  There is one aspect of Virtual Memory that is just not clear yet. I think I understand about VAS, but maybe not as much as I could, but I don’t understand about ‘reserving memory’. When we talk about SQL…


Q and A: x64 & AWE mechanism

  Today I received following question: Hello, We will be running Windows Server 2003 x64 with SQL Server 2005 x64.  I would think AWE would not come into the picture in this scenario. I’m trying to find out more about SQL Server 2005 memory management on x64 systems using x64 versions of the OS and…


Be aware: To Hyper or not to Hyper

Our customers observed very interesting behavior on high end Hyperthreading (HT) enabled hardware. They noticed that in some cases when high load is applied SQL Server CPU usage increases significantly but SQL Server performance degrades. Occasionally they would also see message in errorlog indicating one of the threads can’t acquire a spinlock (Spinlock is a…


Final changes in SQL Server 2005’s memory manager

As you would expect in the last several months SQL 2005 went through rigorous testing.  During the period we have identified and put several improvements that you might be interested to hear about.   Memory Broker Analyzing SQL Server’s behavior with respect to memory consumption from multiple sources we realized that we have an opportunity…


Q and A: Using Lock Pages In memory on 64 bit platform

Q: Hello Slava,  I would like to confirm my understanding that on SQL 2005 64 bit edition it is recommended to grant Lock Pages in Memory right to the SQL account and then turn on the AWE setting. Thanks A: Yes, we do recommend to turn on Lock pages in memory so that OS doesn’t page…


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 following my blog you will notice that slides below closely…


Configuring SQL Server 2005 for Soft NUMA

Sometimes I am surprised how issues come up the moment you mention them J. Recently, I have discussed Soft NUMA configurations in the article http://blogs.msdn.com/slavao/articles/441058.aspx. This week one of our customers had an interesting problem. The customer wanted to partition single SQL server instance based on the load. Customer’s application is heterogynous. It consists of…


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’s…


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