Hi

We have been advised to migrate all our System Center SQL DB's (mainly ConfigMgr, OpsMgr, ServiceMgr and Scorch) which are currently running on mostly 4 nodes SQL clusters (with different other business services and impacting the System Center Performance as Memory and CPU constantly hitting above 90%) to standalone SQL environment.

OS - Windows Server 2008 R2 / Windows Server 2012

SQL - SQL Server 2008 R2 / SQL Server 2012

Can someone advice steps or strategy to execute this?

regards

Guru

You can move the SCOM databases in stand alone server. The application can change the server name with following steps.

Build the OS

Install SQL server & SP

take a down time

Move the databases and connect the SCOM.

Or you may add a node in your existing cluster and run the SCOM instance on that node. But it by difficult from  OS cluster point of view.

Thanks

>>>with different other business services and impacting the System Center Performance as Memory and CPU >>>>constantly hitting above 90%) 

Is that possible to optimize it? What is DR plan for stand alone server?

---This first thing to check if CPU is at 100% is to look for parallel queries:


-- Tasks running in parallel (filtering out MARS requests below):
select * from sys.dm_os_tasks as t
 where t.session_id in (
   select t1.session_id
    from sys.dm_os_tasks as t1
   group by t1.session_id
  having count(*) > 1
  and min(t1.request_id) = max(t1.request_id));

-- Requests running in parallel:
 select *
   from sys.dm_exec_requests as r
   join (
           select t1.session_id, min(t1.request_id)
          from sys.dm_os_tasks as t1
         group by t1.session_id
        having count(*) > 1
           and min(t1.request_id) = max(t1.request_id)
      ) as t(session_id, request_id)
     on r.session_id = t.session_id
    and r.request_id = t.request_id;