One of the things which we cover in my Comprehensive Database Performance Health Check is how to do Load Testing or Stress Testing with oStress.
Let us today talk about SSMS Query Execution configuration for SQL Server where SET ROWCOUNT settings gave us an interesting challenge with query tuning.
Recently, while working with a client we ended up on a very interesting situation with a client where we had to Rebuild All Indexes for a Single Table.
Question: How to Check Database Performance Facets in SQL Server?
It is very simple to find out the facets of SQL Server Just follow the diagrams listed.
Every single time when I start working with Azure, I always want to know what is the status of Azure resource status or consumption in the last hour.