Welcome to MSDN Blogs Sign in | Join | Help

November 2006 - Posts

Tuesday, November 28, 2006 3:25 PM

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
Posted by psssql | 1 Comments
Filed under: ,
Monday, November 27, 2006 6:39 PM

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
Posted by psssql | 1 Comments
Filed under:
Monday, November 27, 2006 6:24 PM

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
Posted by psssql | 4 Comments
Filed under:
Monday, November 27, 2006 6:15 PM

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
Posted by psssql | 0 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 | 2 Comments
Friday, November 10, 2006 4:00 PM

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
Posted by psssql | 1 Comments
Filed under:
Thursday, November 09, 2006 8:11 PM

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
Posted by psssql | 1 Comments
Filed under:
Wednesday, November 08, 2006 8:31 PM

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
Posted by psssql | 0 Comments
Filed under:
Wednesday, November 08, 2006 8:13 PM

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
Posted by psssql | 0 Comments
Filed under:
 
Page view tracker