SQL Server Optimizing Stored Procedure Performance [2014, ENG]
movies, software, shows...
Files
| 01 Introduction | |||
| 0101 Introduction.mp4 | 5.04 MB | ||
| 0102 This Course.mp4 | 4.63 MB | ||
| 0103 What Does Optimizing Stored Procedure Performance Mean.mp4 | 5.74 MB | ||
| 0104 Does This Sound Familiar.mp4 | 4.16 MB | ||
| 0105 What Does Optimizing Stored Procedure Performance NOT Mean.mp4 | 6.94 MB | ||
| 0106 Why This Course Is Relevant.mp4 | 5.53 MB | ||
| 0107 Course Focus and Structure (1).mp4 | 4.03 MB | ||
| 0108 Course Focus and Structure (2).mp4 | 4.51 MB | ||
| 02 Why Use Stored Procedures | |||
| 0201 Overview.mp4 | 3.01 MB | ||
| 0202 Different Ways to Execute SQL Statements.mp4 | 4.74 MB | ||
| 0203 Some Statements Can Be Cached for Reuse (1).mp4 | 3.73 MB | ||
| 0204 Some Statements Can Be Cached for Reuse (2).mp4 | 7.75 MB | ||
| 0205 Version-Specific Plan Caching Whitepapers.mp4 | 2.19 MB | ||
| 0206 Reducing Plan Cache Pollution.mp4 | 8.82 MB | ||
| 0207 Understanding sp_executesql.mp4 | 5.4 MB | ||
| 0208 Stored Procedures sp_executesql and the Cache.mp4 | 5.22 MB | ||
| 0209 Parameter Sniffing.mp4 | 3.79 MB | ||
| 0210 Summary Why Use Stored Procedures.mp4 | 6.57 MB | ||
| 03 Creation, Compilation, and Invalidation Section 1 | |||
| 0301 Overview.mp4 | 3.43 MB | ||
| 0302 What Happens When You Create a Procedure.mp4 | 6.05 MB | ||
| 0303 Where Are Stored Procedures Stored (1).mp4 | 8.65 MB | ||
| 0304 Where Are Stored Procedures Stored (2).mp4 | 25.32 MB | ||
| 0305 Creating Stored Procedures.mp4 | 40.96 MB | ||
| 0306 Stored Procedure Plans and Caching.mp4 | 80.96 MB | ||
| 0307 Side Effect Plan Cache Flush (1).mp4 | 17.23 MB | ||
| 0308 Side Effect Plan Cache Flush (2).mp4 | 46 MB | ||
| 0309 Side Effect Plan Cache Flush (3).mp4 | 3.66 MB | ||
| 0310 Side Effect Plan Cache Flush (4).mp4 | 3.95 MB | ||
| 0311 DEMO Generic Demo Intro.mp4 | 4.86 MB | ||
| 0312 DEMO Setup Credit Sample Database.mp4 | 10.88 MB | ||
| 0313 DEMO Setup Analysis Procedures for Credit.mp4 | 4.8 MB | ||
| 0314 DEMO Object-Level Invalidation or Eviction.mp4 | 2.59 MB | ||
| 0315 DEMO Database-Level Invalidation or Eviction.mp4 | 7.11 MB | ||
| 0316 DEMO Server-Level Invalidation or Eviction.mp4 | 6.35 MB | ||
| 04 Creation, Compilation, and Invalidation Section 2 | |||
| 0401 Plan Invalidation.mp4 | 10.86 MB | ||
| 0402 Plan Invalidation Due to Statistics Updates.mp4 | 8.28 MB | ||
| 0403 DEMO Plan Invalidation and Statistics - Part 1.mp4 | 74.76 MB | ||
| 0404 Updates to Statistics may not Invalidate Bad Plans.mp4 | 6.63 MB | ||
| 0405 DEMO Plan Invalidation and Statistics - Part 2.mp4 | 69.88 MB | ||
| 0406 Plan Invalidation Recompilation Causes.mp4 | 5.89 MB | ||
| 0407 Stored Procedure Caching + Compilation Concerns.mp4 | 6.94 MB | ||
| 0408 When Should You Recompile.mp4 | 7.47 MB | ||
| 0409 Summary Creation and Compilation.mp4 | 5.96 MB | ||
| 05 Optimization and Recompilation Section 1 | |||
| 0501 Overview.mp4 | 8.59 MB | ||
| 0502 Options for Recompilation.mp4 | 10.36 MB | ||
| 0503 sp_recompile object_name.mp4 | 19.17 MB | ||
| 0504 DEMO Long Blocking Chains.mp4 | 84.67 MB | ||
| 0505 CREATE ... WITH RECOMPILE.mp4 | 8.36 MB | ||
| 0506 DEMO CREATE ... WITH RECOMPILE.mp4 | 37.62 MB | ||
| 0507 Conditional Logic.mp4 | 7.36 MB | ||
| 0508 DEMO Conditional Logic - Part 1.mp4 | 55.11 MB | ||
| 0509 Modularization.mp4 | 8.99 MB | ||
| 0510 DEMO Conditional Logic - Part 2 - Modularization.mp4 | 36.53 MB | ||
| 06 Optimization and Recompilation Section 2 | |||
| 0601 EXECUTE ... WITH RECOMPILE (1).mp4 | 8.19 MB | ||
| 0602 DEMO EXECUTE ... WITH RECOMPILE For Testing.mp4 | 71.72 MB | ||
| 0603 EXECUTE ... WITH RECOMPILE (2).mp4 | 9.2 MB | ||
| 0604 DEMO Determining Plan Stability.mp4 | 60.97 MB | ||
| 0605 Statement-Level Recompilation.mp4 | 13.99 MB | ||
| 0606 DEMO Recompilation With OPTION (RECOMPILE).mp4 | 33.53 MB | ||
| 0607 DEMO Recompilation With OPTION (Optimize For Literal).mp4 | 31.47 MB | ||
| 0608 DEMO Recompilation With OPTION (Optimize For UNKNOWN).mp4 | 59.49 MB | ||
| 0609 DEMO Variables Simulate Optimize For UNKNOWN.mp4 | 17.59 MB | ||
| 07 Optimization and Recompilation Section 3 | |||
| 0701 OPTION (RECOMPILE).mp4 | 7.77 MB | ||
| 0702 OPTIMIZE FOR ....mp4 | 9.67 MB | ||
| 0703 DEMO Scenario - Setup.mp4 | 25.98 MB | ||
| 0704 DEMO Scenario - Scenario Explained.mp4 | 29.8 MB | ||
| 0705 DEMO Scenario - Conditional Logic Does NOT Work.mp4 | 28.35 MB | ||
| 0706 DEMO Scenario - EXEC With RECOMPILE.mp4 | 35.2 MB | ||
| 0707 DEMO Scenario - Conditional Logic Plus Modularization WORKS.mp4 | 31.87 MB | ||
| 0708 DEMO Stabilizing Plans With Indexes - Setup and Scenario.mp4 | 24.26 MB | ||
| 0709 DEMO Stabilizing Plans With Indexes - Plan Stability.mp4 | 52.74 MB | ||
| 0710 DEMO Stabilizing Plans With Indexes - Voila.mp4 | 52.05 MB | ||
| 0711 Summary Walkthrough Demo (1).mp4 | 4.97 MB | ||
| 0712 Summary Walkthrough Demo (2).mp4 | 6.09 MB | ||
| 08 Optimization and Recompilation Section 4 | |||
| 0801 When Does a Procedure Get Optimized.mp4 | 9.06 MB | ||
| 0802 Server-Wide OPTIMIZE FOR UNKNOWN.mp4 | 7.22 MB | ||
| 0803 The Checkered Past of OPTION (RECOMPILE).mp4 | 8.87 MB | ||
| 0804 Dynamic String Execution.mp4 | 9.37 MB | ||
| 0805 DEMO Dynamic String Execution.mp4 | 64.43 MB | ||
| 0806 Multi-Purpose Procedures.mp4 | 7.54 MB | ||
| 0807 Building Strings Dynamically and Caching.mp4 | 12.24 MB | ||
| 0808 DEMO Multi-Purpose Procedures - Setup and Scenario.mp4 | 39.62 MB | ||
| 0809 DEMO Multi-Purpose Procedures - The Problem.mp4 | 32.03 MB | ||
| 0810 DEMO Multi-Purpose Procedures - Option Recompile too Much CPU.mp4 | 24.79 MB | ||
| 0811 DEMO Multi-Purpose Procedures - The Ultimate Multi-Purpose Proc.mp4 | 114.85 MB | ||
| 0812 Patterns and Practices in Statement Recompilation.mp4 | 8.38 MB | ||
| 0813 Summary Stored Procedure Pitfalls-Performance.mp4 | 1.56 MB | ||
| 09 Other Concerns and Considerations | |||
| 0901 Overview.mp4 | 5.36 MB | ||
| 0902 Demystifying Plan Caching for Bad Plans.mp4 | 5.2 MB | ||
| 0903 Secondary Concerns and Considerations.mp4 | 13.98 MB | ||
| 0904 Optimizing Statement and Procedure Performance.mp4 | 5.18 MB | ||
| 0905 Just the Tip of the Iceberg.mp4 | 8 MB | ||
| 0906 Course Summary.mp4 | 2.61 MB |
Description
Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)
SQL Server Optimizing Stored Procedure Performance
Год выпуска: 2014
Производитель: Pluralsight
Сайт производителя: pluralsight.com
Автор: Kimberly Tripp
Продолжительность: 7:11
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: If you want to use SQL Server databases effectively, you will end up using stored procedures. Their aim is that you have optimized and compiled code that resides in a cache to improve workload performance for subsequent executions. However, you might find that it does not always work out that way. The performance of a stored procedure is heavily dependent on how the plan is chosen and cached. If the plan is not optimal for subsequent executions it could cause performance to suffer greatly. In the end, you might suffer from what is known as parameter-sniffing-problems where the optimal plan for a procedure varies based on the parameters supplied. This comprehensive course will teach you how stored procedure plan caching works and how to get SQL Server to produce the optimal plan for your stored procedure performance in a variety of circumstances. The course is applicable to SQL Server developers and anyone who is responsible for writing stored procedures that must repeatedly perform well. The demo database provided is compatible with SQL Server 2008 through SQL Server 2014. All course demos are shown on SQL Server 2014 with references to behaviors (where different) on all versions. Optimization strategies you will learn in the course apply to SQL Server 2005 onward, and some even back to SQL Server 2000.
[spoiler="Содержание"]
Introduction
Introduction
This Course
What Does Optimizing Stored Procedure Performance Mean?
Does This Sound Familiar?
What Does Optimizing Stored Procedure Performance NOT Mean?
Why This Course Is Relevant
Course Focus and Structure (1)
Course Focus and Structure (2)
Why Use Stored Procedures?
Overview
Different Ways to Execute SQL Statements
Some Statements Can Be Cached for Reuse (1)
Some Statements Can Be Cached for Reuse (2)
Version-Specific Plan Caching Whitepapers
Reducing Plan Cache Pollution
Understanding sp_executesql
Stored Procedures / sp_executesql and the Cache
Parameter Sniffing
Summary: Why Use Stored Procedures?
Creation, Compilation, and Invalidation Section 1
Overview
What Happens When You Create a Procedure?
Where Are Stored Procedures Stored? (1)
Where Are Stored Procedures Stored? (2)
Creating Stored Procedures
Stored Procedure Plans and Caching
Side Effect: Plan Cache Flush (1)
Side Effect: Plan Cache Flush (2)
Side Effect: Plan Cache Flush (3)
Side Effect: Plan Cache Flush (4)
DEMO: Generic Demo Intro
DEMO: Setup Credit Sample Database
DEMO: Setup Analysis Procedures for Credit
DEMO: Object-Level Invalidation or Eviction
DEMO: Database-Level Invalidation or Eviction
DEMO: Server-Level Invalidation or Eviction
Creation, Compilation, and Invalidation Section 2
Plan Invalidation
Plan Invalidation Due to Statistics Updates
DEMO: Plan Invalidation and Statistics - Part 1
Updates to Statistics may not Invalidate Bad Plans
DEMO: Plan Invalidation and Statistics - Part 2
Plan Invalidation / Recompilation Causes
Stored Procedure Caching + Compilation Concerns
When Should You Recompile?
Summary: Creation and Compilation
Optimization and Recompilation Section 1
Overview
Options for Recompilation
sp_recompile object_name
DEMO: Long Blocking Chains
CREATE ... WITH RECOMPILE
DEMO: CREATE ... WITH RECOMPILE
Conditional Logic
DEMO: Conditional Logic - Part 1
Modularization
DEMO: Conditional Logic - Part 2 - Modularization
Optimization and Recompilation Section 2
EXECUTE ... WITH RECOMPILE (1)
DEMO: EXECUTE ... WITH RECOMPILE For Testing
EXECUTE ... WITH RECOMPILE (2)
DEMO: Determining Plan Stability
Statement-Level Recompilation
DEMO: Recompilation With OPTION (RECOMPILE)
DEMO: Recompilation With OPTION (Optimize For Literal)
DEMO: Recompilation With OPTION (Optimize For UNKNOWN)
DEMO: Variables Simulate Optimize For UNKNOWN
Optimization and Recompilation Section 3
OPTION (RECOMPILE)
OPTIMIZE FOR ...
DEMO: Scenario - Setup
DEMO: Scenario - Scenario Explained
DEMO: Scenario - Conditional Logic Does NOT Work
DEMO: Scenario - EXEC With RECOMPILE
DEMO: Scenario - Conditional Logic Plus Modularization WORKS!
DEMO: Stabilizing Plans With Indexes - Setup and Scenario
DEMO: Stabilizing Plans With Indexes - Plan Stability
DEMO: Stabilizing Plans With Indexes - Voila!
Summary: Walkthrough Demo (1)
Summary: Walkthrough Demo (2)
Optimization and Recompilation Section 4
When Does a Procedure Get Optimized?
Server-Wide: OPTIMIZE FOR UNKNOWN
The Checkered Past of OPTION (RECOMPILE)
Dynamic String Execution
DEMO: Dynamic String Execution
Multi-Purpose Procedures
Building Strings Dynamically and Caching
DEMO: Multi-Purpose Procedures - Setup and Scenario
DEMO: Multi-Purpose Procedures - The Problem
DEMO: Multi-Purpose Procedures - Option Recompile too Much CPU
DEMO: Multi-Purpose Procedures - The Ultimate Multi-Purpose Proc
Patterns and Practices in Statement Recompilation
Summary: Stored Procedure Pitfalls/Performance
Other Concerns and Considerations
Overview
Demystifying Plan Caching for Bad Plans
Secondary Concerns and Considerations
Optimizing Statement and Procedure Performance
Just the Tip of the Iceberg
Course Summary
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC, 1024x768, 4:3, 15fps, 743kbps
Аудио: AAC, 44.1kHz, 128kbps, stereo
[spoiler="Скриншоты"]
[/spoiler]
Related Torrents
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 262.4 MB | freecoursewb | 5 months | 3 | 4 | |
| 1.8 GB | freecoursewb | 8 months | 7 | 8 | |
|
Udemy - Ultimate SQL Beginner to Intermediate Guide using SQL Server Posted by
freecoursewb in Other
|
3 GB | freecoursewb | 9 months | 5 | 1 |
| 1.3 GB | freecoursewb | 1 year | 4 | 3 | |
| 1.6 GB | freecoursewb | 1 year | 0 | 0 |
All Comments