Re: HP BSM - Why does it need Enterprise Version of SQL. (363 Views)
Reply
Respected Contributor
Ben.Shirley
Posts: 493
Registered: ‎09-01-2009
Message 1 of 6 (406 Views)

HP BSM - Why does it need Enterprise Version of SQL.

Firstly, I know why this is required (for the logical partitioning feature) but we have non BSM databases that are over 600GB in our organistation which use Standard version just fine.

 

We are under preasure to reduce our Enterprise Licenses doe to the massive cost difference, and it it causing us to seriously look at the long term viability of the HP BSM suite and seek alternatives.

 

If this feature could be disabled and allow us to install Standard Version of SQL that would help.

 

 

HP Expert
Javier_Mora
Posts: 95
Registered: ‎12-01-2011
Message 2 of 6 (364 Views)

Re: HP BSM - Why does it need Enterprise Version of SQL.

Hello,

 

The reason for BSM requirements on using Microsoft SQL enterprise edition is that this edition has Native partitioning which is required for BSM to handle profile database partitioning.

 

Oracle does use Native partitioning by default and for MS SQL, the Enterprise edition offers this feature.

 

Kind regards,

Javier

 

 

HP Expert
Asaf Shechter
Posts: 1,296
Registered: ‎12-09-2008
Message 3 of 6 (363 Views)

Re: HP BSM - Why does it need Enterprise Version of SQL.

partitioning cannot be disabled.
support non-enterprise version is on the roadmap.
Visitor
brittm3
Posts: 3
Registered: ‎09-24-2013
Message 4 of 6 (291 Views)

Re: HP BSM - Why does it need Enterprise Version of SQL.

Hi, Do we have any indication on when the non-enterprise sql version will be supported in BSM, I have a customer who sees this as a serious blocker to using the BSM solution over our competitors?

Regular Advisor
SuperCoolNothin
Posts: 102
Registered: ‎02-04-2014
Message 5 of 6 (278 Views)

Re: HP BSM - Why does it need Enterprise Version of SQL.

Is the roadmap available for HP Partners to view? It would really help to reassure the clients that these things are on the horizon.

Respected Contributor
SonDang
Posts: 179
Registered: ‎05-28-2014
Message 6 of 6 (266 Views)

Re: HP BSM - Why does it need Enterprise Version of SQL.

Hello SuperCN,

 

This below document might be useful to you for the example of using non-enterprise edition:

 

http://support.openview.hp.com/selfsolve/document/KM00434442

 

Contents below:

"

We require Enterprise editions of MSSQL or Oracle because BSM uses DB native partitioning. Microsoft and Oracle include this DB partitioning functionality in their Enterprise editions only.

BSM Partition and Purging Manager uses this functionality. If it is not available, the Partition and Purging Manager does not partition or purge data. Failure to partition or purge may result in major performance issues.

If your customer uses MSSQL/Oracle Standard edition and starts experiencing performance issues HP Support won't help them. Also there will be problems with upgrade to future versions of BSM.

We had received request like a customer where the BAC is implemented with SQL  standard edition. After the course of implementation after 1 year, the customer is facing problems with data partitioning and purging of profile database. And now need to migrate to enterprise edition.

"

 

I hope that helps.

“If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
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.