How To Troubleshoot a Slow Running Query in SQL Server Extended Events & Wait Stats (by Amit Bansal)

Подписаться 20 тыс.

Просмотров 134 тыс.

50% 1

Looking for comprehensive, deep-dive training on SQL Server Performance Tuning? Explore SQLMaestros All-In-One Performance Tuning Bundle. Five courses at a highly discounted price. sqlmaestros.co...
The bundled content focuses on internals, troubleshooting, query tuning, performance optimization, tips, tricks, and loads of content from the real world.
If you are a fan of live classes, you can explore the SQL Server Performance Tuning Master Class. 40 hours of deep-dive LIVE training. Attend LIVE & get the class recordings for a lifetime. sqlmaestros.co...

Опубликовано:

14 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 41

@ademolasanni4443 5 месяцев назад

That's a good demo. So after capturing the wait type what next? Becos seeing the issue causing the slowness is good how to deal with it also matter. Thanks

@shatabdidey3056 5 лет назад

So this was the best vedio I have seen so far in SQL Administration..hoping to learn much more

@ramyanagashree 5 лет назад

OK, we got to know which query is waiting. But the query which is waiting is not the real culprit. How to find the query which made that Select query to wait?

@itintegration1734 4 года назад

It is the transaction query within the update statement that block the server's ressources. Until it release the resources the sql select statement will wait for the end of the transaction statement :)

@danezubro 3 года назад

@@itintegration1734 And if it's was 100 transactions ? Which query is waiting ?

@tinavanrikxoord9955 2 года назад

Excellent instruction. Thank you.

@RamSaun 3 года назад

Guys I have a question - In this case we all knew there was another update query running on another window and when we rollback that tran we could then see the logs of extended events But what if some tran is in progress and executed by another user and we don't know who is running that tran and unless and until that tran is completed or rolled back we would not see any logs. What to do in this scenario ? @SQLMaestros

@imcsingapore7215 5 лет назад

awesome. would like to see now, how will you going to optimize the query statement itself. thanks

@amitkumarsharma25 6 лет назад

Hi Amit, If we talk about the same in two sp's then after identifying the LCKMS lock on query. How would we able to know which stored procedure is blocking our query.

@fbifido2 2 года назад

if you have a database running in production, how would you know what session to filter on ?

@kotekr4383 3 года назад

Excellent Bansal

@brad_mcallister 3 года назад

I just learned a thing or two, thx

@maaz77muslimKarachi 4 года назад

really helpful video sofar, if anyone would help me out to lear the SQL dba spacially, it would be appreciated.

@zohebkhan9066 4 года назад

Awesome sir, Very helpful

@Subba_Chems 3 года назад

can we use DBCC OpenTran?

@k-fo9pq 6 лет назад

we mostly have slow running queries issues in prod..for which i dont have access. So do i need to check with DBA for this?

@sakauk7566 5 лет назад

Hi Amit, I have created 2 XEvents on my server to track any deadlocks or long running quires (Longer than 2 minutes), they worked very well but i had major performance degradation on the server knowing that i didnt pick any global events. I had to stop those events and the performance picked back to normal. Any clues on what has gone wrong? Im sure XEvents supposed to be much better and less consuming than profiler.

@israel1919 4 года назад

Thanks a lot for the help.

@contactsan12 3 года назад

everything is cool but wy are you wearing the headphones ??

@banisabrown143 6 лет назад

Brilliant content! Very helpful!

@purushotambhardwaj 6 лет назад

Excellent explaination Thank You !!

@theislamicvoyager 6 лет назад

Really very helpful and well explained

@AliciaMarkoe 5 лет назад

Excellent, thank you so much!

@danezubro 3 года назад

Very correct but incomplete. We know it's blocked, but we don't know who's blocking it.

@u2lover10 5 лет назад

Excellent Video !

@muhammadumair5019 3 года назад

Whats the solution?

@madanagrawal1465 6 лет назад

Very good article

@labonka 4 года назад

Easier to check blocking session in sysprocess

@kholekunal 5 лет назад

Good video.. helpful

@sucharitha9365 5 лет назад

i am trying join in your website but i didn't find out math Captcha

@muhammadafzal237 2 года назад

It was very complex

@ayubkarem8697 6 лет назад

Hi Bansal i have installed SQL server 2012 Express ,and i created table with 5000,000 Records ,but its performance execution is too slow what should i do with it? many thanks for replay

@RameshBabusql 6 лет назад

ayub Karem SQL Server Express Edition uses 1 processor and 1 GB RAM .

@tamito9298 6 лет назад

Create necessary indexes for Your table depends on needs (I don`t know what the phrase "performance execution is too slow" - may be it means only ""Select * from Table"..