Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

DPA Repo ERD

Where can I find documentation on how the repo tables are populated. Specifically I am looking to understand consw and conss. Tks.

Find more posts tagged with

ERD

Accepted answers

All comments

mandevil

If you open a support case, they should be able to share the repo ERD with you as well as a brief description for CONSW and CONSS. CONSW especially can be a bit cryptic.

vrkvvj

This is what i have with me. Hope this helps

Please find below table details/information.

CONSW : It is the master table for referring sqlhash and planhashes and other stats. It stores only 30 days of data
CONSPT : it stores the plan details of queries for SQL Server
CONSS : stores the statistics of queries
CONST stores sql text of all the normalized queries
CONST-EXAMPLE : Stores one example each of the normalized queries