Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Troubleshooting: The DB Engine   (RSS)
Wednesday, July 23, 2008 7:45 PM

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
Posted by psssql | 0 Comments
Thursday, July 10, 2008 4:15 PM

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
Posted by psssql | 1 Comments
Tuesday, July 08, 2008 2:24 PM

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
Posted by psssql | 1 Comments
Monday, June 16, 2008 5:20 AM

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
Posted by psssql | 3 Comments
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
Saturday, April 05, 2008 6:04 PM

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
Posted by psssql | 0 Comments
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
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
Thursday, October 18, 2007 3:46 PM

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
Posted by psssql | 8 Comments
Tuesday, October 16, 2007 3:16 PM

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
Posted by psssql | 2 Comments
Sunday, August 19, 2007 4:46 PM

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
Posted by psssql | 4 Comments
Thursday, December 21, 2006 5:42 PM

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
Posted by psssql | 0 Comments
Wednesday, December 20, 2006 5:10 PM

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
Posted by psssql | 0 Comments
 
Page view tracker