Group cached statements by query_hash to find high total CPU and reads, compare plan hashes, and account for missing cache history.
SQL SERVER – Express and SQL Server Agent – Free Alternative
Small Express database, big performance problems? Here is a free alternative that fills the gap between SQL Server Express and SQL Server Agent jobs.
SQL SERVER – Huge Size of Table catalog.execution_component_phases in SSISDB
SSISDB was huge, and the biggest table was catalog.execution_component_phases. Here is what fills it, like retention period and logging level.
Error 19407: The Lease Between the Availability Group and the Cluster Expired
Error 19407 means the lease between an availability group and the Windows Server Failover Cluster has expired, and the group goes to Resolving. Here is what each ERRORLOG line says and what to look at first.
What is the Difference between SUSPECT and RECOVERY PENDING? – Interview Question of the Week #114
What is the difference between SUSPECT and RECOVERY PENDING? A reader moved databases to a new drive and they went into recovery pending. Here is why.
Error 468: Could Not Use View sysdac_instances Because of Binding Errors
Error 468 appeared as soon as we right clicked a database in SQL Server Management Studio. The view msdb.dbo.sysdac_instances could not be used because of binding errors. A collation mismatch between master and msdb caused it, and rebuilding the system databases fixed it.
SQL SERVER – Jump in Identity Column After Restart
A change in SQL Server 2012 can cause a jump in identity column values after a restart. Here are the steps to reproduce it and what you can do about it.