CSS SQL Server Engineers

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

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

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

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

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

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

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

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

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