LearnNowOnline_SQL_Admin_2014_Server_Optimization

در این آموزش تصویری با بهینه سازی سرور SQL Server 2014 آشنا می شوید.

این دوره آموزشی محصول موسسه LearnNowOnline است.

سرفصل های دوره:

  • ردیابی پرچم – فعال / غیر فعال
  • مانیتورینگ
  • بن بست
  • ردیابی پرچم ها
  • قفل دوبل
  • نمایش های مدیریت پویا
  • توابع DMV
  • رویدادهای قابل تعمیم
  • جلسات
  • بلوک ها و وقفه ها
  • انسداد
  • شناسایی انسداد
  • مسدود کردن و DMVs
  • و…

عنوان دوره:  LearnNowOnline SQL Admin 2014: Server Optimization
مدت زمان: 1 ساعت و 19 دقیقه
نویسنده:  Chris Bell


توضیحات:

LearnNowOnline SQL Admin 2014: Server Optimization

Chris Bell
1h 19m



Course description
In this course you are going to see a few topics covering some basic optimizing and troubleshooting in SQL Server. You will see what Trace flags are and how they are used to alter the behavior of SQL Server. Sometimes this is useful, sometimes it is dangerous and sometimes it is just bizarre what they do. You will see how the use of trace flags to capture deadlock information so you can more efficiently troubleshoot the cause. Then you will see blocks, a common issue in SQL Server and see how to determine which process is blocking others and how to resolve it. Next you will then go through a series of DMVs that are quite useful in optimizing and troubleshooting SQL Server. You'll see some DMV based queries used all the time to check indexes fragmentation and usage along with a query to identify the most expensive queries in your database.
Prerequisites
This course assumes that students have working experience with SQL Server; basic relational database concepts e.g., tables, queries, and indexing; general knowledge of XML, Transact-SQL, and a fundamental understanding of networking and security concepts.

Trace Flags
20:58
Introduction
00:23
Trace Flags
01:35
Trace Flags - Enable/Disable
01:12
Trace Flags - Monitoring
00:40
Trace Flags - Deadlocks
01:17
Trace Flags - Useful
01:28
Trace Flag - Other
01:54
Demo: Trace Flags
06:01
Demo: Deadlocking
03:35
Demo: Log File
02:36
Summary
00:12
Dynamic Management Views
16:36
Introduction
00:30
Dyanamic Management Views
01:05
DMV - Execution Related
01:21
DMV - Index Related
01:37
DMV - Disk Stats & OS/Hardware
01:37
Demo: DMVs
05:19
Demo: DMV Functions
04:42
Summary
00:22
Extended Events
13:58
Introduction
00:28
Extended Events
01:34
Demo: Extended Events
07:30
Demo: Sessions
04:02
Summary
00:22
Blocks and Deadlocks
27:27
Introduction
00:31
Blocking
00:49
Blocking - Detecting
01:39
Blocks - Killing Process
01:45
Deadlocks
02:37
Demo: Identifying Blocking
07:44
Demo: Blocking and DMVs
04:46
Demo: Deadlocks
07:20
Summary
00:12