Database Performance Settings

SQL Server 2016    |    Intermediate
  • 8 Videos | 35m 43s
  • Includes Assessment
  • Earns a Badge
Likes 42 Likes 42
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

  • Playable
    1. 
    Evaluate Database Performance
    4m 16s
    UP NEXT
  • Playable
    2. 
    Changing Service Tiers
    3m 23s
  • Locked
    3. 
    Elastic Database Pools
    4m 21s
  • Locked
    4. 
    Configuring the Database Scope
    3m 22s
  • Locked
    5. 
    SQL Server Management Studio Memory Management
    3m 47s
  • Locked
    6. 
    Configuring and Viewing Memory Using T-SQL
    4m 31s
  • Locked
    7. 
    Multiple Instances of SQL Server
    4m 40s
  • Locked
    8. 
    Exercise: Optimize Performance in SQL Server 2016
    3m 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.

YOU MIGHT ALSO LIKE

Likes 8 Likes 8  
Likes 29 Likes 29  
Likes 57 Likes 57  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 75 Likes 75  
Likes 57 Likes 57  
Likes 110 Likes 110