Database Performance Settings
SQL Server 2016
| Intermediate
- 8 Videos | 32m 13s
- Includes Assessment
- Earns a Badge
SQL Server 2016 offers various tools to tune a SQL Server environment for peak performance. Discover how to maximize database performance as well as the maximum amount of server memory.
WHAT YOU WILL LEARN
-
describe how to evaluate and tune database performancedemonstrate how to improve performance by changing service tiersconfigure elastic database pools to scale resources automaticallyconfigure the database scope in SQL Server 2016
-
demonstrate how to configure memory options including min server memory and max server memorydemonstrate how to configure and view memory options using T-SQLdescribe the three approaches you can use to manage memory when running multiple instances of the database enginedescribe the role of operators in SQL Server 2016
IN THIS COURSE
-
1.Evaluate Database Performance4m 16sUP NEXT
-
2.Changing Service Tiers3m 23s
-
3.Elastic Database Pools4m 21s
-
4.Configuring the Database Scope3m 22s
-
5.SQL Server Management Studio Memory Management3m 47s
-
6.Configuring and Viewing Memory Using T-SQL4m 31s
-
7.Multiple Instances of SQL Server4m 40s
-
8.Exercise: Optimize Performance in SQL Server 20163m 54s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.