Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2014-09-09 : 17:02:56
|
| I want to know, if company is providing me server for ETL stuff. What stuff in the server or extra application make ETL server more efficient/robust? i.e (sql server2008 or 2012, space, ram size, ?????)Thank You, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-09-09 : 17:46:32
|
| I would use SQL Server 2014 unless there is a reason to use a lower version. Regarding what you need to make it efficient/robust. Hardware is important, especially CPU, memory and I/O. But also important is how things are designed.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2014-09-09 : 17:55:00
|
| tkizer, really appreciate your reply. Would you mind if you provide me few more words, I know they going to ask CPU Speed? memory AND how I want to designed...i.e (Space size ? Ram ? etc...) any extra third party software or anything.Thank You. |
|
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-09-11 : 11:43:26
|
| Hi,Its really difficult to predict about memory disk and CPU requirements generally forecasting is done on basis of number of users, size of database and complexity of application. After procuring the server you may set up perfmon counters to baseline your current server. My firm provides 8 cores CPU, with 16-32 G RAM and 500 G space. We then start testing as per base-lining we recommend about hardware resources. ETL stuff should have faster disk and enough RAM supported by capable CPU cores.Hope this helpsRegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2014-09-18 : 16:25:01
|
| Thank You, Shanky and sorry for late reply. |
|
|
|
|
|
|
|
|
Server Information