Welcome to MSDN Blogs Sign in | Join | Help

WHITEPAPER – Working with Tempdb in SQL 2005

Tempdb has undergone a number of changes in SQL Server 2005.

 

Planning for tempdb deployment, configuring it for best throughput and continuously monitoring usage are critical for ensuring higher performance for your server.

 

In this whitepaper, you will learn about:

 

  • Enhancements in tempdb in SQL 2005
  • Identifying space requirements for your tempdb
  • Monitoring tempdb space usage on your server
  • Best practices for configuring and maintaining tempdb
  • Troubleshooting performance issues related to tempdb

You can download this article from here.

 

Happy reading.

 

POSTED BY : Sanchan Saxena
Published Monday, September 25, 2006 11:18 PM by sqlblog
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: WHITEPAPER – Working with Tempdb in SQL 2005

Could you tell us more abut the new "deferred drop" feature? Or point to an URL with more detailed information?
Tuesday, September 26, 2006 1:40 PM by Dean

# re: WHITEPAPER – Working with Tempdb in SQL 2005

Currently, the most relevant and updated information on "deferred drop" is available in this whitepaper as a bullet point.

I certainly understand that there is a need for more information on this.

However, I would first like to understand what specific questions you have about this feature? Let me know and we can get a blog content organized on this topic.

Thanks
SQL Support Team
Tuesday, September 26, 2006 9:45 PM by sqlblog

# re: WHITEPAPER – Working with Tempdb in SQL 2005

thank you

Friday, October 20, 2006 11:15 AM by jeff reiter

# re: WHITEPAPER – Working with Tempdb in SQL 2005

thank you

Friday, October 20, 2006 1:06 PM by jeff reiter

# re: WHITEPAPER – Working with Tempdb in SQL 2005

Could you tell me how to move a sql server 2005 tempdb to a mountpoint as I cannot get it to work using alter database ...

Wednesday, May 09, 2007 7:13 AM by Kayode

# re: WHITEPAPER – Working with Tempdb in SQL 2005

Could you tell me how to move a sql server 2005 tempdb to a mountpoint as I cannot get it to work using alter database ...

Wednesday, May 09, 2007 7:31 AM by Kayode

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker