Database Performance Settings

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE T-SQL Queries
Likes 112 Likes 112  
COURSE Encryption
Likes 69 Likes 69  
COURSE Architecture
Likes 17 Likes 17