InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 03:08:01 GMT20http://www.sqlservercentral.com/Forums/Topic781914-361-1.aspxI ended up purchasing an additional 2 TB of disk space for our SAN. In fact, the SAN that we were using was almost full so I had to buy a new SAN to hold the new disk space. I also purchased a new server for our ETL box. Our original box was an older Compaq DL360 G4P with 4X Intel Xeon 3.4 GHz CPUs and 4 GB of RAM.We're still using the original box, but it will finally be replaced here this month. We're replacing it with a DL360 G6 with 32 GB of RAM. I'm not sure about the CPUs, but the server is going to be a much better box for our ETL.Well, that's it. Nothing too exciting, but this is what we used our budget for.Mon, 01 Mar 2010 11:25:25 GMTJohn Rowanhttp://www.sqlservercentral.com/Forums/Topic781914-361-1.aspxHow did your project end up? I will be interested to know. Thanks.Thu, 25 Feb 2010 16:16:37 GMTbluepaperbaghttp://www.sqlservercentral.com/Forums/Topic781914-361-1.aspxAs 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...Mon, 07 Sep 2009 17:17:42 GMTJeffrey Williams 3188http://www.sqlservercentral.com/Forums/Topic781914-361-1.aspx[quote][b]John Rowan (9/2/2009)[/b][hr]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![/quote]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 :-DMon, 07 Sep 2009 15:55:39 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic781914-361-1.aspx[quote][b]gah (9/3/2009)[/b][hr]just an idea...and no doubt already in place, buts how's your Disaster Recovery model looking?[/quote]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.Thu, 03 Sep 2009 13:21:08 GMTJohn Rowanhttp://www.sqlservercentral.com/Forums/Topic781914-361-1.aspxjust an idea...and no doubt already in place, buts how's your Disaster Recovery model looking?Thu, 03 Sep 2009 12:38:23 GMTJ Livingston SQLhttp://www.sqlservercentral.com/Forums/Topic781914-361-1.aspxThanks for the info. I've read through them and it sounds very interested. We'll consider this.Anyone else??Thu, 03 Sep 2009 10:33:32 GMTJohn Rowanhttp://www.sqlservercentral.com/Forums/Topic781914-361-1.aspxhttp://www.sqlservercentral.com/blogs/sqlmanofmystery/archive/2009/04/14/ssd-the-game-changer.aspxhttp://www.sqlservercentral.com/blogs/sqlmanofmystery/archive/2009/08/02/fusion-io-update.aspxhttp://www.dvnation.com/Fusion-IO-IODrive-SSD-Solid-State-Disk-Drive-Review.htmlI 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.Thu, 03 Sep 2009 09:25:56 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic781914-361-1.aspxI 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?Thu, 03 Sep 2009 09:19:49 GMTJohn Rowanhttp://www.sqlservercentral.com/Forums/Topic781914-361-1.aspxmore RAM?or maybe some Fusion SSDs for speed?As far as tools, sorry, not sure what might help you here.Thu, 03 Sep 2009 08:56:57 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic781914-361-1.aspxJust bumping my thread.....Thu, 03 Sep 2009 08:46:48 GMTJohn Rowanhttp://www.sqlservercentral.com/Forums/Topic781914-361-1.aspxMy 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?Wed, 02 Sep 2009 20:46:30 GMTJohn Rowan