SQL Server Administration Part 2
What you'll learn
- At the end of SQL Administration Part 2, the student will be able to create indexes for to gain performance, use the SQL Profiler to find and trouble shoot expensive queries, use the activity monitor for analysis, deploy the performance monitor to find specific about SQL Server internals, use DTA utility, create and investigate issues with DMVs and extended events, look at SQL logs, monitor the health of the SQL Server more efficiently and much more.
Course content
- Preview06:28
- Preview14:40
- 11:20Install SQL Suite
- 08:11POST ADDENDUM
- 07:34APPS NEEDED
- 18:22CREATE VM
- 09:43INSTALL SQL SERVER 2017
- 08:13ADVENTUREWORKS 2017 DB
- 02:38COMPARISON SQL SERVER 2014 VS 2017
- 16:59Clustered Index
- 12:07Create non cluster index
- 18:06Composite Index
- 11:20Use or not use indexes
- 20:09Deciding factors in creating indexes
- 19:41using sql profler for indexes
- 15:47Reorganize and Rebuild Indexes
- 17:57Into To SQL Profiler
- 13:37SQL Profiler longest running query
- 12:11Audit logins
- 10:40SQL Profile with Index Tuning
- 05:24SQL Profiler Best Practice
- 16:31SQL Server Side Trace
- 12:10Database Engine Tuning Advisor
- 11:44Statistics
- 14:01Activity Monitor
- 16:24SQL Performance Monitor
- 12:49SQL Performance hardware issues
- 16:47SQL Performance Monitoring Hardware CPU
- 10:10SQL Performance Monitoring Hardware memory
- 08:46SQL Performance Monitoring Hardware disks
- 08:5123 SQL Perfmon scehdule
- 13:53DMV
- 13:15Block and Locks
- 10:45BLOCKING
- 04:45Deadlock
- 18:20Extended Events
- 11:59Extended Events via TSQL
- 15:12Database Snapshots
- 10:01Import Export Data
- 12:59BCP
- 19:51Partition
- 19:51Partition part 2
- 12:46Partition 3
- 11:47Contained datababase Part 1
- 10:12Contained datababase Part 2
- 18:46Policy Based Management
- 08:20Linked Servers
- 05:24SQL server and agent logs
- 05:32SQL ADMINISTRATION PART 3
Requirements
- All the student needs is a laptop or a desktop. All material where appropriate will be downloaded via internet. Plus, you will need as a pre-requisite SQL Administration Part 1. All scripts and documentation will be provided by me to the student via zip file.
Description
SQL Administration Part 2 will benefit the student by providing the necessary guide lines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics; and also I will explain a handful of utilities to gather information about SQL Server internals, such as SQL Profiler, Database Tuning Advisor (DTA), Extended Events, SQL performance monitor, Activity monitor, and teach about partitions, creating contained database for recovery, reviewing SQL server logs and by installing SQL Server 2014 as the newer SQL version.The student will not only add to the knowledge gained bur SQL Administration Part 1, but get prepared for the next course SQL Administration Part 3 – the high availability solutions.
Who this course is for:
- Student who are interested in managing SQL Server, Developers, IT Admins, System Admins and anyone who is responsible for the databases.
Instructor
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.