This video tutorial will help you to use MSSQL activity monitor to find the most expensive query.

 

Was this answer helpful? Users Found This Useful ( Votes)

Most Popular Articles

How To Increase MSSQL Remote Query Timeout Limit?

This video will help you to increase the MSSQL remote query timeout limit.   View All...
How To Restrict MSSQL Server To Connect From a Specific IP Address?

This video tutorial will help you to allow MSSQL Server connection access from a specific IP...
How to restore database from MDF file in MSSQL Server from SQL Management Studio?

This video tutorial will help you to restore a database from MDF file in MSSQL Server from SQL...
How to restrict MSSQL server to connect from the server in which the MSSQL Server is installed?

This video tutorial will help you to restrict MSSQL server to connect from the server in which...
How to add a new user and assign a required permission to it from the SQL Server Management Studio?

This video tutorial will help you to restrict MSSQL server to connect from the server in which...