Optimization & Troubleshooting
SQL Server 2014
| Expert
- 7 videos | 34m 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
-
6m 10sIn this video, you will learn how to create a plan guide. FREE ACCESS
-
4m 27sDuring this video, you will learn how to optimize queries for better performance. FREE ACCESS
-
3. Troubleshooting SQL Server 2014 Database Size Issues4m 7sIn this video, learn how to manage contention and auto growth in a database. FREE ACCESS
-
4. Implementing Resource Governor in SQL Server 20147m 48sIn this video, you will learn how to use Resource Governor to manage resources in a database. FREE ACCESS
-
5. Using Extended Events in SQL Server 20144m 11sIn this video, you will review Extended Event logs and optimize Extended Event session settings. FREE ACCESS
-
6. Using Activity Monitor in SQL Server 20143m 15sIn this video, you will learn how to use Activity Monitor. FREE ACCESS
-
7. Integrating Data with SQL Traces in SQL Server 20144m 21sIn this video, you will learn how to integrate performance monitor data with SQL Server traces. 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.
