March 26, 2012 at 5:37 pm
Hello,
I have been tasked with providing server specs for a SQL Server 2008 SSIS installation and I'm not sure how to plan for capacity. I do have some information regarding data and users however I'm not certain how this translates to processor and RAM.
Details: This will be part of a SharePoint environment that is currently under development. This server will be dedicated to SSIS, and there are separate dedicated servers for SSRS and for SQL Server 2008.
Total Concurrent Users (estimated): 5450
Total packages for SSIS(estimated): 1000
Approximate size of data file to be processed: 18MB each
Approximate max amount of data to be processed: 900MB every 2 weeks
Planned process to take place after hours (6pm-6am)
Our standard server build is a dual processor(6 core each) w/ 16GB RAM and 146GB internal storage though there is a 1.5TB SAN being used for data storage. Is this overkill for this process? what is the "rule of thumb" on this? Any advise is greatly appreciated. by the way, the server will be clustered for redundancy.
Thanks for any and all advise.
Troy
March 27, 2012 at 10:22 am
Duplicate post. Please direct replies here: http://www.sqlservercentral.com/Forums/Topic1273023-146-1.aspx
Please do not cross-post. It fragments replies and wastes peoples time.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply