Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Troubleshooting: The DB Engine   (RSS)

SQL Server 2005 Encounters Exception During Install When System has Odd Number of Processors or Logical Processors Per Core

While attempting to install SQL Server 2005 you may encounter an error familiar to the following and a retry option presented by setup. Faulting application sqlservr.exe, version 2005.90.1399.0, time stamp 0x434f82e9, faulting module sqlservr.exe, version

SQL Server reports operating system error 1450 or 1452 or 665 (retries)

Overview The error: 1450/1452 insufficient system resources exist to complete the requested service. These are not a SQL Server based errors. The error cause is related to a depleted system resource (non-paged pool, paged pool ,...). These issues have

SQL Server I/O Bottleneck, I don't have one, YES YOU DO!

The mistake I see people make is when looking at the SQL Server PAGE I/O waits and stalled I/O warnings is when comparing it to the Avg. Disk Seconds/Transfer.    Everyone seems to forget that average means average and they look at the

Query Performance issues associated with a large sized security cache

In the past couple of months, SQL Server support team has come across some customers running into performance issues attributed to TokenAndPermUserStore in SQL Server 2005. This blog post attempts to compile all the information we have so far regarding

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

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.

SQL Server 2005 Memory Limits and Related Questions

I had a very nice conversation this week with one of the blog readers.   The question related to adding more memory to their server.   It lead to an exchange of various links that I think you might find handy.  We discussed the

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

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

Do I have to assign the Lock Pages in Memory privilege for Local System?

NOTE: I've updated this because of some questions about 32bit systems. Some who attended one of my talks at the recent PASS conference asked me the following question "Do I need to use the Group Policy Editor to assign the Lock Pages in Memory privilege

Database compatibility and new features

Have you attempted to execute queries using some of the new keywords and constructs only to see error messages like the following? Msg 321, Level 15, State 1, Line 5 "sql_handle" is not a recognized table hints option. If it is intended as a parameter

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 link http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx

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 it. Please check out these links on Amazon and Barnes and Nobles for purchasing the book at discounts from the retail price: http://www.amazon.com/SQL-Server-2005-Practical-Troubleshooting/dp/0321447743/sr=8-1/qid=1165872513

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 you about a book that I contributed to that is hot off the presses called SQL Server 2005 Practical Troubleshooting: The Database Engine http://www.aw-bc.com/catalog/academic/product/0,1144,0321447743,00.html
 
Page view tracker