3 Common Mistakes to Kill SQL Server Performance with Pinal Dave

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.

[dmac]

I crown you the Sql Performance tuning King. I love the way you make things seem so simple. Nice Job.

[MollyMock]

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!

[awesomebytes]

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

[JohneyDB]

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!

[mohammedhassan]

Thanks GroupBy, Thanks Pinal for the great session.

[bharatpatel]

Thanks for sharing the valuable info. Plus one for presenting it in easy to understand manner

[sid]

Pinal u rock! Thanks Brent for organizing this.

[aarunvitha_vlog]

I loved it. Good to see both of u in same frame. Great explanation. Thank you so much

[ghanshyamaryan]

Thank you Pinal Sir for sharing this valuable knowledge

[meghanatoraskar]

Superb conversation teaching right lines

[allentertainmentin]

Can we on Auto update stats for 4 tb database? Pinal

[polajyothi]

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.

[rajkamalsinghsarao]

We from India need more Videos from Pinal

[subhashchandra]

Really It was very key points you had explained in detail.

[prsantapattnaik]

You are simply Awesome sir! Loved your explanations.

[VenkataPhaniPallem]

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.

[suktvm]

Gives a positive vibe when i read your blogs and watch your videos . Thank you for the vauable informations

[ljubafm]

I have totaly diferent test results ... about inserting with 100MB autogrowth and reading from table with auto update statistics = OFF ... it is totaly oposite.

[ljubafm]

Also should use:

set statistics time on;

to measure execution time...

[EndUser-yugg]

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*