Re: Preferred Database for BSM 9.20 Implementation (518 Views)
Reply
Collector
djarvey
Posts: 2
Registered: ‎03-09-2010
Message 1 of 3 (531 Views)

Preferred Database for BSM 9.20 Implementation

A somewhat hypothetical question, and one I used to be sure I knew the answer too, excepting recent developments from Microsoft concerning SQL server. Here goes...

 

If you were implementing a new BSM 9.20 environment what database would you use? Assume you have APM with EUM data from RUM and BPM, SiteScope, and NNMi for infrastructure data collection; and a future need for Diagnostics, OO integration, and uCMDB integration as well.

 

There will be 12,000 - 15,000 managed nodes (network + server) and 200 business applications. Current baseline with 1 year of data shows about 500Gb of space used and you can expect that to double or triple potentially as applications and nodes are added. There will be 80 - 100 concurrent users at peak capacity running reports, monitoring dashboards, etc...

 

Please tell me if you would use Oracle 11g Enterprise (RAC is available) or SQL Server 2008 Enterprise, and the reason(s) why. 

HP Expert
Asaf Shechter
Posts: 1,333
Registered: ‎12-09-2008
Message 2 of 3 (521 Views)

Re: Preferred Database for BSM 9.20 Implementation

both are supported and recommended.

i suggest you go with the DB you feel more comfortable.

Collector
djarvey
Posts: 2
Registered: ‎03-09-2010
Message 3 of 3 (518 Views)

Re: Preferred Database for BSM 9.20 Implementation

Thanks Asaf. I am somewhat more comfortable with Oracle, however cost differences abound as you are probably aware. I've used both in the past, but have less experience with the newer versions of MS SQL to be able to authoritatively say if there are still significant performance and tuning flexibility advantages to Oracle given any improvements MS may have introduced. Any ideas or recommendations are welcome.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.