About This Course
Published 7/2015 English
Please note: This is a continuation from my first course titled, "How to Become a World Class SQL Server Performance Tuner." I highly recommend you take that course first.
This course focuses on making SQL Server perform more optimally.
In my first course we laid the groundwork by tuning OUR instances with a top down approach.
WE will continue on that path with this course.
Even though the course has the word “Advanced" in it, there's NOTHING COMPLICATED about taking what's in the course and applying it in the real word.
It's “advanced" in that I'll take more time explaining how to implement these recommendations.
The course is still very much a "buttons and Knobs" course. This simply means WE won't dive too deeply into the minutia. We are still going to focus on items that are easily implemented. Some features will have a level of contention associated with them in the SQL Server community. It will be up to you decide to implement or not.
Additionally, some of the concepts may be new to even more senior level resources so I want to make sure I'll cover the why of the topic as well as the how.
This course will give YOU deeper insight into what it takes to become a skilled PERFORMANCE TUNER.
Once thought of as an art, performance tuning is nothing more than a series of processes that seek to accomplish TWO basic goals.
The FIRST one is to increase the response time for a given transaction or set of transactions.
The SECOND one is reduce resource consumption. On the surface this sounds simple but nothing could be further from the truth.
در این آموزش تصویری با مباحث مربوط به بهینه سازی و افزایش کارایی در SQL Server آشنا می شوید.
این دوره آموزشی محصول موسسه Udemy است.
سرفصل های این دوره:
- SET Statistics IO و SET Statistics Time On
- جستجوی برنامه ها با اکسپلورر
- اضافه کردن AdventureWorks
- پارامترهای ساده
- پارامتر Sniffing Demonstration
- Plan Guides چیست؟
- Buffer Pool چیست؟
- Hints و فیلترها
- استفاده از شاخص Hints برای مقایسه شاخص Effectiveness
- Filtered Index
- امتحان بهترین کدهای دنیای برنامه نویسی
- Schema Qualified Objects
- توقف مرتب سازی پایگاه داده
- Trace Flags
- فعال کردن به روز رسانی خودکار Async
- نتیجه گیری
عنوان دوره: Udemy Advanced SQL Server Performance Tuning
نویسنده: Mike West
مدت دوره: 1.5 ساعت