Solved

SSD for heavy database on a 2003 box

Posted on 2014-10-01
3
104 Views
Last Modified: 2014-10-22
I have a 2003 x32 all patched, recently one of our database were upgraded and the new one required a lot more I/O than prev version. Currently its on a RAID10, all ok before but with new db it is causing the server to lag and even freeze on clients, I am wondering if I can just run 2 SSD on RAID1 as they are around 500+ read and 400+write, I am guessing I may just use this setup for a few months until I can prep another server with may be 2x15k for OS and 6x10k on RAID6 for data.

I know consumer SSD are not set for servers, but should give enough life for a few months even though it will be running a almost non-stop database with very high I/O.

What would you guys suggest ? Thanks
0
Comment
Question by:Combemartin
[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
3 Comments
 
LVL 5

Assisted Solution

by:Daniel Kline
Daniel Kline earned 250 total points
ID: 40356102
I'm not sure what you mean by "consumer" SSDs, but I'm running arrays of both Intel and Samsung SSDs, both 500GB and 1TB.  You will want to make some adjustments on the server to optimize the performance for the SSDs, like turning off all power management and caching, but I think the result will impress you so much that you will abandon spindle drives.
0
 
LVL 14

Accepted Solution

by:
Natty Greg earned 250 total points
ID: 40356335
Daniel hit the nail on its head, youll be fine with SSD, no moving parts thats great, just buy proper ones via reseach cause some fail without notice, Intel, samsung and kingston makes good ssd's
0
 

Author Comment

by:Combemartin
ID: 40356385
Thanks guys, I am just concerned by the part where all SSD will fail after so many I/O, but this info were like 2-3 years ago when I first looked at SSD on a server, and as it will be a database server, it is going to take some hits on I/O.  last week I checked that within a week, there are almost 330 million I/O reads and 50m I/O write. how would something like the Samsung do against such heavy usage ?
0

Featured Post

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found here: http://www.experts-exchang…
Know what services you can and cannot, should and should not combine on your server.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

717 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