Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Development
Database Design & Development
SQL Server
SQL Server Performance Tuning

SQL Server Performance Tuning

Loại khoá học: Database Design & Development

Index maintenance, Query Tuning, dealing with TempDb issues and many more.

image
50.000 VND
599.000 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

You will get a conceptual understanding of various SQL Server database performance issues and learn about different places to check for the performance information along with tuning approach.

Broadly this course will cover following:

Understanding SQL Server waits and how to resolve it.

Tempdb contention issues.

Learn about database statistics, optimizer and maintenance plan for tables and indexes.

SQL Tuning techniques.

Partition in SQL Server.

General guidelines for avoiding performance issues in SQL database.

Bạn sẽ học được gì

This tutorial will provide comprehensive material of SQL Server performance tuning along with handy tips for issue resolution.

Provide details about SQL waits and resolution.

Learn about database statistics, optimizer and maintenance plan for tables and indexes.

SQL Tuning techniques

General guidelines for avoiding performance issues in SQL database.

Yêu cầu

  • Basic understanding of SQL Server and some experience in writing T-SQL.

Nội dung khoá học

8 sections

Course Layout

1 lectures
Introduction
03:38

SQL Server Waits

5 lectures
How SQL Server executes query
07:48
Waits - 1
12:26
Waits - 2
09:18
Waits-Demo
04:25
SQL Server performance counters
04:01

Indexes

8 lectures
Index Types
11:40
Index Demo - 1
04:54
Un-used and missing indexes
05:26
Index Demo - 2(a)
03:47
Index Demo - 2(b)
02:51
Index Demo - 2(c)
03:07
Index Maintenance
17:51
Index Demo - 3
02:41

Tempdb

5 lectures
Tempdb Contents
13:02
Tempdb Content Demo
04:17
Tempdb Best practices
04:58
Tempdb Contention
11:24
Tempdb Demo
03:02

Diagnostic Tools

4 lectures
Statistics IO and Statistics Time
07:40
Diagnostic Tools - Demo
03:01
SQL Server Profiler
07:18
Activity Monitor Demo
02:41

SQL Query Tuning

5 lectures
Introduction
02:40
Optimizer Hints
10:04
Parameter Sniffing
04:38
Parameter Sniffing Demo
04:34
Server Configuration
08:10

Partition in SQL Server

1 lectures
Partition
16:53

Demo Scripts

5 lectures
Waits Demo
04:07
Index Demo Scripts
04:07
Tempdb Demo Scripts
03:34
SQL Tuning Demo Scripts
01:49
Diagnostic Tools Demo scripts
02:05

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

Self Driving and ROS - Learn by Doing! Odometry & Control

Self Driving and ROS - Learn by Doing! Odometry & Control

1.599.000 VND
50.000 VND
Practice Exams | AWS Certified Solutions Architect Associate

Practice Exams | AWS Certified Solutions Architect Associate

125 VND
50.000 VND
Ethical Hacking Course by Black Hat Pakistan

Ethical Hacking Course by Black Hat Pakistan

26 VND
50.000 VND
AWS Cloud for beginner (Vietnamese)

AWS Cloud for beginner (Vietnamese)

90 VND
50.000 VND
OpenStack Essentials

OpenStack Essentials

1.499.000 VND
50.000 VND
Java Certification : OCA (1Z0-808) Exam Simulation [2023]

Java Certification : OCA (1Z0-808) Exam Simulation [2023]

1.399.000 VND
50.000 VND
Master Big Data - Apache Spark/Hadoop/Sqoop/Hive/Flume/Mongo

Master Big Data - Apache Spark/Hadoop/Sqoop/Hive/Flume/Mongo

1.049.000 VND
50.000 VND
Reverse Engineering and Malware Analysis Fundamentals

Reverse Engineering and Malware Analysis Fundamentals

1.399.000 VND
50.000 VND
Microsoft Windows Server 2016 Training for Beginners

Microsoft Windows Server 2016 Training for Beginners

1.799.000 VND
50.000 VND
Learn Autocad API with C# - MVVM - WPF

Learn Autocad API with C# - MVVM - WPF

25 VND
50.000 VND
Ultimate AWS Certified Solutions Architect Associate SAA-C03

Ultimate AWS Certified Solutions Architect Associate SAA-C03

185 VND
50.000 VND
Website Hacking / Penetration Testing

Website Hacking / Penetration Testing

95 VND
50.000 VND
10 Sample Exams ISTQB Foundation Level (CTFL) v4.0 [NEW!]

10 Sample Exams ISTQB Foundation Level (CTFL) v4.0 [NEW!]

26 VND
50.000 VND
MongoDB : A Complete Database Administration Course

MongoDB : A Complete Database Administration Course

999.000 VND
50.000 VND
Become Zabbix Administrator For Expert

Become Zabbix Administrator For Expert

799.000 VND
50.000 VND
Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

90 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi