Solved

Building an HP DL380 G7 server with SSDs

Posted on 2015-01-21
2
531 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

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

726 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