Next Meeting: Mon, Apr 13 2015
April 2015 Meeting
Event Type: In-Person
Online Meeting URL: None
Monthly meeting. Further details TBA
UTC : Mon, Apr 13 2015 17:30 - 19:30
Event Time : Mon, Apr 13 2015 17:30 - 19:30 UTC
Your Local Time: Mon, Apr 13 2015 17:30 - 19:30
15 Cornell Rd
Albany, New York
Gathering and storing index usage information
Ken Schwartz, DBA CommerceHub
An important function in the role of DBA is one of Index Maintenance. This includes not only evaluating what indexes we should have, but also what indexes we do have, but don't really need. Since database usage patterns change over time, indexes that were needed once might not be needed now.
In order to evaluate index usage, we need to have some way of gathering and storing index usage information over time. Unfortunately, many of the standard solutions are falling short. Why? You better come to the presentation and find out.
Ken is a senior DBA at CommerceHub. He has worked at DavisVision and a number of other SQL oriented businesses in the Capital District. He always has something interesting to say