Finding expensive queries in SQL Server and performance optimization part 1

Finding expensive queries can be challenging on SQL Server, this tutorial will help you in finding expensive queries on production. Using below DMVs
SYS.DM_EXEC_QUERY_STATS
SYS.DM_EXEC_SQL_TEXT
SYS.DM_EXEC_CACHED_PLANS
SYS.DM_EXEC_TEXT_QUERY_PLAN

First is using average logical reads, execution count and total worker time. But still people can use other combinations as well.
I have also explained how missing index can also help in finding and fixing expensive queries.

For script kindly visit:

[jacksonmacd]

Thank you for your video and script. I used it to find some problematic queries in my application. Especially liked the trick about CAST the execution plan into XML to easily visualize the query. Well done.

[dilippatra]

This is an excellent tutorial, I have been looking for a long time.

[surendharbsk]

You have to post more and our support always there.

[arpitsawarn]

Indeed this session is helpful. Can you share the query.

[shashiranjan]

It's a very interesting session, please share the scripts.

[freakytej]

Awesome vedio...After expensive query found still customer facing the slowness so in this case on which factors should i focus...?
Could you please make an vedio on integrity check DB through jobs by using ole hallengren scripts for particular database, And through jobs how can we find the checkdb error....?plz help me out..

[weeragardens]

This is very helpful. would you mind sharing the script ? Thanks.

[swarnabg]

hello sir, your videos are really helpful, i need to try it out so please share the query script

[thecrowa]

Great video, please share the script, it will be helpful

[patelpalak]

Hello, It's very interesting and will help to me. can share the script?

[praveencharan]

Hi very good video, very simple to understand. can you please send the script, Thanks

[maheshvuppu]

Help full topic, please share the script

[sanjayschopra]

I have implemented Table Partitioning in Azure Sql Server and my table is working fine but sometimes It takes time to retrieve data like in 1 min it retrieves more than 1 lakh records and sometimes i get only 15000 .Please help me on this

[kirankamthe]

Helpful video, could you please share scripts

[telugufulloldnewvedeosongs]

hello, can you send me the code of the script, please?

[tanzilazarin]

Hey, please share the script, it will be helpful. Thanks for the great session.

[adelmourad]

Please share the query stats code. Thanks

[jaikumar]

Hello can you please share query stats code?

[hajerbensalem]

who have the script please share for me please

[seshadriprasanna]

Yogesh nice writeup can you send me the scripts used? Have sent email to your gmail already. Appreciate your help here.