SQLServerCentral.com Articles tagged tempdb

SQL Server 2012 Cluster with TempDB on Local Disk

Thu, 20 Dec 2012 07:00:00 UT

With the introduction of SQL Server 2012 Microsoft officially supports local disk TempDB in SQL Server cluster configurations. This tip will show you how to configure TempDB on a local disk when installing your SQL Server 2012 cluster.

Has tempdb grown since the last restart?

Tue, 20 Nov 2012 07:00:00 UT

Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance.

Optimizing tempdb configuration with SQL Server 2012 Extended Events

Tue, 07 Aug 2012 06:00:00 UT

One of the most obvious bottlenecks in the performance of tempdb is caused by PAGELATCH, in-memory latch contention on the allocation bitmap of each data file used. We can use one of the rules-of-thumb to choose what should be roughly the best number of files, but how then do you check to see whether you've got it right for your data and workload?

Temporary Tables in SQL Server

Thu, 22 Sep 2011 06:00:00 UT

Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or exploit all their advantages. They can improve your code's performance and maintainability, but can be the source of grief to both developer and DBA if things go wrong and a process grinds away inexorably slowly. We asked Phil Factor for advice, thinking that it would be a simple explanation.

How to Performance Tune the Microsoft SQL Server tempdb Database

Wed, 31 Aug 2011 06:00:00 UT

If your SQL Server’s tempdb database is heavily used by your application(s), consider locating it on an array of its own (such as RAID 1 or RAID 10). This will allow disk I/O to be more evenly distributed, reducing disk I/O contention issues, and speeding up SQL Server’s overall performance.

Tempdb Space Usage in SQL Server

Tue, 28 Jun 2011 06:00:00 UT

We all know how important tempdb is and know that tempdb gets recreated every time SQL Server is restarted. Here we dig a little deeper to focus on how space is used inside tempdb.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Setting All Tempdb Data Files to the Same Size

Mon, 19 Jul 2010 06:00:00 UT

How to set all tempdb datafiles to same size to meet best practice.

SQL Server Tempdb Usage and Bottlenecks tracked with Extended Events

Tue, 13 Oct 2009 06:00:00 UT

How do I effectively find out if the Tempdb database is suffering from an allocation bottleneck? Should I create multiple TempDB files per core on this server to improve performance? How do I check this information programmatically?

Re-size TempDB files

Fri, 03 Apr 2009 06:00:00 UT

Managing TempDB can be a bit tricky at times. Most people know how to increase the size, but what about reducing it? New author Amar Pogaku brings us two techniques for shrinking tempdb.

SQL Q & A: Database Consistency, Temporary Tables, and More

Fri, 27 Mar 2009 06:00:00 UT

Why does DBCC CHECKDB find corruption errors that disappear? Does tempdb really cause performance issues? Are there any drawbacks to using the FILESTREAM datatype? Paul Randal answers these reader questions and more.

Moving TempDB - SQL School Video

Tue, 30 Dec 2008 07:00:00 UT

Moving databases is fairly simple, but when you move a system database, there are a few extra steps to follow. MVP Brian Knight walks us through how to move temdb in this video.