Extended Events & SQL Trace

SQL Server 2016    |    Intermediate
  • 8 Videos | 46m 7s
  • Includes Assessment
  • Earns a Badge
Likes 40 Likes 40
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

  • Playable
    1. 
    SQL Server Extended Events
    5m 39s
    UP NEXT
  • Playable
    2. 
    Extended Events Tasks
    4m 30s
  • Locked
    3. 
    Packages, Targets, Actions, and Sessions
    5m 22s
    FREE ACCESS
  • Locked
    4. 
    Extended Events Targets
    3m 28s
    FREE ACCESS
  • Locked
    5. 
    SQL Trace Architecture
    5m 33s
    FREE ACCESS
  • Locked
    6. 
    Create a Trace
    11m 4s
    FREE ACCESS
  • Locked
    7. 
    Optimize SQL Trace
    3m 41s
    FREE ACCESS
  • Locked
    8. 
    Schedule Traces
    6m 50s
    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 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

COURSE Configuring Operators & Alerts
Likes 8 Likes 8  
COURSE Data Types & Normalization
Likes 67 Likes 67  
COURSE T-SQL Queries
Likes 173 Likes 173  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Optimizing Statisitics & Indexes
Likes 26 Likes 26  
COURSE Azure SQL Database
Likes 78 Likes 78  
COURSE Analyzing Query Plans
Likes 21 Likes 21