Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » How It Works   (RSS)
Wednesday, June 25, 2008 3:01 PM

How It Works: Trace (.TRC) File Security

SQL Server 2000 shipped with different trace file security than later builds of SQL Server 2000, SQL Server 2005 and SQL Server 2008. The SQL Server process (sqlservr.exe) writes the trace files to the specified destination.   The SQL Server
Posted by psssql | 2 Comments
Wednesday, June 18, 2008 9:32 PM

How It Works: More on DBCC Shrink* Activities

My peers are starting to tease me about becoming a dbcc shrink* expert. (Ha, Ha I said.)  Then, I uncovered another design facet about shrinkfile helping with a SQL Server 2000 case.  The situation:     dbcc shrinkfile, with EMPTYFILE,
Posted by psssql | 1 Comments
Filed under: ,
Thursday, May 22, 2008 3:42 PM

How It Works: SQL Server 2005 - Possible data recovery when checksum failure reported

I and Microsoft will always opt for restore of a backup when corruption of the database is encountered.   This is the only way to safely restore the database to a known state.   All other actions, such as dbcc repair, can remove data
Posted by psssql | 0 Comments
Monday, April 21, 2008 3:12 PM

How It Works: What is a Sleeping / Awaiting Command Session

This issue is as old as SQL Server.  In fact, it goes back to Sybase days but continues to fool and puzzle administrators. A session with that status of sleeping / awaiting command is simply a client connection with no active query to the SQL Server.
Posted by psssql | 1 Comments
Friday, April 11, 2008 5:51 PM

How It Works: SQL Server Checkpoint (FlushCache) Outstanding I/O Target

I ran into an issue yesterday that brought up questions as to how the checkpoint's max outstanding, I/O target is determined.   There is different behavior across the various versions of SQL Server and it would take an entire white paper to
Posted by psssql | 0 Comments
Filed under: ,
Thursday, April 10, 2008 5:39 PM

How It Works: File Streams Requires Integrated Security (Windows Authentication)

SQL Server authentication versus Windows Authentication seems to cause File Stream users confusion.   I thought this e-mail chain would help. From: Robert Dorr Subject: RE: OpenSqlFilestream problem   It is really not the SQL Server Service
Posted by psssql | 1 Comments
Tuesday, April 08, 2008 6:55 PM

How It Works: SQL Server Page Allocations

  When I drop an object why does SQL Server not immediately re-use those extents for a new object?  This is because the storage engine is optimized for speed to continue allocating new extents from available free space in the file rather than
Posted by psssql | 1 Comments
Filed under: ,
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: , , ,
More Posts Next page »
 
Page view tracker