OME ships with the express edition of SQL and it is recommended to use Standard edition for larger installations to get better performance. SQL express is limited to use single CPU and 1GB memory which may cause performance issues when you have larger number of servers.
Having said this, if you are going with express edition, you can make sure you follow the hardware recommendations from the user guide/online help in OME. You can also reduce the discovery/inventory speed in OME by moving the slider to the left(Located under Manage->Discovery and Inventory and clicking the Discovery and Inventory Schedule links from the left.)
Is it possible to upgrade SQL express to full version without messing up the OME install? In otherwords, if we started with SQL Express and eventually found that the performance wasn't quite good enough, could upgrade to SQL enterprise? Thanks!
Take a look at this thread. It lists the process of DB migration for OME. you can start with SQL express and migrate the DB later to non express SQL version.
DELL-Abhijit P
Community Manager
•
711 Posts
0
March 29th, 2012 13:00
Hi,
Thanks for your post.
OME does not support Oracle.
OME ships with the express edition of SQL and it is recommended to use Standard edition for larger installations to get better performance. SQL express is limited to use single CPU and 1GB memory which may cause performance issues when you have larger number of servers.
Having said this, if you are going with express edition, you can make sure you follow the hardware recommendations from the user guide/online help in OME. You can also reduce the discovery/inventory speed in OME by moving the slider to the left(Located under Manage->Discovery and Inventory and clicking the Discovery and Inventory Schedule links from the left.)
Let us know how it goes.
Regards
Abhijit
Beaver6675
28 Posts
0
March 30th, 2012 06:00
Hi Abhijit,
Can I make an RFE for OME to support a Postgresql/Mysql connector in future?
DELL-Abhijit P
Community Manager
•
711 Posts
0
March 30th, 2012 08:00
Definitely. We'll get the requirement across to marketing to be considered for future releases.
missmaine
1 Rookie
•
18 Posts
0
April 22nd, 2012 18:00
Is it possible to upgrade SQL express to full version without messing up the OME install? In otherwords, if we started with SQL Express and eventually found that the performance wasn't quite good enough, could upgrade to SQL enterprise? Thanks!
DELL-Abhijit P
Community Manager
•
711 Posts
0
April 23rd, 2012 07:00
Hi,
Take a look at this thread. It lists the process of DB migration for OME.
you can start with SQL express and migrate the DB later to non express SQL version.
http://en.community.dell.com/techcenter/systems-management/f/4494/p/19440364/20070699.aspx#20070699
Regards
Abhijit