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.
SQL Server TempDB – Number of Files – The Raw Truth
I continue to answer questions about the number of TEMPDB files and trace flag –T1118. It...
Author: psssql Date: 06/04/2009
SQL Server, Lock Manager, and “relaxed” FIFO….
An interesting question came in from a customer a few weeks ago. Did SQL Server change its...
Author: psssql Date: 06/02/2009
How It Works: SQL Server Timings and Timer Output (GetTickCount, timeGetTime, QueryPerformanceCounter, RDTSC, …)
A series of questions related to start time, duration, end time, T-SQL waitfor delay command and...
Author: psssql Date: 05/29/2009
How It Works: SQL Server Engine Exception Handling
I was recently asked how SQL Server handles exceptions in the core code of the engine. I looked...
Author: psssql Date: 05/26/2009
How a log file structure can affect database recovery time
We frequently come across situations where databases take a long time to recover. A common scenario...
Author: psssql Date: 05/21/2009
An update for Standard SKU Support for Locked Pages….
Note this article has been updated to include an update for SQL Server 2005I posted in April that we...
Author: psssql Date: 05/19/2009
SQL Server Support Policy for Failover Clustering and Virtualization gets an update…
Last October I posted on our updated policy for support of SQL Server in a virtualization...
Author: psssql Date: 05/19/2009
Upgrading Windows with RS 2005
From an IIS perspective, there were changes between IIS 6 (Windows 2003) and IIS 7 (Windows...
Author: psssql Date: 05/18/2009
How It Works: DBCC MemoryStatus Locked Pages Allocated and SinglePageAllocator Values
I have recently had several questions related to the dbcc memorystatus and associated memory DMV...
Author: psssql Date: 05/15/2009
SQL Server reports working set trim warning message during early startup phase
In the previous posts we have discussed the working set trim message “A significant part of sql...
Author: psssql Date: 05/11/2009
How Do I Determine Which Dump Triggers Are Enabled
_____________________________________________ Subject: RE: dumptrigger questionThey don't survive...
Author: psssql Date: 05/11/2009
SSIS 2005 and the .NET Garbage Collector
I was troubleshooting an SSIS Out of Memory issue the other day which led us into how the .NET...
Author: psssql Date: 05/07/2009
How to use FileStream feature in an ASP.NET Web Application that uses Forms or Anonymous authentication
We have a customer who uses Form based authentication in his ASP.NET application. But he also wants...
Author: psssql Date: 05/06/2009
SQL, Powershell, Windows, Oh My!
I was in the process of setting up a repro for another Blog I’m going to be posting and ran into an...
Author: psssql Date: 05/01/2009
Why Should I Use Extended Events in SQL Server 2008?…
You may or may not have heard of a new diagnostic technology in SQL Server 2008 called Extended...
Author: psssql Date: 04/30/2009
SQL Server, Locked Pages, and Standard SKU…
I made an announcement today while speaking at Europe PASS 2009 that we will be providing a method...
Author: psssql Date: 04/24/2009
SQL Server and the Bad CPU
From time to time I encounter an issue where the physical CPU is the source of the problem. I hope...
Author: psssql Date: 04/21/2009
Speaking at European PASS 2009….
I’m leaving this weekend to travel to Europe to speak at the European PASS 2009 Conference in...
Author: psssql Date: 04/14/2009
SQL Server 2008 SP1 and Cumulative Updates Explained.....
NOTE: I've made a change to this blog post to account for the fact that actually 6 fixes in CU4 for...
Author: psssql Date: 04/09/2009
The 3 Things you Need to Know to Install SQL 2005 on Windows 2008 Cluster
Today I was walking a counterpart through installing SQL Server 2005 cluster on a Windows Server...
Author: psssql Date: 04/08/2009
Troubleshooting sp_xp_cmdshell_proxy_account Errors
I was attempting to establish the command shell proxy on my local machine and ran into a series of...
Author: psssql Date: 04/07/2009
Updated Errors may occur after configuring Analysis Services to use Kerberos authentication on Advanced Encryption Standard Aware Operating Systems
The Microsoft SQL Server Analysis Services support team has seen an increasing number of issues...
Author: psssql Date: 04/03/2009
SQL 2005: SQL Server Configuration Manager Error: Connection to target machine could not be made in a timely fasion.
There is a bug with the message spelling (fasion instead of fashion) but that is not the focus of...
Author: psssql Date: 03/31/2009
SQLDumper unable to generate mdmp files in SQL Server 2008 Failover clusters
SQLDumper utility is used by various components of the product to generate and save diagnostic...
Author: psssql Date: 03/29/2009
Parallel Index Creation performance issue
Both SQL Server 2005 and 2008 allow you to do parallel index creation. In fact you can specify...
Author: psssql Date: 03/18/2009
SQL Server: What is a COLD, DIRTY or CLEAN Buffer?
Sent: Tuesday, March 17, 2009 2:05 AM Subject: what is clean buffer? what is cold buffer cache? I...
Author: psssql Date: 03/17/2009
How It Works: What Are The Event Source Names Used By SQL Server
Sent: Tuesday, March 17, 2009 4:24 AM Subject: Event Source changed from MSSQLServer to MSSQLSERVER...
Author: psssql Date: 03/17/2009
How to fix your SQL Server 2008 Setup before you run setup (Part II)....
NOTE: Now updated for SQL Server 2008 SP1 RTM. Last year you might have read my post where I showed...
Author: psssql Date: 03/17/2009
SQL Server 2008 Ring Buffer Entries
Sent: Monday, March 09, 2009 6:20 PM Subject: Ring Buffers in SQL2008 Hi, do you have any...
Author: psssql Date: 03/13/2009
How to use computed columns to improve query performance
In general, you should avoid applying a scalar function on a column when comparing against another...
Author: psssql Date: 03/08/2009
SocketException when creating a new Report Server Database
We had a customer call up that encountered a problem when trying to create a new database for their...
Author: psssql Date: 03/05/2009
Sparse File Errors: 1450 or 665 due to file fragmentation: Fixes and Workarounds
You might be familiar with the sparse file problem that Bob Dorr has blogged about in the past....
Author: psssql Date: 03/03/2009
How It Works: SQL Server - VDI (VSS) Backup Resources
Last week I worked on an interesting case. The issue was a NT Backup against a single...
Author: psssql Date: 03/03/2009
Troubleshooting: SQL Server (2005, 2008) Performance Counter Collection Problems
I was asked by our support team to help outline performance counter troubleshooting when the...
Author: psssql Date: 03/03/2009
How It Works: Almost Everything You Wanted To Know About The SQL Server (2005, 2008) Performance Counter Collection Components
I will be posting a troubleshooting companion to this 'How It Works' that outlines the associated...
Author: psssql Date: 03/03/2009
You encounter error message "The system cannot find the file specified" when attempting to perform backups using sqlvdi
Symptoms you encounter: SQL Server 2000 SP4 x86 is installed on a Windows 2003 X64 server. You use...
Author: psssql Date: 02/26/2009
SQL Server 2005 and 2008 Setup Failures (Compressed DATA Directory)
We are always looking at customer issue reports in order to improve our software and your...
Author: psssql Date: 02/24/2009
How It Works: Resource Governor 'INTERNAL' Group
From: Customer Sent: Friday, February 20, 2009 2:04 PM I have seen sometimes a user connection...
Author: psssql Date: 02/23/2009
SQL Server 2005 or 2008 Reporting Error 17883 - Stalled Scheduler Warnings
SQL Server 2005 introduced a background worker to flush trace event streams. The trace buffer is...
Author: psssql Date: 02/20/2009
SQL Server: Is CHECKDB A Necessity?
From: SQL Server Customer Sent: Friday, February 20, 2009 5:08 AM I’m often asked by...
Author: psssql Date: 02/20/2009
How to copy DTS 2000 packages between servers (and from SQL 2000 to SQL 2005 and SQL 2008)
I was posed the question today, how do I migrate my SQL Server 2000 DTS packages to a SQL 2005...
Author: psssql Date: 02/18/2009
Searching for Duplicate SPN's got a little easier
We get a lot of calls related to Kerberos configuration, and I'm planning to write more about our...
Author: psssql Date: 02/13/2009
How It Works: File Stream Compression with Backup/Restore
The question of file stream compression during backup and restore arose last week and makes for a...
Author: psssql Date: 02/11/2009
PRB: RML Utilities - ReadTrace processing fails with "Attempt to use an invalid variant type"
SummaryReadTrace processing may unexpectedly fail with the following error: A serious error...
Author: psssql Date: 02/11/2009
RML Utilities: Recommended SQL Server 2008 updates for ReadTrace processing
There have been a couple of SQL Server 2008 fixes shipped in recent Cumulative Updates, that address...
Author: psssql Date: 02/11/2009
How to troubleshoot leaked SqlConnection Objects (.NET 2.0) - Part 2
In the last post in this series, we looked at how we can determine that our Connection pool was...
Author: psssql Date: 02/10/2009
SQLIOSim: Default Testing Pattern
The SQLIOSim knowledge base article outlines the various configuration files in detail....
Author: psssql Date: 02/09/2009
Why aren't my subscriptions working?
I ran across an interesting issue the other day with subscriptions not firing. I had never ran...
Author: psssql Date: 02/02/2009
PRB: RML Utilities - Reporter errors during report rendering
SummaryOn a sporadic basis you may encounter any one of the following errors while rendering reports...
Author: psssql Date: 01/29/2009