3 Common Mistakes to Kill SQL Server Performance with Pinal Dave
Vložit
- čas přidán 19. 01. 2017
- No one wants slow performance of their application.
In this session, you we will learn about three mistakes which DBA often do which kills SQL Server’s performance. We will understand what are those errors, why those particular errors are prevailing in the industry and how we can fix it.
We will explore various settings as well as code which will kill SQL Server Performance. At the end of this session, every attendee will receive scripts which will help them improve their SQL Server’s performance. This session is of intermediate level - you just have to know a little bit about SQL Server and a lot more you will learn in this session. The session is carefully crafted from the real world experience for DBA so they can learn tricks which can help them to improve their server’s performance.
We will discuss various SQL Server Settings, File Placements as well as ignored details related to SQL Server Performance.
Get more information, resources, and more here: groupby.org/conference-sessio... - Věda a technologie
@ Pinal Dave thanks for sharing. I follow your blogs and bought a book from kindle to learn more on Sql Server tuning. More blessings to come.
I crown you the Sql Performance tuning King. I love the way you make things seem so simple. Nice Job.
Thank you Pinal for sharing this valuable tips. I loved your session so much that I couldn't focus on anything else until finish. I can see what a good human being you are. And thanks Brent for organizing this!
Thank you Johney, I am truly touched.
I loved it. Good to see both of u in same frame. Great explanation. Thank you so much
Thanks for sharing the valuable info. Plus one for presenting it in easy to understand manner
Pinal, my work has tasked us to watch a one hour long video every week as training.
You had us alert, laughing and interested the whole time...bless you!
It is so kind of you. I hope you enjoy your one hour along with learning.
Pinal u rock! Thanks Brent for organizing this.
Thank you for your kind words!
Such a nice presentation to watch
Thank you Pinal Sir for sharing this valuable knowledge
You are simply Awesome sir! Loved your explanations.
Thank you Prashant!
Thanks GroupBy, Thanks Pinal for the great session.
Thank you so much for your kind words.
Very kind of you!
Really It was very key points you had explained in detail.
Thank you so much for your kind words Subhash!
Superb conversation teaching right lines
No words for your energy sir.. gr8 explanation with all scenarios. And i am regular follower of your's and Brent ozar sir websites. Really very useful information... Not only the subject point of view,i really enjoyed your humour in between... Heartful Thanks.
Thank you so much for your kind words. I hope to see you all at the my online class :-)
Gives a positive vibe when i read your blogs and watch your videos . Thank you for the vauable informations
Thank you so much for your kind note.
Thank you...
Thanks a lot sir 👌🏻👍🏻
Excellent Pinal!
Thank you Moin!
Truly appreciate it.
Pinal is awesome! :)
You are very very kind!
Thanks! @ Pinal Sir
Thank you for your kind words!
Thank you for your comment.
Can we on Auto update stats for 4 tb database? Pinal
Good bless
Hi Dave,
Good day to you, I'm Venkat, I do follow you Vlogs & they are very good.
I have a doubt, I would like to check with you regarding the same "Does the number of columns affect query performance (SQL Server 2017)?", our dev team is planning to add some more columns.
I have a table with 215 column which holds customer information, there are some sensitive columns also we are planning to do always encrypted on sensitive columns as part of PDPA too.
can you please help to advise me on this, thank you very much in advance.
We from India need more Videos from Pinal
For sure!
Thank you all for your love and support. Many of you have asked if this session can be converted to half-day learning so they can learn everything they want to learn about Database. Here it is - bit.ly/sqlperf18 you can sign up for this course and learn everything about performance tuning from me LIVE!
Gosh Pinal... you are Hilarious ... loved this video ... I am always being shown something new, or when I think one would see this as obvious but... yeah NO... assume nothing =) . ... data conversions dumping my perf tweaks *angry*
Hi Scott, Thank you for your kind note. I am so happy to hear your thoughts and again thanks for watching this!
My pleasure, I always enjoy these sort of video's - I am in the SQL Azure services so sometimes I have to change around how I get at something that I could easily find in SQL On-Prem tools ... but still it is a lot of fun! ... yes even the times when you throw your hands up and go why are you doing this to me today? =)
I have totaly diferent test results ... about inserting with 100MB autogrowth and reading from table with auto update statistics = OFF ... it is totaly oposite.
That is kind of strange. I would love to see the result. Send me email at pinal at sqlauthority . com and talk more.
dream team.
Thank you so much!!! You are great.
Also should use:
set statistics time on;
to measure execution time...
The most accurate way is to depend on Logical Read so we depended on it.
This guy's English is barely comprehensible and he keeps going off on tangents, making jokes and sharing anecdotes that it's a struggle to understand due to speed talking with a thick accent. Do you have the 15 minute version in proper English? Why are you wasting your viewers time? I watched 27 minutes and got nothing out of it. I have no idea what he even talked about. Auto statistics. Did he say to turn it off or on and why? No idea.