Hello Sir, I always watch sql in 60 second. Just saw this one and it’s really amazing. It helps lot. Please keep posting such great content. Thank you very much.
Nice one Pinal. I have an interesting story for you, once i visited Belfast and met a gentlemen, while having an interaction he told me works as a DBA and immediately asked me if I knew Pinal Dave :) coz I came from India... he told he was very excited to meet and see you and wanted to offer some gifts. As most of his SQL server issues were resolved by reading your articles...keep it up !!
First of all you have made your subscribers happy with this twist in between your usual short sql lessons. QAs certainly help a large set of people sharing the same or similar queries. Thanks for sharing this in an effective manner 🙌
I personally have lot to learn and every time I talk to experts like you as well as get feedback, I feel motivated. While we have long ways to go, the intention is help and grow together. Once again, can't thank you enough for your kind motivational words.
This is very usefull. Thank you for making this video and your constant contribution to community. Also many thanks for queries you share to help people like me. Thank you 🙏
@@akhileshnarayanan9935 My most customers only update statistics and we do index rebuild in the rare outlier cases when we have mega changes in the schema or data of the table. In 99.99% of the cases, Statistics Update has given us good performance.
Hi Pinal, what can you use to measure if you don't have enough CPUs? We have Software Assurance so our servers have 4 CPU licences but a 'consultant' has told the business they run faster with 2 CPUs. Is there an easy way to check if you don't have enough CPUs? Thanks and thanks for the videos.
Usually when you have query waiting for CPU threads, you can say you are running out of CPU. However, sometimes optimizing indexes has helped in this situation too.
Thank you Pinal! A question for you.. When you're working with clients how do you determine and demonstrate that server-level MAXDOP settings are too high? We've got a very busy and powerful server (96 logical CPUs, tons of memory) in our company with a MAXDOP set to 32. Have you ever seen a situation where a MAXDOP of 32 is justified? I suspect that this is too high but I'm not sure how best to prove it. Any suggestions?
I have never set MAXDOP to 32. You should start with MS guidance on this topic. Just search on internet for MAXDOP recommended settings and you will end up on MS article. Start from there and later on you can find your best settings by monitoring CXPACKET Wait in SQL Server.
Hi Sir,shared valuable information.Please do a video on how to resolve or come out of the issue,when ever particular wait stats like sos_scheduler_yield,page lath,Page io latch etc..
Thanks Sanket, I think SQL Server is evolving and books are difficult to capture the concepts. I have done over 150 videos on this channel on SQL Server Performance Tuning and also have many blogs over here: blog.sqlauthority.com/category/sql-performance/
Hi Pinal. I work in a busy corporate IT department where the traffic running through Production is much greater than that running through Test and Dev. How do you advise colleagues and clients who are concerned that query plans, caching and other results generated by lesser-trafficked instances are likely to be inaccurate for Production?
i would enjoy your excellent videos even more if all scripts or you tube videos mentioned have a matching link in the comments. If all links to scripts and you tube videos could be inside the same single comment that would be very efficient. If the time in the video where each script or video is mentioned could be place on the same line as the link that would be helpful, and be more clear and helpful than other channels. Thank you for your expertise.
Hello Sir, I always watch sql in 60 second. Just saw this one and it’s really amazing. It helps lot. Please keep posting such great content. Thank you very much.
Thank you, I will
Nice one Pinal. I have an interesting story for you, once i visited Belfast and met a gentlemen, while having an interaction he told me works as a DBA and immediately asked me if I knew Pinal Dave :) coz I came from India... he told he was very excited to meet and see you and wanted to offer some gifts. As most of his SQL server issues were resolved by reading your articles...keep it up !!
This is fantastic to hear. You just made my day
First of all you have made your subscribers happy with this twist in between your usual short sql lessons. QAs certainly help a large set of people sharing the same or similar queries. Thanks for sharing this in an effective manner 🙌
I personally have lot to learn and every time I talk to experts like you as well as get feedback, I feel motivated. While we have long ways to go, the intention is help and grow together.
Once again, can't thank you enough for your kind motivational words.
I really enjoyed this longer Q&A video, thanks pinal!
Glad you enjoyed it!
Kudos on using SQL examples to compare the various statistics..time IO ..etc effective way to explain. thanks
Glad it was helpful!
This is very usefull. Thank you for making this video and your constant contribution to community. Also many thanks for queries you share to help people like me. Thank you 🙏
Thanks a lot.
Wonderful!! This scenario based detail helps a lot. Thanks Pinal for all your videos.
You are welcome
Changed life of a DBA.. Great Master
Thanks!
Excelent video men. Thank you for this and the other many tips. Greetings from colombia.
Glad you enjoyed it!
I was waiting for this
Thanks so much!
Awesome tips sir ji..!! Thanks for all your help to the DBA and DB developer community..!!!
You are welcome
Very interesting and informative video. Thank you for your help in improving my skills in performance tuning
Great to hear!
Very informative. Can you please do make video on how to troubleshoot stored procedures ?
Great idea
Superb ! Thanks a lot.
Glad that you liked it.
Awesome content!
Thanks
Awesome content. If you could show these things in SSMS would be more informative. Anyway good job.
Thanks, will do!
Hello Sir. Very informative knowledge sharing video. Can you share the performance tuning scripts please?
All on blog SQLAuthority.com
What is the solution for fixing high index fragmentation on tables during peak business hours?
Index fragments are no longer performance issues like they used to be 15 years ago.
@@PinalDaveSQLAuthority , How come performance is back to optimal after rebuilding indexes?
@@akhileshnarayanan9935 because it updates statistics.
@@PinalDaveSQLAuthority , If that is the case then why doesn't it perform well after update statistics without rebuilding indexes?
@@akhileshnarayanan9935 My most customers only update statistics and we do index rebuild in the rare outlier cases when we have mega changes in the schema or data of the table. In 99.99% of the cases, Statistics Update has given us good performance.
Great video!
Thanks!
Hi Pinal, what can you use to measure if you don't have enough CPUs?
We have Software Assurance so our servers have 4 CPU licences but a 'consultant' has told the business they run faster with 2 CPUs.
Is there an easy way to check if you don't have enough CPUs?
Thanks and thanks for the videos.
Usually when you have query waiting for CPU threads, you can say you are running out of CPU. However, sometimes optimizing indexes has helped in this situation too.
@@PinalDaveSQLAuthority Thanks for the answer.
Thank you Pinal! A question for you.. When you're working with clients how do you determine and demonstrate that server-level MAXDOP settings are too high? We've got a very busy and powerful server (96 logical CPUs, tons of memory) in our company with a MAXDOP set to 32. Have you ever seen a situation where a MAXDOP of 32 is justified? I suspect that this is too high but I'm not sure how best to prove it. Any suggestions?
I have never set MAXDOP to 32. You should start with MS guidance on this topic. Just search on internet for MAXDOP recommended settings and you will end up on MS article. Start from there and later on you can find your best settings by monitoring CXPACKET Wait in SQL Server.
Hi Sir,shared valuable information.Please do a video on how to resolve or come out of the issue,when ever particular wait stats like sos_scheduler_yield,page lath,Page io latch etc..
Ok soon
@@PinalDaveSQLAuthority Thank you Sir
@@PinalDaveSQLAuthority Hi.. Can u pls try to make a video on performance tuning on 5M+ rows of data tables..
Thanks a lot sir for this video, can you please suggest a book to understand sql server & performance tuning in depth step by step.
Thanks Sanket, I think SQL Server is evolving and books are difficult to capture the concepts. I have done over 150 videos on this channel on SQL Server Performance Tuning and also have many blogs over here: blog.sqlauthority.com/category/sql-performance/
@@PinalDaveSQLAuthority sure sir, thanks a lot. Will wait for your next video.
Impressive
Thanks!
very informative video
Thanks so much
Amazing Video.
Video of all Videos
♪ : [Hats off]
Thanks!
Love you sir ❤️
Best wishes
What Components Are require for best monitoring of the SQL SERVER
?
Monitoring is complex subject and I wish I am able to answer them in this little area. I will try to write a future blog post in detail.
Hi Pinal. I work in a busy corporate IT department where the traffic running through Production is much greater than that running through Test and Dev. How do you advise colleagues and clients who are concerned that query plans, caching and other results generated by lesser-trafficked instances are likely to be inaccurate for Production?
They are mostly inaccurate. You can prove by shoiwing plan cache and performance.
@@PinalDaveSQLAuthority Thanks and agree. How do you advise testing revisions if you want accurate results, worthy of use in Prod?
@@bassfischer4273 you need to run 100% identical workload on your server you want to test.
i would enjoy your excellent videos even more if all scripts or you tube videos mentioned have a matching link in the comments. If all links to scripts and you tube videos could be inside the same single comment that would be very efficient. If the time in the video where each script or video is mentioned could be place on the same line as the link that would be helpful, and be more clear and helpful than other channels. Thank you for your expertise.
Great suggestion!
👌
Thanks!