Activity Monitor
As a sql server user we all are aware of Activity monitor.
But in SQL Server 2008 its enhanced with more features
Lets see how to use it
How to open activity monitor
Below image is self explanatory for how to open activity monitor
It shows 4 graphs
which has 4 performance counters
1.%processor time (% processor time used by sql server)
2.Waiting Tasks
3.Data File I/O
4.Batch Requests per second
Now we can get this info from SSMS instead of going to performance counters
Processes
It shows all current processes running on the server and its related details
We can also sort them and filter it.
We can see its providing rich information from our perspective
Resource Wait
It gives idea when operations has to wait for resources. It can give a idea to troubleshoot resource bottleneck. High wait indicate some bottleneck for that operations ,
Data File I/O
If some data file heavily affected by disk I/O we can get this info from here
Recent Expensive queries
It shows all queries running on the server. Which we can use to get idea which queries are taking high resources or expensive queries
As a sql server user we all are aware of Activity monitor.
But in SQL Server 2008 its enhanced with more features
Lets see how to use it
How to open activity monitor
Below image is self explanatory for how to open activity monitor
It shows 4 graphs
which has 4 performance counters
1.%processor time (% processor time used by sql server)
2.Waiting Tasks
3.Data File I/O
4.Batch Requests per second
Now we can get this info from SSMS instead of going to performance counters
Processes
It shows all current processes running on the server and its related details
We can also sort them and filter it.
We can see its providing rich information from our perspective
Resource Wait
It gives idea when operations has to wait for resources. It can give a idea to troubleshoot resource bottleneck. High wait indicate some bottleneck for that operations ,
Data File I/O
If some data file heavily affected by disk I/O we can get this info from here
Recent Expensive queries
It shows all queries running on the server. Which we can use to get idea which queries are taking high resources or expensive queries
No comments:
Post a Comment