Partager via

WHITEPAPER – Working with Tempdb in SQL 2005

  • Article

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

  • Anonymous
    September 26, 2006
    Could you tell us more abut the new "deferred drop" feature? Or point to an URL with more detailed information?

  • Anonymous
    September 26, 2006
    The comment has been removed

  • Anonymous
    October 20, 2006
    thank you

  • Anonymous
    October 20, 2006
    thank you

  • Anonymous
    May 08, 2007
    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 ...

  • Anonymous
    May 08, 2007
    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 ...