• 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 /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Chris S. · May 28, 2014 at 03:56 AM ·

PostgreSQL for Performance Warehouse in Prod

Greetings,

Does anyone utilize the postgresql DB structure for the Performance Warehouse in a Production environment? I have a client that is using this with only 2 applications currently being monitored. One is an internal app, and the other external with a 50k member base generating about 4mill PP a day. 50 GB has been set for the size of the storage and that is maxing out and causing the db to run out of memory about 2GB memory (not sure exactly as I don't have rights to machine).

At this client they do not have any experts in postgreSQL and are looking for advice as to how to tune it for dT. Anyone have any thoughts?

Chris

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

Answer by Ramon F. · May 28, 2014 at 07:14 AM

Yeah.

My situation:

---

I have 24 Java agents, 6 .NET and 1 Webserver/PHP in this moment. My Postgresql machine is a virtual machine with 4 vCPU and 3GB RAM.

My storage management is high resolution 3 weeks, medium 4 and low 5.

The average Measures Written is 8500 / minute.
---


Works fine here, something about 40 ~ 50 gb in hard disk.

Look the Storage Management configuration, the time that you store the information and if you do not create a lot of sensors and measures that are unnecessary , I already  had problems with this making my DW stop working fine because of the load.

 

Hope that helps, if not, you can ask.

 

Comment

People who like this

0 Show 1 · 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 Chris S. · May 29, 2014 at 02:28 AM 0
Share

This does help and I appreciate the feedback.

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

1 Person is following this question.

avatar image

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • 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