Unix vs Sql Severs
Posted: Mon Nov 27, 2006 3:51 pm
Hi -
I have just landed a position in a relatively "small" IT shop - "small" in that they do not process billions of rows of data with their datastage jobs - but they are very heavy on the transform effort of the data they do process. when this shop was set up it was built on SQL Servers - but, evidently, has outgrown the capacity of what these severs can do. More accurately stated, the servers are too slow to do the processing in the time it needs to be done. So, now looking at a server "upgrade" of some sort - the question must be asked - do we "upgrade" with new and improved SQL Servers or do we make a jump to unix boxes given that we anticipate at least 15% growth in our processing needs in each of the next 5 years? It may also be noted that we are currently running ONLY the server edition of datastage - but will most likely be upgrading to enterprise edition with the server upgrade.
I am NOT a datastage admin - nor is anyone on our team - so I'm just looking for some guidance from anyone who feels strongly one way or the other and/or has experience with such an issue!
thanks
I have just landed a position in a relatively "small" IT shop - "small" in that they do not process billions of rows of data with their datastage jobs - but they are very heavy on the transform effort of the data they do process. when this shop was set up it was built on SQL Servers - but, evidently, has outgrown the capacity of what these severs can do. More accurately stated, the servers are too slow to do the processing in the time it needs to be done. So, now looking at a server "upgrade" of some sort - the question must be asked - do we "upgrade" with new and improved SQL Servers or do we make a jump to unix boxes given that we anticipate at least 15% growth in our processing needs in each of the next 5 years? It may also be noted that we are currently running ONLY the server edition of datastage - but will most likely be upgrading to enterprise edition with the server upgrade.
I am NOT a datastage admin - nor is anyone on our team - so I'm just looking for some guidance from anyone who feels strongly one way or the other and/or has experience with such an issue!
thanks