What To Do When SQL Server is Slow Brent Ozar
ฝัง
- เผยแพร่เมื่อ 30 ก.ค. 2024
- Someone comes running in and asks, "Are you doing something on the SQL Server right now? Can you take a look at it? It seems really slow." It's one of the most common complaints we get about our databases - and yet, most of us don't have a written plan with what steps to take, in order. I do this for a living, so I've had to make a written checklist to handle it. I'll give you the exact same checklist I use, then walk you through several performance emergencies. I'll show you how I use open source scripts like sp_WhoIsActive, sp_BlitzFirst, sp_BlitzCache, and more to find the root cause fast. We won't cover performance tuning - our goal in this hour is just to have a written triage process so we don't look like bumbling idiots. Let's get good at this! Bio: Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.
Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit. He loves sharing knowledge at BrentOzar.com.
Links to PASS and our Site:
PASS: Pass.org
DBAFundamentals: fundamentals.pass.org/default...
Why to Go: • Why Go to PASS Summit?
Use our discount code VGDISM843 to save $150.00 off the full price of PASS
Registration can be completed here: www.pass.org/summit/2019/Regi... - วิทยาศาสตร์และเทคโนโลยี
High quality content! Useful. Trying out the blitz scripts now.
What an absolute gem of a video! Many thanks
Great video, you do make learning fun, Brent!
Thank you very much Brent Ozar!
29:44 - LOL! This is why I like watching Brent.
Very helpful, fantastic stuff.. thanks Brent Ozar..
Only Brent can make this topic as hilarious as he does.
Excellent content !!
You are a good man. Thank you.
I JUST GOT INDEX CLASES OM YOUR WEB SITE IS AMAZING
GOOD LUCK BRENT
Sir u r amazing....A legend to be exact!!!!
Brent I love your presentation, clearly you know what and what not to do. Your presentation really follows what a DBA must follow in order to, dictate the problem, minimize risks, but more importantly, look after your back and follow process of the enterprise. This is all great and much appreciated, however, I imagine you have some dirty and risky tricks prior to hitting that rollback button. So per as your example, a change was made by Norm, with no Commit, tequilas ruined. Could you please confirm if the following would work: 1) Alter SPROC in replica 2) Change connection strings on client to REPLICA 3) Let roll back complete, replication should prevent data loss ... would this prevent DATA loss and high availability ?
Thanks a ton.
thank you somuch :)
Great video... Enjoy the IT / DBA humor.
38:32 so true. Microsoft Office/Visio/OneNote can never agree on whether or not my licenses are valid. Thank goodness SQL Server has a different authentication system - but then again, that's a whole different kind of wacky-ness.
awesome
In the example, with Norm's begin transaction without a commit which caused the blocking, could a situation like that be resolved with Norm committing the transaction? Wouldn the other queries then be free to access the tables blocked by the transaction? Or am I missing something?
good day
I have an issue with sql and winfreight .main branch has a server that is a complete overkill and is running perfect but the other branch is 300km away but the system is up to Sh@t takes 30min to load an image on an i5 8th gen 3.2ghz 8gb ram.please help.
I'm studying to be a jr DBA so pardon the newb question here but why are the log files continuing to grow? What is being recorded during this stalemate of Norm's uncommitted transaction?
2 years late but I would leave a guess anyway. The database writes the contents of the log file to the data file when a commit is entered so I'm guessing that it keeps recording the transactions while waiting for a commit that never came.
@@safraz.hosein thanks
EXEC sp_Blitz @KeepMyJob = 1
Ur videos make sql from poison to cool drinks