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.
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.
SQL SERVER – AlwaysOn Listener Error – The WSFC Cluster Could Not Bring the Network Name Resource With DNS Name ‘DNS name’ Online
Creating an AlwaysOn listener failed: the WSFC cluster could not bring the Network Name resource with DNS name online. Why it happens and how to fix it.