Database Performance Settings

SQL Server 2016    |    Intermediate
  • 8 videos | 32m 13s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 19 users Rating 4.3 of 19 users (19)
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 16s
    After completing this video, you will be able to describe how to evaluate and improve database performance. FREE ACCESS
  • 3m 23s
    In this video, you will learn how to improve performance by changing service levels. FREE ACCESS
  • Locked
    3.  Elastic Database Pools
    4m 21s
    Find out how to configure elastic database pools to automatically scale resources. FREE ACCESS
  • Locked
    4.  Configuring the Database Scope
    3m 22s
    Learn how to configure the database scope in SQL Server 2016. FREE ACCESS
  • Locked
    5.  SQL Server Management Studio Memory Management
    3m 47s
    In this video, you will learn how to configure memory options, including min server memory and max server memory. FREE ACCESS
  • Locked
    6.  Configuring and Viewing Memory Using T-SQL
    4m 31s
    In this video, you will learn how to configure and view memory options using T-SQL. FREE ACCESS
  • Locked
    7.  Multiple Instances of SQL Server
    4m 40s
    Upon 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
  • Locked
    8.  Exercise: Optimize Performance in SQL Server 2016
    3m 54s
    After 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.

YOU MIGHT ALSO LIKE

Course Performance Tuning & Availability Sets
Rating 4.6 of 10 users Rating 4.6 of 10 users (10)
Book Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers, 2nd Edition
Book Azure SQL Hyperscale Revealed: High-performance Scalable Solutions for Critical Data Workloads

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Performance Tuning & Availability Sets
Rating 4.6 of 10 users Rating 4.6 of 10 users (10)
Course Performance Metrics
Rating 4.6 of 50 users Rating 4.6 of 50 users (50)
Course Backup Management
Rating 4.5 of 82 users Rating 4.5 of 82 users (82)