Solved

SSD for heavy database on a 2003 box

Posted on 2014-10-01
3
92 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
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 9

Accepted Solution

by:
nattygreg 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

The question has been asked on multiple occasions as to how best to do printing in a remote desktop or terminal services environment.   It seems that this particular question has plagued several people and most especially as Terminal Services, as…
On a regular basis I get questions about slow RDP performance, RDP connection problems, strange errors and even BSOD, remote computers freezing or restarting after initiation of a remote session. In a lot of this cases the quick solutions made b…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

863 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now