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

Book Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud, 4th Edition
Book High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition
Journey Analyze Data with SQL
Rating 4.8 of 12 users Rating 4.8 of 12 users (12)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting to Know Macros in Excel 2019 for Windows
Rating 4.4 of 307 users Rating 4.4 of 307 users (307)
Course SNCF: Security Intelligence & Policies
Rating 4.5 of 8 users Rating 4.5 of 8 users (8)
Course T-SQL Queries
Rating 4.3 of 218 users Rating 4.3 of 218 users (218)