Performance

How to find slow running T SQL query

Advertisements

Top 10 ways to find slow running T SQL query

Followings are ways to identity and capture the slow running queries in SQL server database.

 

1.Use common activity monitor and task manager to get some overview

Right click the instance – Activity monitor

2.Use DMVs

Use Glenn Berry’s DMV pack https://www.sqlskills.com/blogs/glenn/category/dmv-queries/

3.Check wait stats

Use Paul Randal’s DMV  https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

4.Use Whoisactive

Use Adam Machanic’s script https://sqlserverblogforum.com/dba/whoisactive-capturing-a-sql-server-queries-performance-tuning/

5.Use SP_BiltZ

Use Brent Ozar’s script https://www.brentozar.com/blitz/

6.Use server side trace

https://sqlserverblogforum.com/dba/how-to-use-server-side-trace-to-capture-running-query-t-sql/

7.Use extended events

https://blog.sqlauthority.com/2010/03/29/sql-server-introduction-to-extended-events-finding-long-running-queries/

8.Use actual execution plan, if you have query

In SSMS, check mark the actual execution plan and run the query to tune further.

9.Use query store, if SQL version is above 2016

10.Use query store

https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store?view=sql- server-ver15

For SQL azure PaaS use insight dashboard

I will try to write separate post of 10 steps.

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

Leave a Reply

Your email address will not be published. Required fields are marked *

WC Captcha + 74 = 78

 hacklink panelweb shell downloadhacklink vozol 5000https://shoppuffer.com/https://vozol10000.com/
hacklink hacklink al hacklink panel hacklink hacklink panel hacklink al hack forum hacklink Shell download web shell download web shell archive web shell indir php shell download php shell archive php shell indir shell indir cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı saricahali.com.tr cami halısı cami halısı cami halısı cami halısı cami avizesi cami avizesi cami süpürgesi cami süpürgesi cami ısıtma cami ısıtma evden eve nakliyat evden eve nakliyat evden eve nakliyat evden eve nakliyat ofis taşıma yurtiçi evden eve nakliyat yurtiçi evden eve nakliyat içel evden eve nakliyat seo hizmeti Rulet Casino Slot Oyna Bahigo 1xbet Deneme bonusu Bahis siteleri Maç özetleri Bahsegel Canlı Casino Siteleri Sweet Bonanza Blackjack Casino Rulet Oyna Canlı Casino istanbul escort muğla escort google.com.tr
hacklink
hacklink panel
hacklink al
hacklink
hacklink panel
hacklink al
deneme bonusu veren siteler