Optimizing TempDB Performance

Today I thought I would blog about TempDB performance.  On one of my new servers, with 24 cores, I allocated eight TempDB files as that should be enough to distribute the load, reduce contention and improve performance.  However, I forgot to restart the server after hours and it went on for a week and performance did not improve.  It was at this point that I discovered that the files were not be proportionately filled.  A simple Server restart resolved the issue and now it is running like a champ. 

For more advice, check out Microsoft’s guidelines for Optimizing tempdb Performance.



About SQLGator

Florida Gator and Microsoft Data Platform MVP, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server DBA who dabbles with VMWare, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on February 23, 2012, in Maintenance and tagged , . Bookmark the permalink. 1 Comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: