In the company that I work we need to buy a server .So they asked me what are the best specifications for SAN(Storage area network):
and I will give you the idea that what we want to do
AS the DBA they asked me the best practice for SAN? I need the good reference to put the specification for the server ,what is the best server? any Idea How to do that ?
HP DL380G7 X5660 Six Core High Performance Rack Server (583970-421) –Processor(s): (2) Intel® Xeon® Processor X5660 (2.80 GHz,12MB L3 Cache, 95W, DDR3-1333, HT, Turbo 2/2/2/2/3/3)
answered Jul 05, 2012 at 09:25 AM
There is a lot of information missing here, that you seem not to know yourself rather than not supplying it in your question.
I suggest finding out what data access patterns are going to be. You cannot size a system for 520 users and only know what 20 of those users are going to be doing.
Be that as it may, a general rule of thumb for SQL Server that I follow is to prioritize your hardware spending as follows:
The SAN portion is the most difficult and if you have no experience, then get in touch with an expert (in your company maybe). Brent Ozar has a pretty good Best Practice for SAN Storage article that may help here.
I strongly suggest you get more details about the applications that are going to be working with the SQL Server and if possible get some sort of baseline for the application.
answered Jul 05, 2012 at 10:14 AM