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.
Question: How to Measure Transactions Per Seconds in SQL Server?
I have updated the script for this for Comprehensive Database Performance Health Check.
Question: How to Recompile Stored Procedure?
Answer: The answer to this question is here:
EXEC sp_recompile ‘NameofSP’
Let us read more about it.
I consider myself fortunate that I receive a follow-up question from my blog posts. Let’s discuss Parameter Sniffing and OPTIMIZE FOR UNKNOWN.
The question I had received was about Parameter Sniffing and Local Variable in Stored Procedure. Let us learn about it in this blog post.
I will be presenting a day-long training day at SQLbits Pre-Con on 31 March 2019 London on the topic SQL Server Performance Tuning Real-World Scenarios.
Question: Why Execution Plan Operator Read More Rows Than Available?
Now let us learn detailed answer in this blog post.