Mar
14
2012

Managing and Optimizing Tempdb in SQL Server

We often come across situations where there is contention in tempdb or tempdb is getting oversized, etc. better planning of tempdb may avoid performance issues if it is being used heavily and also reduce administration effort, below article is basically focussed on the planning stage of tempdb to reduce administration effort and avoid performance issues, Source: http://support.microsoft.com/kb/328551, http://www.sqllion.com/2009/05/optimizing-tempdb-in-sql-server-2005/ Tempdb is one of the system database in SQL Server, all user data is lost from tempdb […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 241 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

March 2012
M T W T F S S
« Feb   Apr »
 1234
567891011
12131415161718
19202122232425
262728293031  

View Post by Categories

%d bloggers like this: