Another exquisit release
Pluralsight.Solving.Real.World.Problems.with.SQL.Server.2016.Query.Store-XQZT
Title: Solving Real World Problems with SQL Server 2016 Query Store
Publisher: Pluralsight
Iso Size: 306M (319600640 B)
Files: 8F
Date: 07/22/2017
Course #: Pluralsight
Type: data-professional
Published: Fri Jul 21, 2017
Modified: July 21, 2017
URL: www.pluralsight.com/courses/solving-real-world-problems-sql-server-2016-query-store
Author: Gail Shaw
Duration: 2h 1m
Skill: Intermediate
Exercise: [ ]
Installation:
Unpack that shit, mount that shit, run that shit
Notes:
Poor database performance is a widespread problem, and as data
volumes increase it's only going to get worse. Up until now,
identifying the poorly performing queries was challenging and
difficult. SQL Server 2016 introduced the Query Store, which
automatically tracks query performance. In this course, Solving
Real World Problems with SQL Server 2016 Query Store,
you'll learn how to solve difficult query performance
problems in an easier, more efficient way. This course will show
how to identify query performance regressions using the Query
Store, how to identify queries using the most resources, and how to
track the overall resource consumption at the database level.
It'll also show some advanced uses of Query Store, such as
upgrade tests and load tests. By the end this course, you’ll be
able to use Query Store to identify and resolve what were
previously very difficult performance problems.