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 […]