<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 Strategies
»
Budget Money to Spend
12 posts, Page 1 of 2
1
2
»»
Budget Money to Spend
Rate Topic
Display Mode
Topic Options
Author
Message
John Rowan
John Rowan
Posted Wednesday, September 02, 2009 8:46 PM
Hall of Fame
Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837,
Visits: 3,821
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
John Rowan
John Rowan
Posted Thursday, September 03, 2009 8:46 AM
Hall of Fame
Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837,
Visits: 3,821
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
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, September 03, 2009 8:56 AM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421,
Visits: 13,734
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
John Rowan
John Rowan
Posted Thursday, September 03, 2009 9:19 AM
Hall of Fame
Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837,
Visits: 3,821
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
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, September 03, 2009 9:25 AM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421,
Visits: 13,734
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
John Rowan
John Rowan
Posted Thursday, September 03, 2009 10:33 AM
Hall of Fame
Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837,
Visits: 3,821
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
J Livingston SQL
J Livingston SQL
Posted Thursday, September 03, 2009 12:38 PM
UDP Broadcaster
Group: General Forum Members
Last Login: Today @ 4:04 AM
Points: 1,456,
Visits: 14,259
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
John Rowan
John Rowan
Posted Thursday, September 03, 2009 1:21 PM
Hall of Fame
Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837,
Visits: 3,821
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
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Posted Monday, September 07, 2009 3:55 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 5:55 AM
Points: 2,982,
Visits: 4,398
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
Jeffrey Williams 3188
Jeffrey Williams 3188
Posted Monday, September 07, 2009 5:17 PM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Friday, May 17, 2013 11:21 AM
Points: 4,317,
Visits: 9,216
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 »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
