Optimization & Troubleshooting

SQL Server 2014
  • 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
    FREE ACCESS
  • Locked
    4. 
    Implementing Resource Governor in SQL Server 2014
    7m 48s
    FREE ACCESS
  • Locked
    5. 
    Using Extended Events in SQL Server 2014
    4m 11s
    FREE ACCESS
  • Locked
    6. 
    Using Activity Monitor in SQL Server 2014
    3m 15s
    FREE ACCESS
  • Locked
    7. 
    Integrating Data with SQL Traces in SQL Server 2014
    4m 21s
    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 Advanced SQL Queries
Likes 209 Likes 209  
COURSE Creating Tabular Data Models
Likes 13 Likes 13  
COURSE Index Design Guidelines
Likes 16 Likes 16  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Designing & Implementing Dimensions
Likes 15 Likes 15  
COURSE Advanced SQL Queries
Likes 209 Likes 209  
COURSE T-SQL Queries
Likes 112 Likes 112