Sample chapter

If you want to get a sampling of the content in the troubleshootting book Bob mentioned, one of the book’s chapters can be read here: http://www.khen.com/sspt04.pdf.  Be aware that the topic discussed in this chapter isn’t what the whole book is about.  There are 9 other chapters on other engine troubleshooting topics (see the full list here), plus some…

0

How to get the new book

You can tell I’m a novice when it comes to books when I don’t provide good information on how to get it. Please check out these links on Amazon and Barnes and Nobles for purchasing the book at discounts from the retail price: http://www.amazon.com/SQL-Server-2005-Practical-Troubleshooting/dp/0321447743/sr=8-1/qid=1165872513 http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?z=y&EAN=9780321447746&itm=1 Bob Ward, Microsoft   

0

A New Book on SQL Server 2005 Troubleshooting

What is a blog without talking about your own work a bit? My last post of the year will be to tell you about a book that I contributed to that is hot off the presses called SQL Server 2005 Practical Troubleshooting: The Database Engine http://www.aw-bc.com/catalog/academic/product/0,1144,0321447743,00.html Ken Henderson approached several of us in PSS about…

0

Follow-up to PASS 2006

How does anyone keep up with blog posts<g>? I myself have actually been travelling to Redmond to our campus for different things and haven’t been enough at my home base in TX to dedicate enough time to our blog. I hope you have enjoyed the posts from Robert Dorr. He works pretty closely with Slava…

0

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