Pros and Cons of setting up a batch processing server?
Posted on 2016-09-21
We are converting our in-house client/server applications to be web applications using Visual Studio 2012, ASP.net, SQL Server 2014. We are starting to create some batch jobs that we would like to run without user interaction and one of my team members suggested setting up a batch processing server to handle these processes. Since this is all new to me, I was wondering if anyone could provide feedback on: the pros and cons of using a batch processing server,
is it really needed,
without it can large data files (over a gig of data) be processed without timing out if there isn't a separate server?
We are a small state agency and most of the batch processes that will be needed are annual processes with a few daily and weekly processes thrown in.
Any information you can provide is greatly appreciated.
Thank You, Ang