Processing appears to stall or become sluggish on multi-processor machines running Analysis Services 2005

Over the past several months PSS has received several reports of processing for cubes in SQL Server 2005 Analysis Services hanging or becoming unbearably slow.  Most of the reports have involved high end 64-bit servers with 4 or more processors and 8GB or more RAM.  In many instances the processing can be “jump started” again…

4

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