Linux/Oracle versus Windows/MSSQL
Linux/Oracle versus Windows/MSSQL
Hi
Currently our Linux EM/CMS 6.4 fp7 servers connect to Oracle db.
Our management is looking at a Control-M solution with MSSQL.
We are currently talking about jobs on the AJF (20000 -30000 per day), about
job executions (150 - 250K per day), about concurrent Agents (150).
Is a Windows/MSSQL solution able to cope ?
Are there reasons why we should not convert ?
or why we definitely should convert ?
Will the conversion process be an easy one or not ?
rgds
Ruud
Currently our Linux EM/CMS 6.4 fp7 servers connect to Oracle db.
Our management is looking at a Control-M solution with MSSQL.
We are currently talking about jobs on the AJF (20000 -30000 per day), about
job executions (150 - 250K per day), about concurrent Agents (150).
Is a Windows/MSSQL solution able to cope ?
Are there reasons why we should not convert ?
or why we definitely should convert ?
Will the conversion process be an easy one or not ?
rgds
Ruud
MSSQL can work well in your production.
Consider to migrate to the new controlM version and consider that there is also an embedded DB: postgres.
Consider to migrate to the new controlM version and consider that there is also an embedded DB: postgres.
Last edited by mauriziog on 08 Nov 2012 2:29, edited 1 time in total.
- pmdeshayes
- Nouveau
- Posts: 23
- Joined: 07 Jul 2008 12:00
- pmdeshayes
- Nouveau
- Posts: 23
- Joined: 07 Jul 2008 12:00
My SLA ?
Controlm must be operational ever.
- never reboot windows server, only for programmed maintenence. For example ControlM fix packs installations, and at the same time are programmed the windows updates (if necessary).
- related to the above point, are about one time each 6 month; even more.
I speak for five productions that use Ms Windows SO for about 2.000 jobs, 5.000 jobs, 8.000 jobs, 6.000 and 60.000 jobs; all with only one controlM server.
Regards
Controlm must be operational ever.
- never reboot windows server, only for programmed maintenence. For example ControlM fix packs installations, and at the same time are programmed the windows updates (if necessary).
- related to the above point, are about one time each 6 month; even more.
I speak for five productions that use Ms Windows SO for about 2.000 jobs, 5.000 jobs, 8.000 jobs, 6.000 and 60.000 jobs; all with only one controlM server.
Regards
- pmdeshayes
- Nouveau
- Posts: 23
- Joined: 07 Jul 2008 12:00
- pmdeshayes
- Nouveau
- Posts: 23
- Joined: 07 Jul 2008 12:00