If a slow query is running on server then it will consume more resources like memory, disk, processor etc. You can find these kinds of queries and manage them easily with SQL Activity Monitor.
- Login into your RDP.
- Open your MSSQL Management Studio and click on your particular user.
- After that click on the activity monitor icon to check the information about CPU, disk, RAM and execution time.
- You will find all the queries which are taking maximum time for execution and highest resource usage under “Recent Expensive Queries”.
- Here you will find the edit option to optimize your query as much as you can. You just have to right click on query and click on “Edit Query Text”.