Optimization & Troubleshooting
SQL Server 2014
| Expert
- 7 Videos | 37m 20s
- Includes Assessment
- Earns a Badge
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
-
1.Implementing Plan Guides in SQL Server 20146m 10sUP NEXT
-
2.Optimizing Queries in SQL Server 20144m 27s
-
3.Troubleshooting SQL Server 2014 Database Size Issues4m 7s
-
4.Implementing Resource Governor in SQL Server 20147m 48s
-
5.Using Extended Events in SQL Server 20144m 11s
-
6.Using Activity Monitor in SQL Server 20143m 15s
-
7.Integrating Data with SQL Traces in SQL Server 20144m 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.
