Share via


Slava Oks's WebLog

It has taken us a little more than two and a half years to bring an official version of SQL Server...

Date: 09/24/2017

...I am back and getting ready to start blogging. It has been almost ten years since my last blog...

Date: 12/20/2016

You haven't heard from me in while and there is a reason. I moved from SQL Server's Storage Engine...

Date: 03/07/2007

Q: What kind of ratio should you expect to see between AWE Allocated and VM Committed/Reserved? We...

Date: 01/02/2007

This wait type represents waiting on multi page allocations inside of SQLOS's memory manager. As you...

Date: 11/14/2006

sys.dm_os_waiting_tasks One can run lots of interesting queries using this view. You can even use...

Date: 11/14/2006

Q: I thought I've seen reference recently to problems with SQL2005 not releasing memory when under...

Date: 11/13/2006

sys.dm_os_schedulers Q. Do I need to by more CPUs? In order to answer this question you have to find...

Date: 09/28/2006

SQL Server 2005 has a large number of DMVs that you can take advantage of especially when you try to...

Date: 08/22/2006

Couple of weeks ago I did a talk on SQL Server 2005 scalability. The actual talk was not about the...

Date: 08/03/2006

I’m currently using the RTM+SP1 x86-SQL2005 build on a server which has 32GB of physical memory. I...

Date: 08/03/2006

Couple of weeks ago I had a chance to visit set of our customers and talk to them directly. It was...

Date: 04/12/2006

Q. A customer wants to run SQL 2000 SP4 in a Windows Server 2003 SP1 x64 edition. They did the...

Date: 04/12/2006

Recently I have recieved following question: A customer of mine is getting this output on an Itanium...

Date: 03/19/2006

Q. Under SQL Server 2000 Is the memtoleave concept still valid under 64-bit? A. Yes. If SQL Server’s...

Date: 03/14/2006

The answer is No. The source of possible confusion came from one of my previous posts:...

Date: 03/13/2006

By now you have heard a lot about the fact that under WOW a 32 bit process can get 4GB of VAS. I...

Date: 03/12/2006

In order for server side applications to run efficiently on modern hardware they have to understand...

Date: 03/12/2006

Q1 I read in your blog about the new algorithm with two clock hands to control memory consumption,...

Date: 11/20/2005

Seems like today is a question day :-). I will attempt to answer several questions about VAS I got...

Date: 11/15/2005

Today I received following question: Hello, We will be running Windows Server 2003 x64 with SQL...

Date: 11/15/2005

Our customers observed very interesting behavior on high end Hyperthreading (HT) enabled hardware....

Date: 11/12/2005

As you would expect in the last several months SQL 2005 went through rigorous testing. During the...

Date: 11/05/2005

Q: Hello Slava, I would like to confirm my understanding that on SQL 2005 64 bit edition it is...

Date: 08/31/2005

Yesterday I gave a talk around SQL Server 2005's memory manager. The talk was rather chalk talk. It...

Date: 08/30/2005

Sometimes I am surprised how issues come up the moment you mention them J. Recently, I have...

Date: 08/18/2005

SQL Server 2005 has been designed to take advantage of NUMA features exposed by both hardware and...

Date: 08/02/2005

I just finished an article on how SQLOS helps SQL Server to leverage hardware capabilities...

Date: 07/20/2005

A new platform layer in SQL Server 2005 to exploit new hardware capabilities and their trends Slava...

Date: 07/20/2005

Many developers assume that if you have plenty of free VAS in your process VirtualAlloc...

Date: 06/03/2005

Q: I have teaching a class on Yukon for the Ascend program, and the class had a question I wanted to...

Date: 06/03/2005

Today, I received following question Q: Slava,I have a question for you. Sql 2000 is documented to...

Date: 06/03/2005

We have already talked about Windows AWE mechanism on 32 bit and how SQL Server utilizes it. Today I...

Date: 04/29/2005

Stack subject in Windows OS is fascinating. There are so many interesting technical problems...

Date: 03/19/2005

Yukon caching vs SQL2000 What makes Yukon memory management different from SQL2000 is elaborative...

Date: 03/18/2005

Problem: In the last several months there were several publications describing usage of fibers. When...

Date: 02/28/2005

Periodically, I bump into unusual behavior, features, of compiler, operating system, strange design...

Date: 02/22/2005

Resource Monitor and Memory Pressure When configuring SQL Server it is very important to understand...

Date: 02/19/2005

You probably have used dbcc memory status command in SQL2000. In Yukon we have changed output of...

Date: 02/14/2005

SQLOS's memory manager consists of several components such as memory nodes, memory clerks, memory...

Date: 02/11/2005

With SQL Server 2005 Beta 1 and Beta 2 you might have noticed that there is no ums.dll in the bin...

Date: 02/05/2005

In my previous post I talked about type of Memory Pressures. Today I would like to talk about...

Date: 02/04/2005

So far I touched on subjects that have been widely discussed in the industry. Today I would like to...

Date: 02/01/2005

This is my first post in this category so I am really looking forward to your comments :-) Today I...

Date: 01/30/2005

As I promised last time here comes next post on memory J. Remember, my eventual goal is to reveal...

Date: 01/29/2005

Some of you could have gotten bored with my previous post...

Date: 01/28/2005

When we started working on the next release of SQL Server, Yukon, we realized that supportability...

Date: 01/26/2005