SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Performance Tuning, tempdb Rss

   Items 1 to 1 of 1   

How to Performance Tune the Microsoft SQL Server tempdb Database

If your SQL Server’s tempdb database is heavily used by your application(s), consider locating it on an array of its own (such as RAID 1 or RAID 10). This will allow disk I/O to be more evenly distributed, reducing disk I/O contention issues, and speeding up SQL Server’s overall performance.  Read more...
By Additional Articles 2011/08/31 | Source: SQL Server Performance | Category: tempdb
Rating:  Rate this |   Briefcase | 5,132 reads
   Items 1 to 1 of 1