Browse by Tags

• Be Aware
• Coding & Debugging tips
• SQL Server Memory Management
• SQLOS
• SQLOS's DMVs

• SQLOSDMV's Continue

  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 Read More... Posted Tuesday, November 14, 2006 1:26 PM by slavao | 1 Comments Filed under: SQL Server Scheduling, SQLOS's DMVs

• SQLOS's DMVs Continue

  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 Read More... Posted Thursday, September 28, 2006 10:22 PM by slavao | 6 Comments Filed under: SQL Server Scheduling, SQLOS, SQLOS's DMVs

• Talking points around SQL Server 2005 scalability

  Couple of weeks ago I did a talk on SQL Server 2005 scalability. The actual talk was not about the enormous amount of features that you can leverage in SQL Serve 2005 to make your application scale but rather how SQL 2005 achieves its scalability. In Read More... Posted Thursday, August 03, 2006 11:09 AM by slavao | 8 Comments Filed under: SQL Server Memory Management, SQL Server Scheduling

• Set of new features in SQL Server 2005 enabled by SQLOS

  Couple of weeks ago I had a chance to visit set of our customers and talk to them directly. It was an unforgettable experience. As a part of the visit I made set of presentations related to SQLOS and new features it enables in SQL Server 2005. I thought Read More... Posted Wednesday, April 12, 2006 2:57 PM by slavao | 4 Comments Filed under: SQL Server Memory Management, SQL Server Scheduling, SQLOS

• 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 Read More... Posted Saturday, November 12, 2005 12:48 PM by slavao | 29 Comments Filed under: Coding & Debugging tips, SQL Server Scheduling, Be Aware

• 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. Read More... Posted Thursday, August 18, 2005 7:30 PM by slavao | 6 Comments Filed under: SQL Server Memory Management, SQL Server Scheduling

• 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 Read More... Posted Tuesday, August 02, 2005 11:43 AM by slavao | 3 Comments Filed under: SQL Server Memory Management, SQL Server Scheduling, SQLOS

• 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 Read More... Posted Wednesday, July 20, 2005 2:50 PM by slavao | 0 Comments Filed under: SQL Server Memory Management, SQL Server Scheduling, SQLOS

• Be aware: FLS-Fiber Local Storage

  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 Read More... Posted Monday, February 28, 2005 11:23 AM by slavao | 2 Comments Filed under: SQL Server Scheduling, SQLOS, Be Aware

• SQLOS - unleashed

  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 Read More... Posted Saturday, February 05, 2005 4:38 PM by slavao | 5 Comments Filed under: SQL Server Memory Management, SQL Server Scheduling, SQLOS