• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home
  • Public Forums
  • Network Application Monitoring
  • NAM Open Q&A
avatar image
Question by Kalle L. · Aug 11, 2017 at 03:06 PM · esm

CAS DB vs. SyntheticMonitoring DB & selective data purge

Hi,

I was looking into the selective data purge functionality (i.e. removing "false positive" / unwanted monitoring results), and noticed first of all that there are separate features for deleting CAS data (via DiagConsole) and the synthetic DB data (via the Synthetic Console). Deleting rows from the SyntheticMonitoring DB apparently has no impact when browsing the data via CAS. Seeing as CAS is the interface we use to browse the data, that is of course where we need to direct the data purge as well. Does it make sense to also delete from SyntheticMonitoring? If I only delete the rows from CAS, will it then later pick up the data from SyntheticMonitoring? I'm trying to understand the relationship between the two databases - if there's some documentation already about this, feel free to link me. The Agent Manager installation instructions do touch on the subject, but it's not quite clear to me yet overall.

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

1 Reply

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image
Best Answer

Answer by Carol O. · Aug 11, 2017 at 03:27 PM

Hi,Kalle. In general, as you know, your reporting data will be in the CAS database. So, you may at times need to purge data there.

You will also want to maintain the ESM database to a reasonable size. The best approach here (if your database is not too large currently) is to use the Agent Manager Database Tab to configure the database scheduled maintenance. If your ESM DB is currently too large, you may want to purge some data first using Agent Manager Content Pane Commands and then configure the scheduled maintenance. I hope this helps. Thanks!

Comment

People who like this

0 Show 6 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Kalle L. · Aug 12, 2017 at 10:00 AM 0
Share

Hi Carol,

Thanks for the response, though my question wasn't so much about database maintenance - I'm trying to understand when does CAS actually read data from the ESM database? And when only from it's own DB? The same kind of selective data purge functionality is there for both CAS and ESM databases, so when is it that I would want to also clean up the unwanted measurements from ESM? Might CAS at some point notice: "ok I have blank data for yesterday, but the ESM DB has all the data available - let me copy everything from there to my DB". So if I want to clean up a specific set of unwanted results, is it enough to do that for CAS, even though the data still remains at ESM DB?

avatar image Carol O. ♦ · Aug 12, 2017 at 01:34 PM 0
Share

Hi, Kalle. The CAS never reads data from the ESM database; the ESM database is used by the ESM Console.. ESM prepares transdata files for the CAS, and that data is stored in the CAS database.

Yes, when you want to clean up a specific set of unwanted results in the reports, you only need to purge data from the CAS database. Thanks!

avatar image Kalle L. · Aug 14, 2017 at 12:46 PM 0
Share

Hmm, I have to say I'm a bit surprised about this comment: "CAS never reads data from the ESM database; the ESM database is used by the ESM Console". Because for example in the below installation instructions, it says: "CAS stores data for a limited period of time. For that reason, you may choose to install the Enterprise Synthetic database for historical and trend analysis reporting"

https://community.dynatrace.com/community/display/ENTSYM125/Install+Agent+Manager+and+create+database

Also, the fact that the Agent Manager's purge functionality allows me to wipe a specific set of data for an app/transaction/agent/etc. suggests that the data is indeed purged for reporting purposes. Your comment however suggests that the ESM database is there only for general management and administration, and everything related to reporting is only at CAS. So, what am I missing here?

avatar image Carol O. ♦ · Aug 14, 2017 at 01:11 PM 1
Share

Hi, Kalle. Thanks for pointing out this in the documentation. We will correct the doc.

We understand that the evolution to the use of the CAS as our reporting engine may cause confusion and may not have been completely reflected in the documentation. In 12.5:

  • the only reporting engine for ESM is the CAS
  • the CAS uses data from the CAS database and now retains ESM data for longer periods of time than in the past.
  • some customers have their own uses of historical data in the ESM database
  • the ESM Console uses the ESM database for configuration and for limited reporting for diagnostic purposes
  • the purge data for the ESM database existed to remove old data (in prep for scheduled maintenance) and unwanted data for the reporting engine that was used in the past prior to the CAS. ESM purge data remains in the product for maintenance only and alternative customer reporting uses, not for CAS reporting.

When you want to clean up a specific set of unwanted results in the CAS reports, you only need to purge data from the CAS database. Thanks!

avatar image Kalle L. Carol O. ♦ · Aug 14, 2017 at 01:31 PM 0
Share

Thank you for the thorough answer! Got it now :) The documentation indeed threw me off there.

avatar image Carol O. ♦ · Aug 14, 2017 at 01:48 PM 0
Share

Great! I updated that doc and asked the team to look for more places we may have missed. Thanks for pointing this out and for all your patience and diligence!

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

17 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Is there an Architecture Diagram for Enterprise Synthetic?

TP Msg : The window does not have a menu

Multiple CAS connect to one Synthetic Agent Manager

Synthetic Infrastructure Health @ CAS

Enterprise Synthetics vs Advanced Synthetics

Forum Tags

esm siebel Dynatrace Managed license nam probe wan citrix dna rest api configuration mq alerting NAM 2018 dashboard dcrumadvisory reports css nam universal decode database mobileapp RUM ads sap nam console scripting nam server sequence transactions nam 2019 upgrade
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A