#C کلید ورود به بازار کار

دوره پروژه‌محور #C و ASP.NET Core

C#
C#
مشخصات فیلم
  • 8569
  • 3813
  • 0
  • 0.0
  • 0

آموزش بهبود رویه های ذخیره شده در SQL Server

با مشاهده این مجموعه آموزش چگونگی بهینه سازی کارایی رویه های ذخیره شده (Stored Procedures) را در SQL Server خواهید آموخت.
این مجموعه آموزش ویدیویی محصول موسسه آموزشی PluralSight است که به صورت کاملا رایگان و به مدت زمان 7 ساعت و 11 دقیقه در اختیار علاقه مندان قرار می گیرد
.

clip_image002

clip_image004

clip_image006

در ادامه با برخی از سرفصل های درسی این مجموعه آموزش 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 بخش سوم
1394/11/20 8569 3813
رمز عبور : tahlildadeh.com یا www.tahlildadeh.com
نظرات شما

نظرات خود را ثبت کنید...