Press "Enter" to skip to content

Checking the Age of Statistics

Published 2021-10-01 by Kevin Feasel

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.

Published in Statistics

One Comment

  1. George Walkey
    George Walkey2021-10-01

    SQL is always bad, the SAN is always fine!
    *crying*

Comments are closed.