SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Budget Money to Spend


Budget Money to Spend

Author
Message
John Rowan
John Rowan
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7752 Visits: 4564
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
John Rowan
John Rowan
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7752 Visits: 4564
Just bumping my thread.....

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Steve Jones
Steve Jones
SSC Guru
SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)

Group: Administrators
Points: 83259 Visits: 19223
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
My Blog: www.voiceofthedba.com
John Rowan
John Rowan
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7752 Visits: 4564
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
Steve Jones
Steve Jones
SSC Guru
SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)SSC Guru (83K reputation)

Group: Administrators
Points: 83259 Visits: 19223
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
My Blog: www.voiceofthedba.com
John Rowan
John Rowan
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7752 Visits: 4564
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
J Livingston SQL
J Livingston SQL
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6903 Visits: 36052
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
and remember....every day is a school day

John Rowan
John Rowan
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7752 Visits: 4564
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
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSCertifiable
SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)

Group: General Forum Members
Points: 7147 Visits: 4639
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 :-D

_____________________________________
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.
Jeffrey Williams 3188
Jeffrey Williams 3188
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10103 Visits: 10004
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 opportunities brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search