14 December 2010

Optimize tempdb Performance

To optimize tempdb Performance in a production environment:
1) Set the recovery model of tempdb to SIMPLE.
2) Allow for tempdb files to automatically grow as required.
3) Set the file growth increment to a reasonable size. Set it to 10% of the file size, with a minimnum of 10MB
4) create one data file for each CPU on the server, note that a dual-core CPU is considered to be two CPUs.
5) Make each data file the same size; this allows for optimal proportional-fill performance.
6) Put the tempdb database on a fast I/O subsystem. Use disk striping if there are many directly attached disks.
7) Put the tempdb database on dedicated disks.

Other Blogs

Disclaimer

1) The owner of this blog is not to be held responsible for any damage, loss or problem, including any interference or damage to a visitor’s computer, software or data, in relation to the use of this blog or it's content.
2) All the blog content is provided "as is" without warranty of any kind. Use it at your own risk. The owner of the blog is not to be held responsible for any loss or damage suffered by you or any third party .
3) All comments expressed by visitors are not endorsed by the owner of this blog.
4) The owner of this blog reserves the right to filter all published content, including comments.
5) All links provided at this blog are provided for the convenience of visitors. The owner of this blog is not to be held responsible for the content or use of these links.
6) The terms and conditions of this blog are subjected to change without prior notice.