{"id":8450,"date":"2017-07-12T00:00:44","date_gmt":"2017-07-12T00:00:44","guid":{"rendered":"http:\/\/craftydba.com\/?p=8450"},"modified":"2017-10-17T14:02:03","modified_gmt":"2017-10-17T14:02:03","slug":"rhode-island-ssug-july-2017","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=8450","title":{"rendered":"Rhode Island \u2013 SSUG \u2013 July 2017"},"content":{"rendered":"<p>I am driving thru <a href = \"http:\/\/www.offices.net\/city-slogans.htm#P\">America\u2019s Renaissance City<\/a>, Providence Rhode Island, to present to the RI SQL Server User Group on July 12, 2017.  Check out the <a href=\"https:\/\/www.meetup.com\/Rhode-Island-SQL-Server-Users-Group\/events\/241088722\/\">meetup <\/a>for more details.<\/p>\n<p>I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn.<\/p>\n<p><span style=\"color: #008000\">Topic:<\/span><\/p>\n<p>Investigating Plans with the Query Store<\/p>\n<p><span style=\"color: #008000\">Abstract:<\/span><\/p>\n<p>In the past, you had to execute custom scripts to gather information from either dynamic management views or extended events to tune badly behaving queries.  One major enhance made in SQL Server 2016 was the addition of the query store. \u00a0With a simple ALTER DATABASE statement, the database engine captures this data in memory and asynchronously writes this information to the database. \u00a0This means that a simple reboot of your server does not cause you to lose all those valuable statistics.<\/p>\n<p>SQL Server Management Studio has been enhanced with screens and reports to identify this bad queries. \u00a0Once you know the problem, you can start work on fixing it.  Last but not least, the live query statistics feature introduced in SQL Server 2016 allows you to see how a long running query executes.<\/p>\n<p>In short, the query store is one tool that a database administrator can\u2019t live without.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2017\/07\/presentation-investigating-plans-w-query-store.zip\">presentation bundle<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I am driving thru America\u2019s Renaissance City, Providence Rhode Island, to present to the RI SQL Server User Group on July 12, 2017. Check out the meetup for more details. I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn. Topic: Investigating Plans with the Query Store Abstract: In the past, you had to execute custom scripts to gather information from either dynamic management views or extended events to tune badly behaving queries. One major&hellip;<\/p>\n","protected":false},"author":1,"featured_media":7269,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[1111],"class_list":["post-8450","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pres","tag-sql-server--john-f-miner-iii--pass--presentation--rhode-island--user-group--query-store"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8450"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/8450\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/media\/7269"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}