SQL Server 2008 clustering with CLM 2012
Currently SQL Server 2008 clustering is not officially supported for CLM2012.
In situation in which clients must have the production DB running on a SQL Server 2008 in Cluster Environment for disaster recovery, I would expect to receive some best practices or recommendations settings to ensure that they can run CLM2012 without any risks of DB corruption or performance degradation.
Can you give me recommendations when running on that configuration ?
Thx and Best regards,
Armand
In situation in which clients must have the production DB running on a SQL Server 2008 in Cluster Environment for disaster recovery, I would expect to receive some best practices or recommendations settings to ensure that they can run CLM2012 without any risks of DB corruption or performance degradation.
Can you give me recommendations when running on that configuration ?
Thx and Best regards,
Armand
One answer
Because SQL Server 2008 is not supported in a CLM Clustered environment, we do not have any recommendations on settings to prevent performance degradation or DB corruption.
In a cold/idle standby configuration (which is supported for disaster recovery with SQL Server 2008) you should ensure that RTC only connects to one DB at a time, and that the data is replicated between the primary and secondary DBs.
Here is some documentation on Maximizing Performance when using Cold/Idle Standby
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Ft_max_perf.html
In a cold/idle standby configuration (which is supported for disaster recovery with SQL Server 2008) you should ensure that RTC only connects to one DB at a time, and that the data is replicated between the primary and secondary DBs.
Here is some documentation on Maximizing Performance when using Cold/Idle Standby
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Ft_max_perf.html