Recommendations for SSD for server and database use?

Posted by Tony_Henrich on Server Fault See other posts from Server Fault or by Tony_Henrich
Published on 2010-05-15T17:29:18Z Indexed on 2010/05/15 17:34 UTC
Read the original article Hit count: 171

Filed under:

ssd

|

memory

|

ram

|

windows-server-2008

|

sql-server

SSDs are a new technology and they are constantly improving. A lot of the posts here were posted in 2009 when SSDs where less mature and not as fast. What was recommend back then is probably out of date today because of better options.

The SSD is used to hold SQL Server databases. Size is probably 128G. The database is used with a CMS and web server so web pages need to get their data and render as fast as possible.

Which modern SSD is recommended for such a use? Is there an SSD better than Intel X-25 E/M in terms of performance/cost?

(I am also evaluating cost between : RAM + UPS (semi persistent) vs SSD for same amount of gigabytes. No RAID is involved)

© Server Fault or respective owner

Related posts about ssd

SSD -- Special settings for SSD as secondary drive?

as seen on Super User - Search for 'Super User'
Hello all, I recently purchased an Intel SSD (X25-V 40GB) and I want to add it to my PC as a secondary drive (not the boot/system drive) so I can install specific software to it. Now, do I need to do anything special to ensure long life and peak performance with this as a secondary drive? I have… >>> More
Internal drives vs USB-3 with external SSD or eSata with External SSD

as seen on Super User - Search for 'Super User'
I have a need to carry VMWare Virtual Machines with me for work. These are very large files (each VM is 20GB or more) and I carry around about 40 to 50 VM's to simulate different software configurations for different client needs. Key: they won't fit on the internal hard drive of my current laptop… >>> More
"Windows detected a hard drive" issue in Windows 7 x64

as seen on Super User - Search for 'Super User'
I upgraded to the OCZ-Agility3 120GB from a 60 OCZ Vertex2 SSD. I cloned the drive from the Vertex to the new Agility. Everything seemed to have gone well and have not had any problems. Recently in the passed month I have gotten this error: I downloaded teh OCZToolboxMP and ran the SMART utility… >>> More
Disable SSD in ASUS 900 running Ubuntu 9.10

as seen on Super User - Search for 'Super User'
Recently I managed to completely mess up my ASUS 900, but I have no immediate desire to upgrade since it's only my travel laptop (and I'm waiting for a few months to see if anything interesting comes out). For now, though, I've hit an interesting problem. The 4GB SSD that is soldered onto the motherboard… >>> More
NTFS journal on different (SSD) disk

as seen on Server Fault - Search for 'Server Fault'
Some advanced file systems, like ZFS have the option of using SSD disks as a second level cache for the file system or for the journal. Is this possible with NTFS? >>> More

Related posts about memory

SQL Server and Hyper-V Dynamic Memory Part 2

as seen on SQL Blog - Search for 'SQL Blog'
Part 1 of this series was an introduction and overview of Hyper-V Dynamic Memory. This part looks at SQL Server memory management and how the SQL engine responds to changing OS memory conditions. Part 2: SQL Server Memory Management As with any Windows process, sqlserver.exe has a virtual… >>> More
SQL Server and Hyper-V Dynamic Memory - Part 1

as seen on SQL Blog - Search for 'SQL Blog'
SQL and Dynamic Memory Blog Post Series Hyper-V Dynamic Memory is a new feature in Windows Server 2008 R2 SP1 that allows the memory assigned to guest virtual machines to vary according to demand. Using this feature with SQL Server is supported, but how well does it work in… >>> More
SQL Server and Hyper-V Dynamic Memory - Part 1

as seen on SQL Blog - Search for 'SQL Blog'
SQL and Dynamic Memory Blog Post Series Hyper-V Dynamic Memory is a new feature in Windows Server 2008 R2 SP1 that allows the memory assigned to guest virtual machines to vary according to demand. Using this feature with SQL Server is supported, but how well does it work in… >>> More
Python Memory leak - Solved, but still puzzled

as seen on Stack Overflow - Search for 'Stack Overflow'
Dear everyone, I have successfully debugged my own memory leak problems. However, I have noticed some very strange occurence. for fid, fv in freqDic.iteritems(): outf.write(fid+"\t") #ID for i, term in enumerate(domain): #Vector tfidf = self.tf(term… >>> More
SQL Server and Hyper-V Dynamic Memory Part 3

as seen on SQL Blog - Search for 'SQL Blog'
In parts 1 and 2 of this series we looked at the basics of Hyper-V Dynamic Memory and SQL Server memory management. In this part Serdar looks at configuration guidelines for SQL Server memory management. Part 3: Configuration Guidelines for Hyper-V Dynamic Memory and SQL Server Now that… >>> More