From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Leverage the SQL Tuning Advisor - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Leverage the SQL Tuning Advisor
- [Instructor] Sequel server ships with an external tool called the database engine tuning advisor. And it'll evaluate a single query or a batch of sequel code and suggest areas where the database's performance might be improved. Let's take a look at how it works and in order to start it, I'll come down to the start menu. I'll go to all apps. I'll scroll down to Microsoft Sequel Server 2016. And scroll down a little bit more and find the Sequel Server 2016 Database Engine Tuning Advisor. Go ahead and click on it to start it up. The first time you start a tool, it'll need to be initialized by a member of the assisted men fix server role. After the assistant administrator, can assign members of a DB owner role access in order to manage the tables in their own databases. We'll start by connecting to the same sequel server instance that we've been working with. And I'm going to use Windows authentication and my username.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.