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

preview_player
Показать описание
The bundled content focuses on internals, troubleshooting, query tuning, performance optimization, tips, tricks, and loads of content from the real world.

Рекомендации по теме
Комментарии
Автор

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?

ramyanagashree
Автор

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

shatabdidey
Автор

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

RamSaun
Автор

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

imcsingapore
Автор

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

ademolasanni
Автор

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.

amitkumarsharma
Автор

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?

k-fopq
Автор

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

fbifido
Автор

Really very helpful and well explained

theislamicvoyager
Автор

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

sql_training
Автор

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.

sakauk
Автор

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

contactsan
Автор

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

maazmuslimKarachi
Автор

Easier to check blocking session in sysprocess

labonka
Автор

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

sucharitha
Автор

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

ayubkarem
Автор

oh ... he's saying SPID!!! OK, I un-disliked this video... sorry, I've always heard ESS PEE EYE DEE, not "SPID"... cool cool!

scottdhartman
welcome to shbcf.ru