My client reached out to me asking if there is a way to measure the performance of the newly created index. How to measure index performance.
SQL SERVER – List of Trace Events
I posted a blog post SQL SERVER – Identify Table Creation Date from Traces. Let us see how to see all the list of trace events.
Snowflake – Analysis Query Performance
I am doing consulting Snowflake Comprehensive Database Performance Health Check, who recently asked me if I know any way to Analysis Query Performance.
SQL SERVER – Table Partitioning for Slow Performance
Something just conversation which I keep on doing again for ages. One of the conversations which never gets old is Table Partitioning for Slow Performance.
SQL SERVER – CPU Scheduler Waiting On Disk
Comprehensive Database Performance Health Check. Let us figure out today a very simple and effective script for CPU Scheduler Waiting On Disk.
SQL SERVER – Troubleshooting High CPU
We are going to discuss Troubleshooting High CPU in SQL Server. This is why many hire me for Comprehensive Database Performance Health Check.
SQL SERVER – Rebuilding Index with Compression
We can be Rebuilding Index with Compression even if it was originally not created with compressions. Let us learn how we can do it today.