I honestly have never seen such confident speaker , this is such a masterclass on knowing your domain and entertaining others with your knowledge. Thanks for sharing this!
Iam from India, I have frequently getting issue on cpu utilization took 100% in the production server... memory consumption is 95% which is from sqlserver.exe .... I do not know how to troubleshoot the cpu consumption in live production... could you pls explain
Hey Brent, great video, do you have any recommendations on training for developers to learn techniques like queuing inserts? Is queuing of inserts something I’d need to build on my own or does sql have this ability built in? I’ve tried googling this technique but I don’t seem to be finding anything related. Thanks!
@@TheBrentOzar around 34:50 (ish) you mentioned queuing up the view count updates, this sounds like a great idea and I was curious if it’s an ability SQL supports or if the developers had to engineer their own work around for it. Also any recommendations you have on training to cover understanding performance issues like this would be greatly appreciated. I’ve recently come into a project with… let’s just say lots of room for changes to increase efficiency - in both the database dev and web dev side. Current team says it’s because the server doesn’t have enough power but I’m thinking there’s probably a lot to be done on our side (dev) to make it better.
@@TheBrentOzar ah bummer. It sounds like a great idea and sounds like something a lot of people would run into. My guys here are running a function making 6 or more (depending on whats going on, could be 30-50) inserts to different tables at the load of every page. We get 100+ pages loading every second, guess i need to figure out a way to queue those up and start looking for more red flags. Thanks much for the input.
@@TheBrentOzar , Maybe i ask you more. I used sql server 2017. It is hopeful when i apply this script below for improve performance? DBCC TRACEON(4199,-1); DBCC FREEPROCCACHE; GO
I honestly have never seen such confident speaker , this is such a masterclass on knowing your domain and entertaining others with your knowledge. Thanks for sharing this!
Aww, thanks! I appreciate that.
This is a super performance lecture. Good job .
Thanks!
Excellent stuff ... keep educating us thanks
Thanks, will do!
Awesome performance presenation
Awesome presentation.
Very good presentation.
Very helpful in understanding the concepts
Excellent stuff!!
Really helpful and Excellent
Your class is super Sir 👌👌
Thanks, glad you liked it!
You should create a few SQL 'LeetCode' problems that are solved but need tuning
I have tons of 'em! They're in my Mastering classes. Have you tried one?
Ok. I will check it out@@BrentOzarUnlimited
Does it make sense to do column index on stojou tables?
That's outside of the scope of this video.
Awesome !!!
Iam from India, I have frequently getting issue on cpu utilization took 100% in the production server... memory consumption is 95% which is from sqlserver.exe .... I do not know how to troubleshoot the cpu consumption in live production... could you pls explain
Sure, I teach how to do that in my Mastering Server Tuning class. Go to BrentOzar.com and click Training at the top of the site.
What's wrong with AdventureWorks...Just want to understand
Why did you turn off Read_Committed_Snapshot Isolation
Hey Brent, great video, do you have any recommendations on training for developers to learn techniques like queuing inserts? Is queuing of inserts something I’d need to build on my own or does sql have this ability built in? I’ve tried googling this technique but I don’t seem to be finding anything related. Thanks!
Not sure what you mean by queueing inserts - if you send a command to a database, it's executed immediately.
@@TheBrentOzar around 34:50 (ish) you mentioned queuing up the view count updates, this sounds like a great idea and I was curious if it’s an ability SQL supports or if the developers had to engineer their own work around for it. Also any recommendations you have on training to cover understanding performance issues like this would be greatly appreciated. I’ve recently come into a project with… let’s just say lots of room for changes to increase efficiency - in both the database dev and web dev side. Current team says it’s because the server doesn’t have enough power but I’m thinking there’s probably a lot to be done on our side (dev) to make it better.
@@TheFunVampire the developers had to do it. Nothing's built into the product for that.
@@TheBrentOzar ah bummer. It sounds like a great idea and sounds like something a lot of people would run into. My guys here are running a function making 6 or more (depending on whats going on, could be 30-50) inserts to different tables at the load of every page. We get 100+ pages loading every second, guess i need to figure out a way to queue those up and start looking for more red flags. Thanks much for the input.
SQL Super star..... Please come to India....I want to meet you....
Good news! Planes fly in both directions. You can come see ME at conferences and events. ;-)
gr8 job!
I cannot find sp_askBrent
Could you help to provide this procedure for me ! pls
We renamed it as sp_BlitzFirst.
@@TheBrentOzar , Maybe i ask you more. I used sql server 2017. It is hopeful when i apply this script below for improve performance?
DBCC TRACEON(4199,-1);
DBCC FREEPROCCACHE;
GO
@@radatann7701 Your best bet is to ask that on a Q&A site like dba.stackexchange.com. Hope that helps!
Master Piece
Great video Brent!
Cant seem to find resources on the provided link, is it still there? or am I too late?
P.S: Love your work and humor!
www.brentozar.com/sql/watch-brent-tune-servers-ignite-2015/
I need stactoverflow Table
Plz
Nice one.
Can I get script sir?
No, sorry.
@@BrentOzarUnlimitedstandin on buidness