Tag: SQL Assessment

Vintage databases are not as good as vintage cars

Should I Upgrade SQL Servers that Are Out of Support?

Do All SQL Servers Need to Be Upgraded? Running production systems on a platform that is no longer supported by the vendor is worrisome. If something goes wrong, you’ll no longer be able to call the vendor and receive technical support. But worse, you’ll no longer release updates, fixes, security patches, etc, for the out…
Read more

A properly configured SQL Server is like a well tuned race engine.

Identify Disk I/O Performance Issues for Your SQL Server Using DiskSpd

“We need faster storage.” Sound familiar? Or what about “No, the storage is good; we need to tune the database.” Often teams will have very different opinions about the root cause of a performance issue. Microsoft’s free DiskSpd utility can help identify disk I/O performance issues for your SQL server systems. Here’s a short introduction…
Read more