Monday, 19 October 2015

Analyzing running queries

Hi Everyone.

If you are facing database performance issues, you might need some way to get running queries. SQL profiler is good for it, but some times it is no there or you don't have access to it.
But if you can runs SQL, you can use this query (It will show you immediate snapshot of all running queries):

If you are searching for statistical information you can use query (This will show you to 30 heaviest queries on the sever):

No comments: