It is currently 19 Oct 2018 3:16


Post new topic  Reply to topic  [ 11 posts ] 
Author Message
PostPosted: 31 Oct 2012 9:41 
Offline
Nouveau
Nouveau
User avatar

Joined: 22 Sep 2006 12:00
Posts: 6
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


Top
   
 Post subject:
PostPosted: 04 Nov 2012 4:47 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 807
Location: Varese - Italy
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.


Last edited by mauriziog on 08 Nov 2012 2:29, edited 1 time in total.

Top
   
 Post subject:
PostPosted: 08 Nov 2012 12:31 
Offline
Nouveau
Nouveau
User avatar

Joined: 24 Aug 2009 12:00
Posts: 10
Keep Linux and use Postgres instead of Oracle. We run a huge CTM shop and have not had a single failure on Postgres. It's free light, robust and manages itself.


Top
   
 Post subject:
PostPosted: 10 Nov 2012 1:47 
Offline
Nouveau
Nouveau
User avatar

Joined: 07 Jul 2008 12:00
Posts: 23
Hosting critical software (Control-M) on a Windows server ... does that sound to you like a good idea to you honestly ? Good luck with that !


Top
   
 Post subject:
PostPosted: 10 Nov 2012 11:56 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 807
Location: Varese - Italy
On windows server? Yes no problems !
Good performances too with ms sql server.

Regards


Top
   
 Post subject:
PostPosted: 10 Nov 2012 6:20 
Offline
Nouveau
Nouveau
User avatar

Joined: 07 Jul 2008 12:00
Posts: 23
@mauriziog: just out of curiosity:

- what's your SLA ?
- how many times per year do you reboot your server ?
- how many times per month do you restart your Control-M/Server ?

Cheers


Top
   
 Post subject:
PostPosted: 10 Nov 2012 7:07 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 807
Location: Varese - Italy
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


Top
   
 Post subject:
PostPosted: 11 Nov 2012 7:54 
Offline
Nouveau
Nouveau
User avatar

Joined: 07 Jul 2008 12:00
Posts: 23
By 'your SLA' I meant your client/company SLA :)

Anyways thanks for feeding my curiosity. Care to share your NDP time for the 60k Control-M/Server (and the quantity of ordrered jobs ordered by SYSTEM) ?

Cheers


Top
   
 Post subject:
PostPosted: 11 Nov 2012 8:09 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 807
Location: Varese - Italy
- NPD time at 00:00
- all jobs in SYSTEM (for production with 60.000)

In others NDP at 08:45 a.m, 08:00 a.m., 00:00, 13:00 p.m. and 50-70 % jobs in SYSTEM.


Top
   
 Post subject:
PostPosted: 12 Nov 2012 1:13 
Offline
Nouveau
Nouveau
User avatar

Joined: 07 Jul 2008 12:00
Posts: 23
@mauriziog: by NDP time, I was meaning how long did your NDP took to complete :p


Top
   
 Post subject:
PostPosted: 13 Nov 2012 12:13 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 807
Location: Varese - Italy
For 60000 about 10 minutes (from 5 to 9) (but if "user daily" will be used...); for other in less than 1, max 2 minutes.
Regards


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 11 posts ] 

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved