Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Troubleshooting: The DB Engine   (RSS)
Monday, October 26, 2009 5:35 PM

Reduce locking and other needs when updating data - Better Performance

The following pattern typically stems from an old practice used in SQL 4.x and 6.x days, before IDENTITY was introduced. begin tran declare @iVal int select @iVal = iVal from CounterTable (HOLDLOCK) where CounterName = 'CaseNumber' update CounterTable
Posted by psssql | 0 Comments
Wednesday, July 08, 2009 8:11 PM

Attach of the Clone (… Databases)

Sorry Star Wars fans to mislead you. I thought our readers should know about a feature we use quite a bit in CSS called a “Clone Database”. It is better publically now known as a “Statistics-Only” copy of the database. Why is this useful? Because it provides
Posted by psssql | 1 Comments
Wednesday, July 08, 2009 5:03 PM

Q&A on Latches in the SQL Server Engine….

I recently received a request to shed some light on a few advanced questions about latches and SQL Server. These were good questions so I thought the information might be useful to share with the community. I’ll provide this information in the form of
Posted by psssql | 1 Comments
Tuesday, May 19, 2009 2:43 PM

An update for Standard SKU Support for Locked Pages….

Note this article has been updated to include an update for SQL Server 2005 I posted in April that we would be releasing cumulative updates for SQL Server 2008 and 2005 to support the concept of Locked Pages for SQL Server Standard. SQL Server 2008 Cumulative
Posted by psssql | 3 Comments
Tuesday, May 12, 2009 5:46 AM

SQL Server reports working set trim warning message during early startup phase

In the previous posts we have discussed the working set trim message “ A significant part of sql server process memory has been paged out ” that gets written to the SQL Server Error log. You can find the details about the various parameters that determine
Posted by psssql | 1 Comments
Thursday, April 30, 2009 4:44 PM

Why Should I Use Extended Events in SQL Server 2008?…

You may or may not have heard of a new diagnostic technology in SQL Server 2008 called Extended Events (XEvent). I thought I would post an example of why this technology can do things nothing else we have can when you deploy SQL Server 2008. Someone internally
Posted by psssql | 2 Comments
Friday, April 24, 2009 12:14 PM

SQL Server, Locked Pages, and Standard SKU…

I made an announcement today while speaking at Europe PASS 2009 that we will be providing a method for customers using standard SKU for SQL Server 2005 and 2008 to use the ‘Locked Pages in Memory’ privilege to allow the server to use the AWE APIs. This
Posted by psssql | 10 Comments
Tuesday, April 21, 2009 3:20 PM

SQL Server and the Bad CPU

From time to time I encounter an issue where the physical CPU is the source of the problem.   I hope you never encounter such and issue but I wanted to provide an example to help those that will. Customer started getting frequent dumps from
Posted by psssql | 1 Comments
Monday, March 30, 2009 12:38 AM

SQLDumper unable to generate mdmp files in SQL Server 2008 Failover clusters

SQLDumper utility is used by various components of the product to generate and save diagnostic information in the form of mini-dump and other log files. You will normally find the output files [with extension .mdmp, .txt and .log] created by sqldumper.exe
Posted by psssql | 1 Comments
Wednesday, March 04, 2009 4:30 AM

Sparse File Errors: 1450 or 665 due to file fragmentation: Fixes and Workarounds

You might be familiar with the sparse file problem that Bob Dorr has blogged about in the past. http://blogs.msdn.com/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx . We wanted to update you with the
Posted by psssql | 0 Comments
Thursday, February 26, 2009 6:09 AM

You encounter error message "The system cannot find the file specified" when attempting to perform backups using sqlvdi

Symptoms you encounter: SQL Server 2000 SP4 x86 is installed on a Windows 2003 X64 server. You use x64 backup applications to perform backups of databases. These backup applications use sqlvdi to interact with the SQL Server. You installed the sqlvdi.dll
Posted by psssql | 1 Comments
Friday, February 20, 2009 5:41 PM

SQL Server 2005 or 2008 Reporting Error 17883 - Stalled Scheduler Warnings

SQL Server 2005 introduced a background worker to flush trace event streams.   The trace buffer is flushed when it becomes fully populated but a partially populated trace buffer remains in-memory until events fill the buffer or the background
Posted by psssql | 1 Comments
Friday, February 20, 2009 3:36 PM

SQL Server: Is CHECKDB A Necessity?

From: SQL Server Customer Sent: Friday, February 20, 2009 5:08 AM   I’m often asked by professionals whether CheckDB is still recommended on SQL2k8.  SQL is calculating a checksum to avoid physical page corruption since 2k5. However in
Posted by psssql | 1 Comments
Monday, February 09, 2009 5:22 PM

SQLIOSim: Default Testing Pattern

The SQLIOSim knowledge base article outlines the various configuration files in detail.  http://support.microsoft.com/kb/231619 - How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem. I still get inquires about what
Posted by psssql | 1 Comments
Wednesday, December 17, 2008 8:01 PM

SQL Server (2005 and 2008) Trace Flag 1118 (-T1118) Usage

Trace flag 1118 forces uniform extent allocations instead of mixed page allocations.   The trace flag is commonly used to assist in TEMPDB scalability by avoiding SGAM and other allocation contention points. SQL Server 2008 optimized mixed extent
Posted by psssql | 1 Comments
More Posts Next page »
 
Page view tracker