9 SQL Server Performance Tuning Tips - SQL in Sixty Seconds 168

In this special edition of SQL in Sixty Seconds we will discuss 9 SQL Server Performance Tuning Tips.

00:00 Intro
00:28 Q1) Where do you start to tune SQL Server?
01:20 Q2) Where do you start to tune SQL Queries?
02:17 Q3) How to write efficient queries?
03:20 Q4) How to identify slow-running queries?
03:59 Q5) Is it possible to search inside SQL Server Execution plan?
04:51 Q6) Is it possible to share SQL Server Execution plans with others?
05:58 Q7) Do queries run faster when we add more CPU?
07:10 Q8) Do queries run faster when we add more Memory?
08:03 Q9) Can we tune our server ourselves?
08:44 Summary

Resources used in building video:

#SQLServer #PerformanceTuning #SQLAuthority

[jenishdesai]

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.

[brianweiler]

Kudos on using SQL examples to compare the various statistics..time IO ..etc effective way to explain. thanks

[savananjaria]

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 🙌

[vsaurb]

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 !!

[Dalamain]

I really enjoyed this longer Q&A video, thanks pinal!

[sanjaymaurya]

Wonderful!! This scenario based detail helps a lot. Thanks Pinal for all your videos.

[RavinderKumar-jpgx]

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 🙏

[pashikantis]

Awesome tips sir ji..!! Thanks for all your help to the DBA and DB developer community..!!!

[kishorkadavil]

Awesome content. If you could show these things in SSMS would be more informative. Anyway good job.

[wolk]

Excelent video men. Thank you for this and the other many tips. Greetings from colombia.

[mujeebahmed]

Very interesting and informative video. Thank you for your help in improving my skills in performance tuning

[ping]

Very informative. Can you please do make video on how to troubleshoot stored procedures ?

[pramod]

Hello Sir. Very informative knowledge sharing video. Can you share the performance tuning scripts please?

[aniltarimineni]

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..

[bassfischer]

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?

[_SanketJoshi]

Thanks a lot sir for this video, can you please suggest a book to understand sql server & performance tuning in depth step by step.

[dtovee]

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.

[davidstaub]

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.

[akhileshnarayanan]

What is the solution for fixing high index fragmentation on tables during peak business hours?

[bassfischer]

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?