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

Comments (6)

  1. Kayode says:

    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 …

  2. Kayode says:

    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 …

  3. jeff reiter says:

    thank you

  4. jeff reiter says:

    thank you

  5. 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

  6. Dean says:

    Could you tell us more abut the new "deferred drop" feature? Or point to an URL with more detailed information?