tetox Posted January 11, 2018 Share #1 Posted January 11, 2018 Course: SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database. Level: Intermediate Updated: January 9, 2018 Duration: 1h 27m Type: Retail ISO Size: 253 MB (9518D91A) Released By: keiso Held By: Erin Stellato Size RAR File: 211 MB Home Page: Hidden Content Give reaction to this post to see the hidden content. There's a whole new world of automated features in SQL Server, based on data, that are designed to make life easier for the data professional, and it's time to start using them! Microsoft has invested a lot of effort in these tools that can automate areas of performance tuning and give you time to work on more interesting and creative tasks that can't be automated. In this course, SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database, you'll learn how Query Store has been upgraded to also collect wait statistics from queries, to allow you to identify performance bottlenecks at the query level and dig deeper to resolve them. Next, you'll explore Automatic Plan Forcing, which allows SQL Server to identify queries where performance has regressed and automatically force a prior query plan that is more efficient. Finally, you'll take a dive into Automatic Index Management, which gives SQL Server the capability to automatically create missing indexes and remove unused or duplicate indexes. By the end of this course, you'll have the skills and knowledge to start enabling these features in appropriate parts of your SQL Server environment and taking back some of your precious time! The modules are: Course Overview Introduction Finding and Using Wait Statistics in Query Store Using Automatic Plan Correction Using Automatic Index Management Exercise Files Download: Hidden Content Give reaction to this post to see the hidden content. Credits and thanks to kEISO Link to comment
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now