What To Do When SQL Server is Slow Brent Ozar

[@jacobcase587]

Only Brent can make this topic as hilarious as he does.

[@RIDDLE0MASTER]

29:44 - LOL! This is why I like watching Brent.

[@tahreb904]

I JUST GOT INDEX CLASES OM YOUR WEB SITE IS AMAZING GOOD LUCK BRENT

[@richardvazquez1594]

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 ?

[@jerrycons658]

What an absolute gem of a video! Many thanks

[@kebekoi11]

Wondering who's that young dapper fellow

[@AhmadRaza-tk2cy]

Thank you very much Brent Ozar!

[@captainnemonic]

High quality content! Useful. Trying out the blitz scripts now.

[@safraz.hosein]

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?

[@flyingcod14]

Great video, you do make learning fun, Brent!

[@bebeting]

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.

[@qualityexpressexpress1890]

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.

[@foodiegowda5690]

Very helpful, fantastic stuff.. thanks Brent Ozar..

[@owaisqamer2938]

Sir u r amazing....A legend to be exact!!!!

[@Groot_for_prez]

Great video... Enjoy the IT / DBA humor.

[@ulysses1904]

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?

[@safraz.hosein]

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.

[@ulysses1904]

@@safraz.hosein thanks

[@utubekade]

Thanks a ton.

[@harunkaratas7072]

Excellent content !!

[@marcelofarinelli3540]

EXEC sp_Blitz @KeepMyJob = 1

[@TuNguyen-ir3hz]

thank you somuch :)

[@kennethgardzinski]

awesome

[@shaikzuhair8537]

Ur videos make sql from poison to cool drinks