• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 2 replies
  • Subscribers 26 subscribers
  • Views 276 views
  • Users 0 members are here
Options
Related

DPA Repo ERD

rjh18

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

Parents
  • 0

    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

Reply
  • 0

    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

Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 200,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab Link Accounts
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.