Blitz Result: Slow Storage Reads or Writes

https://www.brentozar.com/blitz/slow-storage-reads-writes/ SQL Server feels the need – the need for speed.  Storage speed, to be more specific.  One of the most common bottlenecks is underperforming storage subsystems. SQL Server tracks read and write speeds for each database file – both data and log files.  This part of our SQL Server sp_Blitz script checks sys.dm_io_virtual_file_stats looking for average... » read more

DBCC CHECKDB Not Run Recently

https://www.brentozar.com/blitz/dbcc-checkdb-not-run-recently/ When SQL Server writes data to your drives, it just assumes everything’s okay until it needs to read the data back again. Unfortunately, in the event of storage corruption, the storage isn’t so kind as to alert SQL Server.  And sometimes, SQL Server has even been known to corrupt itself. We need to periodically check... » read more