مشخصات فیلم
-
8566
-
3813
-
0
-
0.0
-
0
آموزش بهبود رویه های ذخیره شده در SQL Server
با مشاهده این مجموعه آموزش چگونگی بهینه سازی کارایی رویه های ذخیره شده (Stored Procedures) را در SQL Server خواهید آموخت.
این مجموعه آموزش ویدیویی محصول موسسه آموزشی PluralSight است که به صورت کاملا رایگان و به مدت زمان 7 ساعت و 11 دقیقه در اختیار علاقه مندان قرار می گیرد.
در ادامه با برخی از سرفصل های درسی این مجموعه آموزش SQL Server آشنا می شویم.
مقدمه
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)
آشنایی با دلایل استفاده از Stored Procedure ها
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?
آموزش ساخت، کامپایل و Invalidation - بخش اول
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
آموزش ساخت، کامپایل و Invalidation - بخش دوم
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
آموزش بهبود و کامپایل دوباره Stored Procedure ها – بخش اول
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
آموزش بهبود و کامپایل دوباره Stored Procedure ها – بخش دوم
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
آموزش بهبود و کامپایل دوباره Stored Procedure ها – بخش سوم
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)
آموزش بهبود و کامپایل دوباره Stored Procedure ها – بخش چهارم
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
آموزش دیگر تکنیک های بهبود Stored Procedure ها
Overview
Demystifying Plan Caching for Bad Plans
Secondary Concerns and Considerations
Optimizing Statement and Procedure Performance
Just the Tip of the Iceberg
Course Summary
| دانلود آموزش بهبود رویه های ذخیره شده در SQL Server بخش اول | |
| دانلود آموزش بهبود رویه های ذخیره شده در SQL Server بخش دوم | |
| دانلود آموزش بهبود رویه های ذخیره شده در SQL Server بخش سوم |