slow running queries in SQL Server

Dipa Mehta

6y1.1k

Activity monitor is used to check current and recent activities. Apart from this what are the remaining tools going to be applied to check the running queries.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg6y ago
Hi.
You can use
1/ Sql Server Profiler
2/ Sql Server Load Generator
and several other tools exists.
Follow these links for more,

https://www.netwoven.com/2014/04/15/how-to-use-sql-server-profiler-for-database-tuning/

https://blog.sqlauthority.com/2012/06/07/sql-server-load-generator-free-tool-from-codeplex/

https://stackify.com/performance-tuning-in-sql-server-find-slow-queries/

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms173789(v=sql.105)?redirectedfrom=MSDN

Thanks.
0
Dipa Mehta6y ago
Thanks Sagar for the reply. All 7 tips are useful regarding my query.
0
Sagar Pardeshi6y ago
Hi Dipa,
follow the below URL
https://stackify.com/performance-tuning-in-sql-server-find-slow-queries/
+2