Press "Enter" to skip to content

Checking the Age of Statistics

Kevin Hill points out that statistics in SQL Server are not like a fine wine:

I was trying to troubleshoot some TerriBad * tempdb write performance…almost 3000ms per write, on a server that we recently migrated to.

Our data center vendor of course said the storage was perfect and that we should try troubleshooting SQL Server.  (Duh?)

Read on for what Kevin found.

One Comment

  1. George Walkey
    George Walkey2021-10-01

    SQL is always bad, the SAN is always fine!

Comments are closed.