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 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
-
4m 16sAfter completing this video, you will be able to describe how to evaluate and improve database performance. FREE ACCESS
-
3m 23sIn this video, you will learn how to improve performance by changing service levels. FREE ACCESS
-
3. Elastic Database Pools4m 21sFind out how to configure elastic database pools to automatically scale resources. FREE ACCESS
-
4. Configuring the Database Scope3m 22sLearn how to configure the database scope in SQL Server 2016. FREE ACCESS
-
5. SQL Server Management Studio Memory Management3m 47sIn this video, you will learn how to configure memory options, including min server memory and max server memory. FREE ACCESS
-
6. Configuring and Viewing Memory Using T-SQL4m 31sIn this video, you will learn how to configure and view memory options using T-SQL. FREE ACCESS
-
7. Multiple Instances of SQL Server4m 40sUpon completion of this video, you will be able to describe three approaches you can use to manage memory when running multiple instances of the database engine. FREE ACCESS
-
8. Exercise: Optimize Performance in SQL Server 20163m 54sAfter completing this video, you will be able to describe the role of operators in SQL Server 2016. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
