In this blog post, we will discuss Discovery Phase which I spent before I built successful SQL Server Performance Tuning Practical Workshop.
SQL Server Performance Tuning Practical Workshop – Discovery Phase – In Person Training
In this blog post, we will discuss Discovery Phase which I spent before I built successful SQL Server Performance Tuning Practical Workshop.
What is Faster, SUM or COUNT? – Interview Question of the Week #231
Question: What is Faster, SUM or COUNT? Answer: Both are the same. I was asked this question during my Comprehensive Database Performance Health Check.
SQL SERVER – Automatic Seeding of Availability Database ‘SQLAGDB’ in Availability Group ‘AG’ Failed With a Transient Error. The Operation Will be Retried
Earlier I have written few blogs about automatic seeding feature. In this blog we would learn how to fix error: Automatic seeding of availability database.
SQL SERVER – Add Database to Availability Group Failure – This BACKUP or RESTORE Command is Not Supported on a Database Mirror or Secondary Replica
In this blog post, we will fix the error related to This BACKUP or RESTORE command is not supported on a database mirror or secondary replica.
SQL SERVER – Different Size of COPY_ONLY Full Backup on Primary and Secondary Replica in Always On
We will learn how the full backup size can be different on the primary and secondary replica for an availability database in Always On availability group.
SQL SERVER – SUSPENDED Sessions Waiting on PAGELATCH_UP and PAGELATCH_SH – Solution
Their server got tremendously slow with many sessions suspending in the status of SUSPENDED status and they were waiting on PAGELATCH_UP and PAGELATCH_SH.