Should I move tempdb file to own spindle?
Posted on 2010-11-19
I just joined an org that has never put the tempdb on it's own physical drive/raid-set. They have performance issues but are convinced it's due to something other than the tempdb. Short of taking down one of the live systems to test (they don't have a test lab), what perfmon counters should I look at to see if in fact the tempdb file is a bottleneck for them? They have some systems where it's on the same drive as the OS/page file and some where it's on the same drive as the database.