Welcome to Edmonton PASS!


Thursday May 18, 2017 EDMPASS - 

Missing Parts of SQL2016 Monitoring & AGM 

Language: English

Event Type: In-Person

Online Meeting URL: None


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?

Chris Wood

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 
Edmonton, Alberta
Direction: None