SQLSaturday Paris 2015
SQL 2016 Query StoreEt si mes queries m'taient contes...
SQLSaturday Paris 2015Merci nos sponsors
SQLSaturday Paris 2015
Merci nos volontaires
SQLSaturday Paris 2015Isabelle Van CampenhoudtIsabelle Van
CampenhoudtSQL Server MVP, BruxellesConsultant, speaker, trainer,
PASS V-Chapter Leader, GUSS Board memberManaging partner de
www.ShareQL.comSQL Server depuis 1999Blog:
http://thesqlgrrrl.wordpress.com/[email protected]@thesqlgrrrlIsabelle
Van Campenhoudt4
globalfrench.sqlpass.org
SQLSaturday Paris 2015Rendre sexy4
Agenda
SQLSaturday Paris 2015
Si mes queries mtaient contes
Ou pasDans le merveilleux monde de la performance
SQLSaturday Paris 2015
Tout doucement le matin.Lenteur de naissanceLenteur
soudaineLenteur lentement plus leeenteRow by agonizing row
SQLSaturday Paris 2015Frustrations
Qui ???Pourquoi ???
SQLSaturday Paris 2015
SQLSaturday Paris 2015
SQLSaturday Paris 2015Algebrization
SQLSaturday Paris 2015Confirms that all objects exist and are
visible in the security context of the user. This is where the
table and column names are checked to ensure that they exist and
that the user has access to them2. Determines the final type for
each node in the parse tree3. Determines where to do any
aggregations
11
Du parse larbre logiqueSELECT P.ProductNumber, P.ProductID,
total_qty = SUM(I.Quantity)FROM Production.Product P INNER JOIN
Production.ProductInventory AS I ON I.ProductID = P.ProductIDWHERE
P.ProductNumber LIKE N'T%'GROUP BY P.ProductID,
SQLSaturday Paris 2015
Production du plan dexecution
SQLSaturday Paris 2015Le Plan dxecution
SQLSaturday Paris 2015Optimisation cost based
SQLSaturday Paris 2015Bonnes pratiques oudroit
dinfluence.HintsPlan guideTraceFlag Forced Parameterization
SQLSaturday Paris 2015DEMOVisualiser les plans dexecution
SQLSaturday Paris 2015
17
Live ou Post Mortem
SQLSaturday Paris 2015Live query statistics
SQLSaturday Paris 2015DEMOVisualiser les plans dexecution en
temps rel
SQLSaturday Paris 2015
Le Candy Query Store
SQLSaturday Paris 2015Query Store
Qui ???Pourquoi ???
SQLSaturday Paris 2015Les Scenarios du Query storeQui
???Pourquoi ???
SQLSaturday Paris 2015
23
Les rayons du Store
SQLSaturday Paris 2015The query store contains two stores; a
plan store for persisting the execution plan information, and a
runtime stats store for persisting the execution statistics
information. The number of unique plans that can be stored for a
query in the plan store is limited by the max_plans_per_query
configuration option. To enhance performance, the information is
written to the two stores asynchronously. To minimize space usage,
the runtime execution statistics in the runtime stats store are
aggregated over a fixed time window. The information in these
stores is visible by querying the query store catalog views.
24
The plan store
SQLSaturday Paris 2015The statistics store
SQLSaturday Paris 2015
Configuration Options
SQLSaturday Paris 2015DEMOUtiliser le query store
SQLSaturday Paris 2015T-SQL management
SQLSaturday Paris 2015Q&A
SQLSaturday Paris 2015Pour aller plus loinOptimisateur de
requete (webcast GUSS)
https://www.youtube.com/watch?v=sMG7v9YvPX8
https://msdn.microsoft.com/en-us/library/dn817826.aspx
https://msdn.microsoft.com/en-us/library/dn818149.aspx
SQLSaturday Paris 2015
Et en plus on peut gagner des cadeauxhttp://GUSS.pro/sqlsat
SQLSaturday Paris 2015
