How to Become a World Class.SQL Server Performance Tuner

[caovantan 42]

How to Become a World Class SQL Server Performance Tuner

English | 2015 | mp4 | H264 1280x720 | AAC 2 ch | 3 hrs | 404 MB

eLearning, IT & Software, Operating Systems | Skill level: All level

 

Use These Scripts in Production Right Now

Some Course Reviews.

"I've also looked at the database with multiple system monitoring products. But really where do I go from here? and when I find the problem what do I really need to do? Mike really shows you the nitty gritty."

 

"This was just the course I have been waiting for. Mike's demos and scripts have helped me become a confident tuner. The best thing about this course was that I was able to improve our server performance straightaway."

 

"I already have a great deal of DBA related experienced in the real world. What this course did for me was help me establish a model, and strategy for database tuning and performance monitoring."

 

Thank you reviewers for your kind feedback.

 

This course focuses on making SQL Server more performant.

 

SQL Server is like a high performance sports car. Anyone can drive it but put it in the hands of a skilled performance tuner and you've just gone from average to incredible.

 

No one wants an average performing system and with the KNOWLEDGE acquired from THIS COURSE your performance tuning acumen won't be average either.

 

This course will give YOU the foundation to become a skilled PERFORMANCE TUNER.

 

WE will start by building a baseline. How can you measure YOUR success without knowing how poorly the system was before you arrived?

 

Baselines give us a before and after snapshot of the system we are going to tune.

 

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.

 

A database is a collection of objects. The most fundamental and most important is the table object. Users interact with tables via transactions. Most online transaction processing databases are read and write heavy. We put data into to our tables or INSERT it and we read that data or SELECT it.

 

Let's use an online ordering system as an example. I need a product and I've found it on x(dot)com. Before I can order it I need to give x(dot)com a few things. My name, address, product I'm ordering and money of course. All this information is INSERTED into various tables. Once I've provided all the necessary information someone at x(dot)has to SELECT or read that data so my order can be filled.

 

Imagine for a minute that I make several attempts to provide x(dot)com with my name, address... etc. However, after three attempts the information can't be saved to the database and I receive multiple errors. Most people won't try three times unless the product can't be purchased somewhere else. Most users will look elsewhere after that second failure.

 

This course WILL provide YOU with the foundation necessary to ensure data can be saved and retrieved so the database will have an organic flow of transactions.

 

ENROLL now. Let's get started!!!

 

What are the requirements?

- You will need to have SQL Server 2012 or 2014 installed. It can be an express version.

- I'll be providing all the scripts and schema for the course. There is no other cost other than the price of the course. Everything else is included or free.

- If you don't have a performance tuning script library then we will start one. If you do, then we will add to it.

- If you're not familiar with SQL Server fundamentals then this course may not be for you. I do appreciate and understand your enthusiasm and promise this course will be here when you're ready.

 

What am I going to get from this course?

- Over 52 lectures and 2 hours of content!

- By the end of this course you will have a systematic process approach and all the necessary tools needed to begin your journey as a SQL Server performance tuner.

- In this course we will define our performance tuning objectives before we dive head first into tuning. What is our end goal? What steps are we going to take to arrive at this goal? Our end goal needs to be realistic and measureable.

- Let's define them right now. Your goal be the end of the course will be speed up data retrieval on the worst performing queries by at least 30%.

- Secondly, your goal will be to reduce system stress on either the IO subsystem, memory or cpu by 20%.

 

What is the target audience?

- If you have basic understanding of SQL Server and want to learn how to tune and optimize a SQL Server then this course is for you.

- This course is not a beginner's course. Most of the students will be junior to mid-level SQL Server resources.

- You'll need to be familiar with transact SQL and have a strong grasp navigating SQL Server Mangement Studio.

- Using the collegiate scale as a guide this course will be a 300 level course. Please keep in mind this is a 101 level course for performance tuning and optimization, which is an advanced topic within the umbrella of the DBA.

 

 

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.