This time DBA called me as he wanted to know if how to confirm that lock pages in memory is enabled for the SQL Server instance.
He asked me if I can provide it scientifically my findings and he will immediately approve the budget. Let us see Queries Waiting for Memory Grant.
Once we isolate the user, it was easier for us to get the performance back to the original level. Learn about User Statistics Report for Database – SSMS.
Question: How to Force Index on a SQL Server Query?
Answer: I personally do not like to force an index on any query. Let us learn together.
The question was about is there any way we can see SQL Server Execution Plan in Azure Data Studio. Comprehensive Database Performance Health Check.