Co-hosting SCM 2012 databases?
Hi all,
This is a general question across most (scom, sccm, vmm and scsm) of the SC 0212 products.
Basically, is it supported to install these products databases on seperate SQL instances on the same SQL server (cluster)?
I had done a design excericse for each product, but customer has a large SQL cluster on which they would like to create distinct SQL Instances for each products database. However I cant find much info on supportability \ install issues when trying
to do this for the above products.
Any experience \ thoughts much appreciated!
Kind Regards
Andrew
September 6th, 2012 5:35am
Hi Andrew
No real problems with support - just performance - There is some guidance here around collations \ versions \ IO:
http://www.systemcentercentral.com/tabid/143/indexid/93572/default.aspx
http://nocentdocent.wordpress.com/articles-and-series/planning-sql-server-for-system-center-2012/
A lot depends on the underlying hardware - cpu, memory and especially Disk IO - and high availability \ DR requirements.
SQL Reporting Services is not cluster aware and you each of SCOM and SCSM should have their own SQL Reporting Services instance. Technically neither actually requires its own SQL Reporting Services instance but when you do install SCOM reporting,
you install a custom security model which overwrites existing security setting on any existing reports. The screenshot below shows the warning.
http://www.systemcentersolutions.co.uk/images/easyblog_images/42/scom/CTP2/Install/SQRS9.png
Best practice is therefore to definitely put SCOM and SCSM on their own and separate instances.
Cheers
GrahamRegards Graham New System Center 2012 Blog! -
http://www.systemcentersolutions.co.uk
View OpsMgr tips and tricks at
http://systemcentersolutions.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
September 6th, 2012 5:59am