Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2020-12-13 01:34:27
30-Day Money-Back Guarantee

This course includes:

  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development SQL Server

SQL Server Love Linux:效能篇

從DBA人員角度切入,深入淺出SQL Server效能調校技巧!
Rating: 0.0 out of 50.0 (0 ratings)
5 students
Created by Rico Chen
Last updated 9/2020
Traditional Chinese
30-Day Money-Back Guarantee

What you'll learn

  • 獲取SQL Server查詢效能知識,搞懂資料庫管理核心
  • 知道如何利用優化過的索引設計提高查詢效能
  • 了解如何快速比較查詢效能,有效追蹤各種成效
  • 搞懂SQL Server等待類型,達到資源利用最大化
  • 釐清SQL Server封鎖和死鎖原因,輕鬆避開效能地雷
  • 學會正確閱讀與優化執行計畫,享受執行計畫所帶來的快感

Course content

6 sections • 25 lectures • 5h 23m total length

  • Preview03:53
  • Preview02:49
  • 常見效能主因
    09:31
  • 效能優化步驟
    09:41
  • SQL Server重要設定
    05:03
  • 善用擴充事件
    24:55

  • 概述
    03:25
  • Preview13:22
  • 閱讀執行計畫
    22:11
  • 實戰執行計畫優化
    42:06

  • Preview06:10
  • 兩大類型特性
    12:43
  • 統計資訊
    12:43
  • 實戰索引優化
    16:15
  • 實戰索引維護
    16:14

  • 名詞定義
    13:10
  • 深入淺出鎖定機制
    24:10
  • 閱讀死結報表和減少死結
    14:55
  • 交易最佳實踐
    03:54

  • 等待簡介
    11:24
  • 鎖定等待
    09:26
  • 平行等待
    18:30
  • I/O等待
    10:59

  • 暫存資料表的進化
    07:46
  • 純量值函式的改善
    07:57

Requirements

  • 知道SQL Server用途
  • 知道Linux用途
  • 知道Hyper-V用途

Description

@耗費了許多功夫將 SQL Server 轉移到 Linux 後 ,就能高枕無憂嗎?

我專為DBA人員而生的SQL Server效能調校課程,帶你搞懂效能地雷並有效避開!

公司為了不付昂貴的授權費於是改用 Linux,但是資料庫出問題時 ···

  • 網絡不穩定、資源不足、突發性大數據量操作.....到底如何快速判斷主因呢?

  • 如何在合理前提下,透過表分割槽、檔案組拆分等操作,提高SQL Server能力?

  • 怎麼樣才能因應Linux及Windows各自的系統優勢,調整效能調校的方法呢?

  • 使用者人數突然暴增時,如何避免出現回應時間大幅降低甚至逾時錯誤的情形?

別擔心,這些問題都將在SQL Server on Linux - 效能篇中一一為你解答!

這堂課中,將為你從執行計畫、索引、鎖定、等待幾個面向切入,介紹常見的效能問題以及對應的解決方法,帶你養成系統性的問題解決思維!

這系列課程由 DBA 角度來看 SQL Server on Linux,絕不單單只有實務上工作技巧,更介紹許多效能調校的核心觀念,就是要讓你知其然,更知其所以然,減少問題定位和排除時間。


@獨家提供SQL Server效能優化實戰技巧

這堂課我將提供許多個人實戰範例與獨家優化技巧!當我們面對各種資料庫問題的可能原因時,這些內容將可以協助你更快速的定位與解決問題,也可以避開我曾經踩過的雷!

Who this course is for:

  • 適合中高階DBA,養成完整的系統式思維
  • 適合SQL Server愛好者,從入門到打底完整教學
  • 適合對SQL Server On Linux有興趣者或有需求者
  • 適合對SQL Server效能調校有興趣者,教你快速定位效能問題
  • 適合立志朝高階SQL Server DBA、SQL Server Developer或資料庫架構師的專業人員

Instructor

Rico Chen
浪跡Net埋首SQL Server效能調校工匠
Rico Chen
  • 4.8 Instructor Rating
  • 58 Reviews
  • 112 Students
  • 12 Courses

連續八年當選微軟最有價值專家,業界實務經歷超過10年。

擅長使用.NET/NetCore(C#) 技術開發 Web/OLTP 系統,並熟悉分散式架構設計實作、程式碼重構和效能調校,

也熟悉SQL Server應用開發、架構設計、效能調校和管理,

幫助許多企業從無到有規劃設計並開發核心系統、核心系統架構改造升級、核心系統效能調校,

並針對企業開發人員或DBA進行教育訓練,也擁有多年大型資料庫效能調校教學經驗

曾任企業資深架構師、RD經理、技術經理、資深研發工程師、專案經理、資深技術顧問、資深DBA,

微軟 SQL Server 研討會講師、Udemy線上講師、SQL Pass社群講師、RunPC(CIO前身)技術專欄作家。

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.