Optimization & Troubleshooting

SQL Server 2014    |    Expert
  • 7 Videos | 37m 20s
  • Includes Assessment
  • Earns a Badge
Likes 14 Likes 14
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

  • Playable
    1. 
    Implementing Plan Guides in SQL Server 2014
    6m 10s
    UP NEXT
  • Playable
    2. 
    Optimizing Queries in SQL Server 2014
    4m 27s
  • Locked
    3. 
    Troubleshooting SQL Server 2014 Database Size Issues
    4m 7s
  • Locked
    4. 
    Implementing Resource Governor in SQL Server 2014
    7m 48s
  • Locked
    5. 
    Using Extended Events in SQL Server 2014
    4m 11s
  • Locked
    6. 
    Using Activity Monitor in SQL Server 2014
    3m 15s
  • Locked
    7. 
    Integrating Data with SQL Traces in SQL Server 2014
    4m 21s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 498 Likes 498  
COURSE SQL Developer
Likes 152 Likes 152  
Likes 17 Likes 17