Optimization & Troubleshooting

SQL Server 2014    |    Expert
  • 7 videos | 34m 20s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 11 users Rating 4.4 of 11 users (11)
Microsoft SQL Server 2014 includes new features to provide optimal performance for applications. Discover some of these features and see how to optimize both queries and overall security in SQL Server 2014.

WHAT YOU WILL LEARN

  • Create a plan guide
    Optimize queries for better performance
    Manage contention and auto growth in a database
    Implement resource governor to manage resources in a database
  • Review extended event logs and optimize extended event session settings
    Use activity monitor
    Integrate performance monitor data with sql traces

IN THIS COURSE

  • 6m 10s
    In this video, you will learn how to create a plan guide. FREE ACCESS
  • 4m 27s
    During this video, you will learn how to optimize queries for better performance. FREE ACCESS
  • Locked
    3.  Troubleshooting SQL Server 2014 Database Size Issues
    4m 7s
    In this video, learn how to manage contention and auto growth in a database. FREE ACCESS
  • Locked
    4.  Implementing Resource Governor in SQL Server 2014
    7m 48s
    In this video, you will learn how to use Resource Governor to manage resources in a database. FREE ACCESS
  • Locked
    5.  Using Extended Events in SQL Server 2014
    4m 11s
    In this video, you will review Extended Event logs and optimize Extended Event session settings. FREE ACCESS
  • Locked
    6.  Using Activity Monitor in SQL Server 2014
    3m 15s
    In this video, you will learn how to use Activity Monitor. FREE ACCESS
  • Locked
    7.  Integrating Data with SQL Traces in SQL Server 2014
    4m 21s
    In this video, you will learn how to integrate performance monitor data with SQL Server traces. 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 Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Database Performance at Scale: A Practical Guide
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Design & Install Analysis Services
Rating 4.7 of 6 users Rating 4.7 of 6 users (6)
Book Mastering Machine Learning with Python in Six Steps: A Practical Implementation Guide to Predictive Data Analytics Using Python, Second Edition
Course Microsoft 365 Fall 2022 Update
Rating 4.2 of 21 users Rating 4.2 of 21 users (21)