Tempdb configuration and performance

How to modify SQL Server's tempdb database configuration for maximum performance by utilising file striping and traceflags to control autogrow and disk allocation to reduce metadata (PFS page) contention.

This is hardly a new topic and whilst there are a lot of articles out there instructing us on how to stripe tempdb etc I feel there’s a bit of a gap on exactly how to identify a problem with tempdb in the first place and particularly on finding out how much of your overall […]

Impact of Fusion-io based tempdb on reindex duration

Tuning tempdb performance with FusionIO cards is a given but you may not be taking full advantage if reindexing is left on default settings.

Do you have tempdb on Fusion-io (or equivalent) technology? Is your reindexing job left on default settings (re-orgs at 5-15% and full rebuilds at @ 30%)? If so, then you might be interested in the findings in this post. The benefits of flash memory as a replacement for spinning drives in order to boost SQL […]