Welcome to MSDN Blogs Sign in | Join | Help

August 2009 - Posts

Wednesday, August 26, 2009 8:45 PM

Come on 64bit so we can leave the mem….

I recently saw a question the other day about some errors that indicate memory pressure for the SQL Server Engine and how it might be related to the infamous “MemToLeave” for SQL Server. The problem with this situation was that the errors were happening
Posted by psssql | 0 Comments
Filed under:
Friday, August 21, 2009 7:50 PM

SSMS Fails to restore with SQL 2000 instances and SSMS Versioning Explained….

I recently have been on vacation. When I returned I noticed an interesting issue that deserves some details and explanation in case you encounter the problem. As part of this explanation, I’ll give you some information about how the “version” of SQL Server
Posted by psssql | 0 Comments
Thursday, August 20, 2009 8:23 PM

High CPU consumed by Resource Monitor due to low virtual memory

We have had a few customers who hit the issue where Resource Monitor consumed a significant portion of CPU in SQL Server 2008. This is a known issue that has been fixed in SQL Server 2008 RTM CU 6 ( http://support.microsoft.com/kb/968722/ ). Next CU release
Posted by psssql | 0 Comments
Filed under:
Tuesday, August 18, 2009 5:30 PM

SQL Server Cumulative Update or Service Pack Fails With - CREATE DATABASE failed

Here is a situation where a cumulative update patch can fail if the default database path for the data and/or log either does not exist, or there is a permissions issue.  This example is based on a SQL Server 2005 Cumulative Update 4 for SP3. 
Posted by psssql | 0 Comments
Wednesday, August 05, 2009 10:19 PM

Why doesn't SQL Server use index seek with this query?

Lately we had a customer who has a query with left outer join. From looking at the indexes and statistics and filtering conditions, our instinct tells us that SQL Server should have used index seek. But supprisingly, SQL Server uses index scan. The table
Posted by psssql | 0 Comments
Filed under:
 
Page view tracker