This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

CONSPT_1 Table Size

Hi,

Our DPA database running on SQL Express has reached it's 10GB limit.  If I query table sizes the CONSPT_1 table comes out top at 6GB and 1.5 million rows followed by the CONST_1 table on 1.5GB and the CONSS_1 table on 800MB.

The CONSPT_1 table appears to contain query plans.  Is there a way for us to reduce the amount of data held in this table and does it's large size indicate an issue with our monitored database?

Many thanks,

Nick