SQL Server becomes sluggish or appears to stall on 64 bit installations

I would like to make you aware of corrections you should apply to your 64 bit installations of SQL Server to avoid sluggish behavior.   Microsoft has encountered reports from a few seconds up to minutes in duration where it appears SQL Server is not processing requests. On 64 bit systems calls to VirtualQuery are more…

1

What happened to SQLIOStress?

SQLIOStress did not go away it was replaced with SQLIOSim (http://support.microsoft.com/kb/231619).   I developed SQLIOStress in response to various cases encountering stale reads, checksum failures and other unwanted I/O behavior.  SQLIOStress continued to get more test cases but was being developed on an issue by issue basis and was becoming difficult to maintain. SQLIOStress has been…

1

What do I need to know about SQL Server database engine I/O?

Several years ago I started a whitepaper to describe the basic I/O requirements for the SQL Server database engine.  This continued to grow and has become a series of chapters.  Chapter 2 is a continuation from the original whitepaper so be sure to read them as chapter 1 and chapter 2. I wanted all vendors,…

5

Have you heard about the SQL Server Always-On Solution Reviewed Program?

Over a year ago the SQL Server development and PSS staff joined together to create the criteria for the SQL Server Always-On Solution reviewed program (SSAOSRP).   To be clear this is not a certification program but it is a very thorough review of the solution for key developers and support professionals at Microsoft. The requirements…

2

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 recorded on 1 hour intervals to avoid flooding the log.   At most the server will report…

7

The PSS Service Center at PASS 2006

Back in 2003, Ken Henderson approached me about speaking at PASS in Seattle. I readily accepted to speak on SQL Server troubleshooting. Ken and I came up with an additional idea rather than just presentations. Why not setup some computers in a lab environment and actually show customers how to troubleshoot problems? Ken coined the…

1

PSS Presentations at PASS 2006

I thought I would share with you some information about what presentations are being given by the Microsoft PSS SQL team next week at PASS:  Pre-Conference Seminar: The PSS Boot Camp We did something last year in Texas and this past February in Barcelona called the PSS Boot Camp. I think Ken Henderson takes the…

1

Microsoft PSS SQL is coming to PASS 2006

The PSS team starting presenting in PASS 2003 in Seattle thanks to the efforts of Ken Henderson. Each year we have increased our presence and armed the community with information and advice on troubleshooting SQL Server. We are pretty excited to have our largest contingent ever of PSS engineers come to PASS 2006 in Seattle…

0

Welcome to the Microsoft PSS SQL Team Blog

The PSS SQL team is joining the ranks of bloggers. You will see contributions on this blog from time to time from various members of the Microsoft PSS SQL team mostly from the Escalation Services staff. We plan to focus this blog on two main types of information: Troubleshooting tips we want the community to…

1