Welcome to MSDN Blogs Sign in | Join | Help

March 2008 - Posts

Friday, March 28, 2008 8:04 PM

How It Works: Non-Yielding Resource Monitor

I have addressed similar conditions error in a white paper: www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx 2008-01-20 19:01:26.11 Server      ***Stack Dump being sent to K:\MSSQL.3\MSSQL\LOG\SQLDump0001.txt
Posted by psssql | 0 Comments
Friday, March 28, 2008 7:03 PM

How It Works: SQL Server 2005 DBCC Shrink* May Take Longer Than SQL Server 2000

SQL Server 2005 adds additional shrink logic to compress TEXT/IMAGE data, referred to as LOBs.     The dbcc shrink* code uses the same underlying methods that ALTER INDEX .... WITH (LOB_COMPACTION ON) uses to compact the LOB space
Posted by psssql | 2 Comments
Monday, March 24, 2008 7:51 PM

How It Works: SQL Server 2008 Backup Compression, Database Compression and Total Data Encryption

I have seen a fair series of questions around the compression and encryption features of SQL Server 2008.   The main question is can I or should I used Total Data Encryption (TDE) and backup compression? All these features work with each other
Posted by psssql | 1 Comments
Filed under: ,
Monday, March 24, 2008 7:34 PM

How It Works: SQL Server 2005 SP2 Security Ring Buffer - RING_BUFFER_SECURITY_ERROR

SQL Server 2005 SP2 added new ring buffer entries ( sys.dm_os_ring_buffers ) for various security errors.   The reason the ring buffer entries are added was to provide the DBA with more details as to why a client is receiving a failed login
Posted by psssql | 1 Comments
Filed under: ,
Monday, March 24, 2008 6:55 PM

How It Works: DBCC ShrinkDatabase / ShrinkFile (Tabular)

I ran across an undocumented option that was very helpful in resolving an issue last week.   WARNING: As always any undocumented syntax can change and may not be supported.  This should be used under the guidance of Microsoft SQL Server
Posted by psssql | 1 Comments
Filed under: ,
Monday, March 24, 2008 6:30 PM

How It Works: Shapshot Database (Replica) Dirty Page Copy Behavior (NewPage)

I ran into an issue last week that I found interesting and thought you might find it interesting as well. The primary database had a replica (snapshot database) established and the issue reported was that the replica was acquiring additional space when
Posted by psssql | 1 Comments
Filed under: ,
Tuesday, March 18, 2008 4:42 PM

How It Works: SQL Server 2005 I/O Affinity and NUMA Don't Always Mix

Recently I have fielded several questions related to I/O affinity.  Allow me to outline the behavior and clear up misconceptions. When I/O affinity is enabled SQL Server creates a hidden scheduler for the Log Writer process as well as a special lazy
Posted by psssql | 0 Comments
Filed under: , ,
Wednesday, March 05, 2008 4:51 PM

How It Works: SQLIOSim - Checksums

SQLIOSim, like its predecessor SQLIOStress, is designed to read pages it has written and validate the data.   SQLIOSim does this using a checksum algorithm. When SQLIOSim starts up it creates a set of buffers and used the Cryto APIs to generate
Posted by psssql | 1 Comments
Filed under: , , ,
Monday, March 03, 2008 3:41 PM

SQL Server Working Set Trim Problems? - Consider...

Microsoft support continues to receive a steady flow of cases indicating poor, SQL Server performance symptoms.   When the issue is narrowed down we are finding that the working set of SQL Server and many of the processes on the computer have
Posted by psssql | 2 Comments
Filed under: , ,
Monday, March 03, 2008 3:31 PM

How It Works: Debugging SQL Server Stalled or Stuck I/O Problems - Root Cause

Previously I have covered stuck and stalled I/O issues in other posts and articles.  However, these only tell you that there is a problem outside the SQL Server engine.   This post attempts to extend your root cause debugging capabilities
Posted by psssql | 1 Comments
 
Page view tracker