Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQLOS » Performance   (RSS)
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: , ,
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 | 18 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 | 3 Comments
 
Page view tracker