• 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 Wei D. · Dec 09, 2014 at 07:54 AM ·

Custom DMI takes long time to load

Hi, All

I have an urgent capacity issue with one of my customers, the custom DMI(s) take long time to load, sometime even fail. the client has CAS and CAS DB installed on one machine,I inspected the memory usage and found that CAS DB will use up all the memory assigned to it (32GB), but CAS only uses 10 to 15 GB (max memory configured is 32GB). the machine info is as below:

    • OS: Windows Server 2012 x64
    • Memory: 64GB
    • DB: SQLServer 2012 Standar Edition x64
    • CAS: 12.2.1

I also notice that in the system status:

    • CAS DB size: 248G ( data 168G + index 80G)
    • Session: 1.1m
    • Clients in cache:35177
    • Server in cache:127
    • Site in cache: 11
    • Memory Info: Total system memory... 65490 MB
    • Memory Info: Total memory...10173 MB
    • Memory Info: Free memory...80%

I am struggled with  the following questions, please help me based on your experience that:

    • why the CAS doesn't use up all the remaining memory, as the system still has 20% percent of memory not being used?
    • Will separate the CAS from the CAS DB solve the capacity issue, what is the best practice to install CAS and CAS DB?

Any comment is highly appreciated!

Thanks a lot!

Wei

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.

5 Replies

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

Answer by Wei D. · Dec 17, 2014 at 09:15 AM

Hi All,

One of the solution is to split the data analysis load into two CAS, which are connected to the same AMD, did anyone have field experience on how to implement such deployment, is it feasible from technical aspect?

Any comment is highly appreciated!

 Thanks a lot!

 Wei

 

Comment

People who like this

0 Show 0 · 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

Answer by Wei D. · Dec 11, 2014 at 09:24 PM

Hi All,

I did realize that the huge amount data kept in database might cause the performance issue for DMI, so I changed setting to only keep 2 days of detailed data, and I found some raw data tables are very large as show below. can CAS handle that amount of data for a single table?

and I've create a ticket to track the issue.

https://support.compuwareapm.com/supportportal/browse/SUPDCRUM-2793

 

Comment

People who like this

0 Show 0 · 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

Answer by Sebastian K. · Dec 10, 2014 at 12:16 PM

You can also set user property DMI_SQL_DEBUG to true (you might need to create it if it does not exit). This will give you access to SQL debug menu. 

The example above shows that the report/section was actually run from the data view cache. If possible, you should create reports that DO NOT go directly to the SQL database but rather use the data view caching mechanism. For many combinations of columns for last monitoring interval and today time ranges, reporting data is available in memory cache in addition to SQL database. This significantly improve performance of DMI reports. 

To answer next question: what are the combinations of columns that are in the cache? You should start with OOB reports, as the caching mechanism, is especially designed to make OOB reports run faster. Use one of those reports as the starting point towards building your own. 

 

Comment

People who like this

0 Show 0 · 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

Answer by Cosmin G. · Dec 10, 2014 at 12:04 AM

I ran into the same issue and a couple suggestions are to pre-load and make efficient reports.

Defining Efficient DMI Reports

Also check how much memory you have dedicated to your JVM. 

Set Memory CAS and ADS

 

 

Comment

People who like this

0 Show 0 · 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

Answer by Ulf T. · Dec 09, 2014 at 10:44 PM

Is it physical or virtual?

How many CPUs?

What does the LOG say when the report fails?

Comment

People who like this

0 Show 0 · 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.

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

4 People are following this question.

avatar image avatar image avatar image avatar image

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