mssql activity monitor

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...