Тёмный

3 Common Mistakes to Kill SQL Server Performance with Pinal Dave 

GroupBy
Подписаться 7 тыс.
Просмотров 46 тыс.
50% 1

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

Опубликовано:

 

4 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 50   
@dmac5808
@dmac5808 4 года назад
I crown you the Sql Performance tuning King. I love the way you make things seem so simple. Nice Job.
@awesomebytes7981
@awesomebytes7981 4 года назад
@ 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.
@MollyMock
@MollyMock 7 лет назад
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!
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
It is so kind of you. I hope you enjoy your one hour along with learning.
@JohneyDB
@JohneyDB 7 лет назад
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!
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
Thank you Johney, I am truly touched.
@bharatpatel1978
@bharatpatel1978 2 года назад
Thanks for sharing the valuable info. Plus one for presenting it in easy to understand manner
@aarunvitha_vlog
@aarunvitha_vlog 4 года назад
I loved it. Good to see both of u in same frame. Great explanation. Thank you so much
@mohammedhassan8522
@mohammedhassan8522 7 лет назад
Thanks GroupBy, Thanks Pinal for the great session.
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
Thank you so much for your kind words.
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
Very kind of you!
@ghanshyamaryan
@ghanshyamaryan 3 года назад
Thank you Pinal Sir for sharing this valuable knowledge
@sid5201
@sid5201 7 лет назад
Pinal u rock! Thanks Brent for organizing this.
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
Thank you for your kind words!
@varundeshpandevd
@varundeshpandevd 4 года назад
Such a nice presentation to watch
@polajyothi
@polajyothi 6 лет назад
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.
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 6 лет назад
Thank you so much for your kind words. I hope to see you all at the my online class :-)
@meghanatoraskar5301
@meghanatoraskar5301 2 года назад
Superb conversation teaching right lines
@suktvm
@suktvm 7 лет назад
Gives a positive vibe when i read your blogs and watch your videos . Thank you for the vauable informations
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
Thank you so much for your kind note.
@prsantapattnaik
@prsantapattnaik 7 лет назад
You are simply Awesome sir! Loved your explanations.
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
Thank you Prashant!
@subhashchandra3342
@subhashchandra3342 6 лет назад
Really It was very key points you had explained in detail.
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 6 лет назад
Thank you so much for your kind words Subhash!
@a.useronly2266
@a.useronly2266 2 года назад
Thanks a lot sir 👌🏻👍🏻
@moinsaiyed6893
@moinsaiyed6893 7 лет назад
Excellent Pinal!
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
Thank you Moin!
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
Truly appreciate it.
@rajkamalsinghsarao3588
@rajkamalsinghsarao3588 7 лет назад
We from India need more Videos from Pinal
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
For sure!
@ashirbad7890
@ashirbad7890 7 лет назад
Thanks! @ Pinal Sir
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
Thank you for your kind words!
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
Thank you for your comment.
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 6 лет назад
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!
@bvbberserk
@bvbberserk 7 лет назад
Pinal is awesome! :)
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
You are very very kind!
@namalama2000
@namalama2000 4 года назад
Thank you...
@VenkataPhaniPallem
@VenkataPhaniPallem 4 года назад
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.
@allentertainmentin1565
@allentertainmentin1565 4 года назад
Can we on Auto update stats for 4 tb database? Pinal
@theman4343
@theman4343 4 года назад
Good bless
@EndUser-yu7gg
@EndUser-yu7gg 7 лет назад
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*
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
Hi Scott, Thank you for your kind note. I am so happy to hear your thoughts and again thanks for watching this!
@EndUser-yu7gg
@EndUser-yu7gg 7 лет назад
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? =)
@ljubafm
@ljubafm 7 лет назад
I have totaly diferent test results ... about inserting with 100MB autogrowth and reading from table with auto update statistics = OFF ... it is totaly oposite.
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
That is kind of strange. I would love to see the result. Send me email at pinal at sqlauthority . com and talk more.
@ljubafm
@ljubafm 7 лет назад
Also should use: set statistics time on; to measure execution time...
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 7 лет назад
The most accurate way is to depend on Logical Read so we depended on it.
@iTruth1
@iTruth1 6 лет назад
dream team.
@PinalDaveSQLAuthority
@PinalDaveSQLAuthority 6 лет назад
Thank you so much!!! You are great.
@soarindragon603
@soarindragon603 4 года назад
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.
Далее
What To Do When SQL Server is Slow   Brent Ozar
58:50
Просмотров 41 тыс.
ЭТО НАСТОЯЩАЯ МАГИЯ😬😬😬
00:19
МАЛОЙ ГАИШНИК
00:35
Просмотров 556 тыс.
SQL Server 2016 "Hidden Gems" with Adam Machanic
1:19:06
Brent Ozar_Watch Brent Tune Queries
1:06:57
Просмотров 64 тыс.
T-SQL: Bad Habits and Best Practices with Aaron Bertrand
1:29:05
An Index Reduces Performance of SELECT Queries
12:00
Просмотров 51 тыс.
SQL Server Execution Plan Operators
42:07
Просмотров 78 тыс.
7 Database Design Mistakes to Avoid (With Solutions)
11:29
Identifying and Fixing Parameter Sniffing Issues
51:53
ЭТО НАСТОЯЩАЯ МАГИЯ😬😬😬
00:19