Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server on Solid State Drives Expand / Collapse
Author
Message
Posted Thursday, May 6, 2010 1:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:44 AM
Points: 146, Visits: 282
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
Posted Thursday, May 6, 2010 1:54 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 5:33 AM
Points: 1,949, Visits: 8,313
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
Posted Thursday, May 6, 2010 2:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:44 AM
Points: 146, Visits: 282
Great article, thankyou.
I've been looking for one which has SQL benchmarks included for a while...
Post #916719
Posted Thursday, May 6, 2010 8:13 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
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 »

Add to briefcase

Permissions Expand / Collapse