• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 25 subscribers
  • Views 284 views
  • Users 0 members are here
Options
Related
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.

Why are all tables stored in the PRIMARY filegroup?

FormerMember
FormerMember

While troubleshooting performance issues related to the DPA application, I noticed that all tables are stored in 1 file within the PRIMARY filegroup. I see that tables are created on-the-fly for the corresponding days of the month. Is there a way to configure the application to spread out the IO? (Besides creating another filegroup and setting that to the default FG. I don't want all tables in 1 FG.)

BTW, the performance issues we're seeing is happening every 10 minutes. I'm assuming this is when DPA aggregates the data to show in the previous 10-min time slice.

  • 0

    How is your storage configured/architected?  Are you hitting storage on a SAN?  Local disk?

    As far as the objects spinning up every month, you may be referring to our monitored instances tables.  We create a new set of tables for every monitored instance.  That's what the _id represents and helps us map back to the COND table.  I'm not aware of objects being created monthly, but if you give me an example, I can certainly look into it.

    Every 10 minutes we do a couple of things:  We do our stats poll that can potentially pull back a lot of data that needs to be persisted to the repo.  We also do metric summarization which results in reads/writes.  If you are seeing performance issues, I'd make sure you are spec'd correctly for the number of instances you are monitoring.  For more specific information or analysis, I'd recommend opening an ticket with their tech support folks from your customer portal as this could get involved.  8 )

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,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 Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.