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
Top Related