Subscribe: Slava Oks's WebLog
Preview: Slava Oks's WebLog

Slava Oks's WebLog

Last Build Date: Mon, 25 Sep 2017 14:40:01 +0000


What made Porting Microsoft SQL Server to Linux to be the right move after all

Sun, 24 Sep 2017 21:50:32 +0000

It has taken us a little more than two and a half years to bring an official version of SQL Server to Linux. Over the course of our work, we encountered many supporters, bystanders, skeptics, and pessimists. Quite of few things had to turn our way for us to succeed. Notably, on the engineering side,...

SQL Server on Linux, aka project Helsinki: Story behind the idea

Tue, 20 Dec 2016 03:15:41 +0000

As I mentioned in my previous post, I left SQL Server in 2007 to work on what ended up being a super exciting software project: The Midori Operating System. I spent almost eight years working in Midori’s kernel and runtime team. I had worked with exceptional folks on very interesting and challenging problems before but I...

One, Two, Three… Boom!

Tue, 20 Dec 2016 00:24:47 +0000

...I am back and getting ready to start blogging. It has been almost ten years since my last blog post. Time flies, indeed!  As you can imagine I have plenty of things to share many of which are related to SQL Server, runtimes and  operating systems in general. As we expanding our horizons, I am also planning  on...

Changing gears

Wed, 07 Mar 2007 11:15:00 +0000

You haven't heard from me in while and there is a reason. I moved from SQL Server's Storage Engine team to a new incubation team that is involved in exploring new directions in operating systems. This subject area has been always very fascinating for me as you easily might deduce from my previous posts. The new team is...

Q and A: Ratio between AWE Allocated and VM Committed/Reserved in DBCC MEMORYSTATUS output

Tue, 02 Jan 2007 20:02:00 +0000

Q: What kind of ratio should you expect to see between AWE Allocated and VM Committed/Reserved?  We are running 8GB with a cap of 7GB in the max server memory and yet the VM Committed is around 100MB.  I was first shocked to see that the sqlservice in task manager only shows that SQL is...

Q & A: I am running on 64 bit and all of my tasks are waiting on SOS_RESERVEDMEMBLOCKLIST, What is going on?

Tue, 14 Nov 2006 13:29:00 +0000

This wait type represents waiting on multi page allocations inside of SQLOS's memory manager. As you remember from my description of memory manager's working internals, it has two major allocators single page allocator, SPA and multi page allocator, MPA. Majority of the time SQL Server internal code uses SPA, however in some cases it will...

SQLOSDMV’s Continue

Tue, 14 Nov 2006 13:26:00 +0000

sys.dm_os_waiting_tasks One can run lots of interesting queries using this view.  You can even use this view to perform deadlock detection that is not resolvable by deadlock monitor, DM. For example if you have tasks waiting on external resources such as extended stored procedures and blocking others from running. This type of deadlock DM can’t...

Q & A: Does SQL Server always respond to memory pressure?

Mon, 13 Nov 2006 15:39:00 +0000

Q: I thought I've seen reference recently to problems with SQL2005 not releasing memory when under pressure, and this was possibly due to the Lock Pages In Memory option. We have a server where this seems to be happening, i.e. SQL2005 uses all available memory and the server basically dies because there's no memory left...

SQLOS’s DMVs Continue

Thu, 28 Sep 2006 22:22:00 +0000

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


Tue, 22 Aug 2006 19:54:00 +0000

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 in order to...