Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQLOS   (RSS)
Friday, March 28, 2008 8:04 PM

How It Works: Non-Yielding Resource Monitor

I have addressed similar conditions error in a white paper: www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx 2008-01-20 19:01:26.11 Server      ***Stack Dump being sent to K:\MSSQL.3\MSSQL\LOG\SQLDump0001.txt
Posted by psssql | 0 Comments
Tuesday, March 18, 2008 4:42 PM

How It Works: SQL Server 2005 I/O Affinity and NUMA Don't Always Mix

Recently I have fielded several questions related to I/O affinity.  Allow me to outline the behavior and clear up misconceptions. When I/O affinity is enabled SQL Server creates a hidden scheduler for the Log Writer process as well as a special lazy
Posted by psssql | 0 Comments
Filed under: , ,
Wednesday, March 05, 2008 4:51 PM

How It Works: SQLIOSim - Checksums

SQLIOSim, like its predecessor SQLIOStress, is designed to read pages it has written and validate the data.   SQLIOSim does this using a checksum algorithm. When SQLIOSim starts up it creates a set of buffers and used the Cryto APIs to generate
Posted by psssql | 1 Comments
Filed under: , , ,
Monday, March 03, 2008 3:41 PM

SQL Server Working Set Trim Problems? - Consider...

Microsoft support continues to receive a steady flow of cases indicating poor, SQL Server performance symptoms.   When the issue is narrowed down we are finding that the working set of SQL Server and many of the processes on the computer have
Posted by psssql | 2 Comments
Filed under: , ,
Tuesday, February 12, 2008 6:10 PM

How It Works: SQL Server 2005 Connection and Task Assignments

I have talked about how connections and tasks get assigned as PASS and during many other mentoring opportunities.  I just finished working on an issue that forced me to dig deeper into the subject. The customer reported that on a NUMA machine the
Posted by psssql | 3 Comments
Filed under: , ,
Thursday, January 24, 2008 6:38 PM

How It Works: SQL Server 2005 NUMA Basics

The Senior Escalation Engineers do various training and mentoring activities. As I do this I thought I would try to propagate some of this information on the blog. I have received several questions on the SQL Server NUMA implementation this week. Much
Posted by psssql | 1 Comments
Filed under: , ,
Monday, January 14, 2008 7:19 PM

SQLIOSim - Error Request Could Not Be Performed - Unable to get disk cache info

Both SQLIOSim and SQLIOStress use DeviceIOControl to determine information about the target.   On disk caches are typically not battery backed and when enabled can lead to data loss during a power outage. The utilities attempt to warn the user
Posted by psssql | 1 Comments
Filed under: , ,
Thursday, January 10, 2008 8:59 AM

SQL Server 2008 - Resource Governor Questions

A couple of common questions have surfaced related to the SQL Server 2008 Resource Governor feature. The SQL Server 2008 BOL has a lot of good information so start don't forget to review that as well. Metadata and Runtime Data A set of DMVs exist for
Posted by psssql | 1 Comments
Filed under: , ,
Sunday, August 19, 2007 4:46 PM

SQL Server 2005 - RDTSC Truths and Myths Discussed

I posted some updates to my blog entry about the RDTSC and drift warnings in May. See the following link http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx
Posted by psssql | 4 Comments
Thursday, May 31, 2007 5:15 PM

The SQL Server Working Set Message

I spent several days last week investigating reported case trends and I will attempt to summarize the findings for you. The following message was added to SQL Server 2005 SP2 to indicate that the working set (RAM resident portion of SQL Server) was paged
Posted by psssql | 8 Comments
Wednesday, February 21, 2007 4:10 PM

SQL Server Urban Legends Discussed

I have been answering questions on two of the most misunderstood ‘SQL Server Urban Legends’ frequently again so I decided to make a post about them. · SQL Server Uses One Thread Per Data File · A Disk Queue Length greater than 2 indicates an I/O bottleneck
Posted by psssql | 16 Comments
Filed under: , ,
Monday, November 27, 2006 5:54 PM

SQL Server 2005 SP2 will introduce new messages to the error log related to timing activities.

The following article has been publiched about this subject: http://support.microsoft.com/kb/931279 RDTSC Drift vs Not Synchronized To clarify - SQL Server 2005 SP2 contains both Drift and a Non Synchronized warnings. The Non Synchronized message is only
Posted by psssql | 2 Comments
 
Page view tracker