Thursday May 18, 2017 EDMPASS -
Missing Parts of SQL2016 Monitoring & AGM
Event Type: In-Person
Online Meeting URL: Nonehttps://www.eventbrite.ca/e/thurs-may-18-2017-edmpass-missing-parts-of-sql2016-monitoring-ann-gen-mtg-tickets-34042015585
5:00 pm Doors open
5:30 pm Feature Presentation & Pizza
Monitoring SQL 2016 on-premise for performance and stability by Chris wood
You have an on-premise instance of SQL 2016 but what-if performance sucks every now and again Have you looked in the plan cache? What to look for in saved plans Keep you plan cache trim Are your indexes being used as you expect? Do you have table/index hot-spots?
Independent Consultant, CHI-WOOD (DP) Services
Chris has been an SQL DBA since 1997 using 6.5. Worked with 7/2000/2005/2008R2/2012 and 2014. Attended 12 Pass Summits and 2 SQLCruises. Communications Director of EDMPASS since its inception in 2008. Has migrated systems while attempting to take advantage of new features from 7.0 all the way to 2014 and 2016. Has implemented lots of best practices from SQL Server MVPs.
6:30 pm Annual General Meeting
With the success of our second SQL Saturday EDMPASS is growing and it is time to take it to a slightly more formal level. We will be electing a committee to form a non profit society to be EDMPASS.
Added bonus: Scott Stauffer from Vancouver will present on Shape Files
10303 Jasper Avenue
Canadian Western Bank Place - Canadian Room