CSS SQL Server Engineers
This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services team.
RML Utilities for Microsoft SQL Server Released
The Microsoft SQL Server support team uses several internally-written utilities to...
Author: psssql Date: 12/18/2007
RML (READTRACE/OSTRESS) Utilities for SQL Server 2005
As I promised at the PASS 2007 Summit in Denver, I'm writing a post here about the popular RML...
Author: psssql Date: 11/21/2007
Do I have to assign the Lock Pages in Memory privilege for Local System?
IMPORTANT: The following KB article adds support for Locked Pages to SQL Server Standard...
Author: psssql Date: 10/18/2007
Database compatibility and new features
Have you attempted to execute queries using some of the new keywords and constructs only to see...
Author: psssql Date: 10/16/2007
Follow-up to PASS 2007 Summit
Our entire PSS team had a great time presenting and meeting many customers at last week's summit....
Author: psssql Date: 09/27/2007
Microsoft PSS is back for the PASS 2007 Summit!
Since 2003, Microsoft PSS engineers have been speaking and meeting customers at the PASS Summit....
Author: psssql Date: 09/13/2007
SQL Server 2000 with high LOCK_HASH spinlock contention
I want to make you aware of an update (QFE) to address LOCK_HASH contention during logon and...
Author: psssql Date: 08/28/2007
SQL Server 2005 - RDTSC Truths and Myths Discussed
I posted some updates to my blog entry about the RDTSC and drift warnings in May. See the following...
Author: psssql Date: 08/19/2007
NUMA Connection Affinity and Parallel Queries
The SQL Books Online states that using NUMA port affinity helps co-locate the resources used by the...
Author: psssql Date: 06/28/2007
How to configure Database mirroring for use with ODBC applications?
If you have an ODBC application that is connecting to a mirrored database and if The application...
Author: psssql Date: 06/22/2007
The SQL Server Working Set Message
Work continues around the working set issues. You can find the latest and greatest Information:...
Author: psssql Date: 05/31/2007
SQLIOSim - Outstanding I/O Warnings
I have encountered some questions pertaining to the SQLIOSim outstanding IO warnings and I am...
Author: psssql Date: 04/10/2007
SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained
The dust has now settled after the release of SP2 for SQL Server 2005 so I thought I would take some...
Author: psssql Date: 04/06/2007
SQL Server 2005 Performance Dashboard Reports
The SQL Server 2005 Performance Dashboard reports were recently released as a free download for...
Author: psssql Date: 03/30/2007
SQL Server 2005 SP2 – Trace Event Change – Connection Based Events
Starting with SQL Server 2005 SP2 the connection based events are also produced for...
Author: psssql Date: 03/29/2007
PSS Service Center Labs for PASS 2006
Many folks asked us at PASS last year for these labs. A little late coming but we have these...
Author: psssql Date: 02/26/2007
SQL Server 2005 Performance Statistics Script
Many of you have used the SQL Server 2000 blocker script (see KB 271509) to help troubleshoot...
Author: psssql Date: 02/21/2007
SQL Server 2005 Service Pack 2 has released! Linked Server GUI is back!
SQL Server 2005 Service Pack 2 (SP2) released on Monday to the web. If you want to start downloading...
Author: psssql Date: 02/21/2007
Daylight Savings Time (DST) Changes for 2007 and their impact on SQL Server
As many of you know, Daylight Savings Time (DST) in the United States is changing this year to start...
Author: psssql Date: 02/21/2007
SQL Server Urban Legends Discussed
I have been answering questions on two of the most misunderstood ‘SQL Server Urban...
Author: psssql Date: 02/21/2007
The Importance of the Trace Event Sequence Column and SQL Server 2005 SP2 Changes
Many of us are used to looking at a SQL Trace and making the assumption that the order of display is...
Author: psssql Date: 02/20/2007
SQL 2005 Setup Failures
This week I was reviewing Watson setup failure rates and comparing them to cases opened in the same...
Author: psssql Date: 02/01/2007
SQLServerCentral Interview with Bob Dorr from Microsoft PSS
I want the community to get to know more some of the people that work in Microsoft PSS with SQL...
Author: psssql Date: 01/31/2007
Sample chapter
If you want to get a sampling of the content in the troubleshootting book Bob mentioned, one of the...
Author: psssql Date: 12/21/2006
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...
Author: psssql Date: 12/21/2006
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...
Author: psssql Date: 12/20/2006
Follow-up to PASS 2006
How does anyone keep up with blog posts<g>? I myself have actually been travelling to Redmond...
Author: psssql Date: 12/19/2006
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...
Author: psssql Date: 11/28/2006
What happened to SQLIOStress?
SQLIOStress did not go away it was replaced with SQLIOSim (https://support.microsoft.com/kb/231619)....
Author: psssql Date: 11/27/2006
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...
Author: psssql Date: 11/27/2006
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...
Author: psssql Date: 11/27/2006
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: https://support.microsoft.com/kb/931279...
Author: psssql Date: 11/27/2006
The PSS Service Center at PASS 2006
Back in 2003, Ken Henderson approached me about speaking at PASS in Seattle. I readily accepted to...
Author: psssql Date: 11/10/2006
PSS Presentations at PASS 2006
I thought I would share with you some information about what presentations are being given by the...
Author: psssql Date: 11/09/2006
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....
Author: psssql Date: 11/08/2006
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...
Author: psssql Date: 11/08/2006