- Kevin Feasel
- Tracy Boggiano
- Mike Chrestensen
Notes: Questions and Topics
Storing DMVs and Admin Data in Tables
The main topic for tonight started with a blog post Tracy wrote to store BlitzIndex results to a table. We expanded this to discuss a variety of other topics, like what else we might store in tables: wait stats, sp_whoisactive results, and other things which are transient. We also talked about cleanup strategies, the folly of not having a cleanup strategy, and long-term data retention. There was a bit of meandering and ranting here, as you’d expect.