SQL Server on Solid State Drives

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL Server on Solid State Drives

SQL Server on Solid State Drives

Rate Topic

Display Mode

Topic Options

Author

Message

McSQL

Posted Thursday, May 06, 2010 1:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:39 AM
Points: 146, Visits: 280

Hello all,

I have been analysing a database server and found that disk I/O is quite a major bottleneck on the server.
We already moved to RAID 10 arrays, and while it did provide some level of improvement, the disk bottleneck still exists.
A selection of the queries do not help matters; some server side cursors which are quite badly designed, but they come from a bespoke piece of software which I cannot change, so we are left with trying to push them through as best as possible.

It has recently been suggested to move to SSD drives for the main database (which is on a separate drive) to assist with a significant performance increase in I/O.
While the basic disk stats would suggest that it will definitely help with performance, I have never had experience of hosting SQL on SSD, so was looking for some experiences or advice from anyone who has previously used it.
Is it reliable?
What level of performance increase do they provide in real terms?
Which components of SQL Server should ideally be hosted on SSD drives to optimise performance?

All replies much appreciated thanks :)

Post #916715

Dave Ballantyne

Posted Thursday, May 06, 2010 1:54 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 3:42 AM
Points: 1,943, Visits: 8,228

Try this link

http://www.brentozar.com/archive/2010/03/fusion-io-iodrive-review-fusionio/

Clear Sky SQL
My Blog
Kent user group

Post #916716

McSQL

Posted Thursday, May 06, 2010 2:08 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:39 AM
Points: 146, Visits: 280

Great article, thankyou.
I've been looking for one which has SQL benchmarks included for a while...

Post #916719

Elliott Whitlow

Posted Thursday, May 06, 2010 8:13 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

You need to keep in mind that there is a lot of additional memory needed to support this. Those drives do have updated drivers that cuts the amountof memory down..

I'm not 100% that SSD's are quite ready for this type of application. Also, you might consider limiting SSDs to tempdb..

CEWII

Post #917565

« Prev Topic | Next Topic »

Permissions