Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » How It Works » Engine   (RSS)
Wednesday, September 03, 2008 3:55 PM

How It Works: 17888 - All Schedulers on Node Appear Deadlocked

Error 17888: All schedulers on Node ## appear deadlocked due to a large number of worker threads waiting on <<RESOURCE>>. Process Utilization ##%. SQL Server creates a Scheduler Monitor thread for each node.    One of the Scheduler
Posted by psssql | 1 Comments
Filed under: , ,
Tuesday, August 19, 2008 9:18 PM

How It Works: SQLIOSim [Audit Users] and .INI Control File Sections with User Count Options

The Page Audit User is one of the main execution paths for data integrity checking.   SQLIOSim runs test cycles and during each test cycle the [Audit User] section of the .INI configuration file is used.  These workers perform various page
Posted by psssql | 1 Comments
Filed under: , ,
Wednesday, July 23, 2008 9:01 PM

How It Works: Attention, Attention or Should I say Cancel the Query and Be Sure to Process Your Results

I ran into this issue the other day and decided it would make a good post.  Since I have seen this issue more times that I can count I will again attempt to provide details. The attention event in SQL Server trace output indicates a query cancellation.  
Posted by psssql | 2 Comments
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 | 3 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: ,
More Posts Next page »
 
Page view tracker