Solved

Building an HP DL380 G7 server with SSDs

Posted on 2015-01-21
2
506 Views
Last Modified: 2015-03-13
Hello!  We're looking to upgrade hardware on a DL380 G7 server and need better disk performance.  We currently have this particular SQL server as a vm (vmware) on a Compellent SAN where the Tier 1 storage is 15k SAS drives.  We are experiencing disk latency and performance issues, so we are looking to build up a physical, max the memory to 384GB and put the db and tempdb on SSDs.  The HP supported drives are outrageously priced and not abundantly available for this G7 server.  I am looking at other 3rd party solutions and am really considering PCI-e SSD cards like Fusion-io cards.  Any thoughts/ideas/recommendations would be greatly appreciated!  Thank you!

Mark
0
Comment
Question by:cansib
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Assisted Solution

by:whsum
whsum earned 250 total points
ID: 40563541
For the data centre and to limit personal liability for using components other than OEM, I can recommend no other than Intel. Fill up the drive bays with Intel S3700s, the PCIe slots with P3700. Put the SQL transaction logs in the PCIe drives.

Intel® Solid-State Drive Data Center Family
0
 
LVL 55

Accepted Solution

by:
andyalder earned 250 total points
ID: 40564045
I'd go with your Fusion-io idea, HP market these as I/O Accelerators and fully support them as they're in the quickspecs for the server. www.hp.com/go/ioaccelerator
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have a large data set and a SSIS package. How can I load this file in multi threading?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question