Go Back   Computer Forums > General Computing > Hardware
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 01-21-2013, 05:08 AM   #1
Fully Optimized
 
ssc456's Avatar
 
Join Date: Jan 2007
Posts: 4,279
Send a message via MSN to ssc456
Default SSD / SQL Question

Hey Guys,

Just wondering if i was to get an SSD drive for 1 of our work SQL servers (when i say server it's a high end desktop acting as a server), would the speed be increased if i left the OS on the old SATA drive?

I would move the TempDB and any DBs i'd like to speed up but i'm wondering if the OS is still on the SATA will i get the benifits?

Long term we'd be looking to move the OS as well but i'd lke to know if there are any benifits in the mean time.
__________________

__________________
He who has never failed has never attempted anything worth succeeding at.

Dont Eat Animals, Its Not Good For Them And They Dont Like It!
ssc456 is offline   Reply With Quote
Old 01-21-2013, 07:54 AM   #2
Fully Optimized
 
OhSnapWord's Avatar
 
Join Date: Jan 2012
Location: USA
Posts: 1,853
Default Re: SSD / SQL Question

What are the specs of the computer? I know that SQL servers like a lot of RAM.

Also, what type of network are you running?
__________________

__________________
FX-8350 @ 4.7 cooled by H80, 32GB Mushkin Enhanced Blackline 2133, Asus Sabertooth 990FX, 2x Radeon HD 7850 2GB in X-fire, 500GB Samsung 850 Evo, 4TB Seagate, 3TB WD Black, 2x 1TB WD RED in RAID 0
OhSnapWord is offline   Reply With Quote
Old 01-21-2013, 10:03 AM   #3
Fully Optimized
 
ssc456's Avatar
 
Join Date: Jan 2007
Posts: 4,279
Send a message via MSN to ssc456
Default Re: SSD / SQL Question

Although i appreciate that your questions will undoubtedly effect the performance of SQL Server i'd like to know the answer to the question regardless of the spec.

If the comp had a quad core xeon processor with 6Gb RAM (which it does) or if the comp had a C2D with 2Gb RAM the question remains the same.

Does adding the SSD drive into the machine and just storing the databases on it improve performance.
__________________
He who has never failed has never attempted anything worth succeeding at.

Dont Eat Animals, Its Not Good For Them And They Dont Like It!
ssc456 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 02:12 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0