Extended Events & SQL Trace

SQL Server 2016    |    Intermediate
  • 8 videos | 46m 7s
  • Includes Assessment
  • Earns a Badge
Improve the performance of your SQL Server 2016 database. Discover how to use SQL Server Extended Events and SQL Trace to monitor your SQL Server instances.

WHAT YOU WILL LEARN

  • Describe the benefits of using extended events
    Describe extended events tasks
    Differentiate between extended events packages, targets, and sessions
    Distinguish between extended events targets
  • Describe the sql trace architecture
    Create a trace using transact-sql
    Optimize sql trace to minimize performance costs
    Demonstrate how to schedule tracing in sql server

IN THIS COURSE

  • 5m 39s
    After completing this video, you will be able to describe the benefits of using extended events. FREE ACCESS
  • 4m 30s
    After watching this video, you will be able to describe extended events tasks. FREE ACCESS
  • Locked
    3.  Packages, Targets, Actions, and Sessions
    5m 22s
    In this video, find out how to differentiate between extended events, packages, targets, and sessions. FREE ACCESS
  • Locked
    4.  Extended Events Targets
    3m 28s
    Find out how to distinguish between extended events targets. FREE ACCESS
  • Locked
    5.  SQL Trace Architecture
    5m 33s
    After completing this video, you will be able to describe the SQL trace architecture. FREE ACCESS
  • Locked
    6.  Create a Trace
    11m 4s
    Learn how to create a trace using transact-sql. FREE ACCESS
  • Locked
    7.  Optimize SQL Trace
    3m 41s
    Learn how to optimize SQL trace to minimize performance issues. FREE ACCESS
  • Locked
    8.  Schedule Traces
    6m 50s
    In this video, you will learn how to schedule tracing in SQL Server. 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 Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance
Course Microsoft Azure Administrator: Monitoring
Course Database Instance Performance

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Integrity & Constraints
Course Analyzing Query Plans
Course Database Instance Performance