Database Performance Settings
SQL Server 2016
| Intermediate
- 8 Videos | 35m 43s
- 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 performance
demonstrate how to improve performance by changing service tiers
configure elastic database pools to scale resources automatically
configure the database scope in SQL Server 2016 -
demonstrate how to configure memory options including min server memory and max server memory
demonstrate how to configure and view memory options using T-SQL
describe the three approaches you can use to manage memory when running multiple instances of the database engine
describe 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.
