Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Budget Money to Spend Expand / Collapse
Author
Message
Posted Wednesday, September 02, 2009 8:46 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 12:46 PM
Points: 3,843, Visits: 3,833
My manager approached me late today and told me that we have roughly 200 k in our budget for hardware and software licenses and upgrades for this year. He was looking for ideas on how to spend it. Whoo Hooo!

I've been brought on board at this company to design, from the ground up, a SQL Server data mart that will be used by our Analytics team. The data is all sourced in Teradata and I'll be using SSIS to pull it down and load the SQL database. The server itself is fairly robust ( I don't have all the specs in front of me but I think it has quad dual-core processors and 16 GB of RAM and 3 TB of SAN space). I am building the environment out in SQL Server 2005 and using SSAS and SSRS to provide the data to the analysts. I have a separate ETL server which hosts my SSIS instance and is used for scheduling and running all of our automated SSIS jobs. Our SSRS/web server is also on a separate box.

We are so much at the beginning of the process of building out this environment, I'm having a hard time thinking what else we could possibly need. I'd like to upgrade to SQL Server 2008, but we may not be able to yet because of corporate standards. We may add another 3 TB of disk space for roughly 40 k, and I'd like to beef up my ETL box a bit.

My question is, what would you do? Given the purpose and intent of this environment, what tools, hardware, or software would you like to have to do the job? What else should we consider for report rendering and delivery, or forecasting, or anything else that I just don't know about?




John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Post #781914
Posted Thursday, September 03, 2009 8:46 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 12:46 PM
Points: 3,843, Visits: 3,833
Just bumping my thread.....





John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Post #782251
Posted Thursday, September 03, 2009 8:56 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 32,781, Visits: 14,942
more RAM?

or maybe some Fusion SSDs for speed?

As far as tools, sorry, not sure what might help you here.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #782260
Posted Thursday, September 03, 2009 9:19 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 12:46 PM
Points: 3,843, Visits: 3,833
I don't want to ask a dumb question Steve, but Fusion SSDs? Can you elaborate a bit on this, have you put this to use anywhere? What kind of benefits did you see?



John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Post #782286
Posted Thursday, September 03, 2009 9:25 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 32,781, Visits: 14,942
http://www.sqlservercentral.com/blogs/sqlmanofmystery/archive/2009/04/14/ssd-the-game-changer.aspx
http://www.sqlservercentral.com/blogs/sqlmanofmystery/archive/2009/08/02/fusion-io-update.aspx
http://www.dvnation.com/Fusion-IO-IODrive-SSD-Solid-State-Disk-Drive-Review.html

I heard from another MVP that they had a customer which had run them for over 8 months and loved them. No real issues, and tremendous speed improvements. They couldn't disclose the customer because of an NDA.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #782294
Posted Thursday, September 03, 2009 10:33 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 12:46 PM
Points: 3,843, Visits: 3,833
Thanks for the info. I've read through them and it sounds very interested. We'll consider this.



Anyone else??




John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Post #782366
Posted Thursday, September 03, 2009 12:38 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 11:32 AM
Points: 1,636, Visits: 16,534
just an idea...and no doubt already in place, buts how's your Disaster Recovery model looking?




__________________________________________________________________
you can lead a user to data....but you cannot make them think !
__________________________________________________________________
Post #782479
Posted Thursday, September 03, 2009 1:21 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 12:46 PM
Points: 3,843, Visits: 3,833
gah (9/3/2009)
just an idea...and no doubt already in place, buts how's your Disaster Recovery model looking?



Our corporate support team plans the DR strategies for our servers. We will be taking regular SQL backps our our data and the server team will be responsible for file system backups on the SAN (with will backup our bacup files). Most of the data itself will be sourced from our Teradata system so we could revert to that as a data source if needed.




John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Post #782516
Posted Monday, September 07, 2009 3:55 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
John Rowan (9/2/2009)
My manager approached me late today and told me that we have roughly 200 k in our budget for hardware and software licenses and upgrades for this year. He was looking for ideas on how to spend it. Whoo Hooo!


Perfect!

Just hire two or three of us, we will come out with a comprehensive, detailed plan for your company. Our bill will be roughly about $200k


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #783926
Posted Monday, September 07, 2009 5:17 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:17 AM
Points: 4,379, Visits: 9,470
As a wish list - I would ask for two systems (clustered) running Windows Server 2008 x64 - 64GB RAM and 4 hex core processors to host SQL Server 2005/2008.

I would also bump up to Enterprise Edition - if you are not already, there are quite a few features in the enterprise version that you will need for a data mart/warehouse environment.

You could use both nodes - one as your SSIS node, the other for the the database and SSAS (if you are using that). However, that would mean additional licensing costs

With that kind of system - you could run everything on a single node, but you would only do that during maintenance cycles and/or emergency situations. During normal business, you would have quite a bit of resources to process the data and perform your extracts and loads.

That's what I would be asking for...


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #783942
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse