Configuring SQL for optimal performance... SSD or HDD?

Posted by spoon16 on Server Fault See other posts from Server Fault or by spoon16
Published on 2009-09-27T00:50:16Z Indexed on 2010/05/17 10:21 UTC
Read the original article Hit count: 288

Filed under:

ssd

|

hdd

|

sql-server

|

Performance

Does anyone know of any comparisons that show how SSDs compare to HDDs for performance in a SQL environment?

I'm trying to understand what type of performance benefit might be gained by moving to SSD.

© 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 hdd

Installing Ubuntu 10.04 to external HDD overwrites the MBR of the internal HDD

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have a Asus A42F laptop which has Windows 7 32 bit installed on it's internal HDD. I have just installed Ubuntu 10.04 on a portable HDD using the laptop. Now my laptop does not boot Windows 7 if the portable HDD is disconnected. I can only get the boot menu when the portable HDD is connected. The… >>> More
Problem with running sata hdd with pata hdd.

as seen on Super User - Search for 'Super User'
There's a problem when I try to connect my pata hdd(slave) with the sata hdd(primary). The computer sometimes detects the drive and sometimes not. How can I fix this problem? >>> More
Fedora-13 not detecting USB HDD enclosure (with HDD)

as seen on Super User - Search for 'Super User'
I recently purchased this enclosure: http://www.amazon.com/Inland-2-5-Inc.../dp/B003SZ2Y12 and this HDD: http://www.amazon.com/Seagate-Barrac...3811667&sr=8-1 Now, I let my brother in law use the enclosure with his 160GB disk to back some stuff up. He then gave me that disk in my enclosure… >>> More
Moving windows-2003 hdd into virtual machine - with HDD shrink

as seen on Super User - Search for 'Super User'
Before you vote to close as exact duplicate, please read the full question. I was already read: Can I make a virtual machine out of a Windows XP physical machine? Disk2vhd,convert my PC to Hyper-V Virtual Machine Creating a Windows Virtual PC image from a Physical machine physical machine to virtual… >>> More
How to copy files from HDD to HDD with integrity checking

as seen on Super User - Search for 'Super User'
I am moving data from an almost dead HDD to an external USB drive using linux , because for some reason Windows cannot see the data. I want to copy a large amount of data over from the HDD to the USB drive with integrity checking. I thought about copying everything over and then checking with md5summer… >>> More