1. How to monitor sql server in real-time
How to Monitor the SQL Server?
SQL Server monitoring is continuous collection and analysis of usage, performance, and event metrics for Microsoft SQL Server. It is the first step in optimizing performance for applications. It also helps for Baselining of the server.
What you are learning here in this video?
Why is the application so slow?
Why is my query taking, like, forever to return the results?
How to check the blocking?
How to check, if Memory/CPU went to 100%?
SP/Query taking how much time being run?
Tuning of the SP/Query?
Want to see the Current executing queries?
Want to see the Current executing queries and their execution plans?
Open transactions
How much Percentage complete of the query execution?
What query is running under the SP?
I want see queries which are running only on Particular DB or Particular login?
I want to kill all the sessions on one DB or one login related?
Physical Reads/Logical Reads
And Many more