In my current contract I got a laptop (32bit, 3GB memory) which to be honest was less than suitable for running local instance of SQL Server and SSAS Tabular which is in-memory. After a month I had to ask for an upgrade and I got 64bit, 8GB memory but more importantly I got it with SSD drive which I was always looking forward to.
My main interest in SSD was performance comparing to HDD so it happened that I had available 15GB SQL Server Database which I thought it an idea test subject for comparing performance. I'm wasn't interested in details just overall isn't a noticable difference?
Test 1 - Copying 15GB database file
I copied the file on my previous laptop with HDD and it took 10 minutes and 15 seconds and that gives me 25MB per second.
I copied the file on my new laptop with SSD and it took 90 seconds which gives me 170MB per second.
Quite a difference isn't it? To be precise 1s in SSD world is equivalent of 6.8s in HDD world :)
Test 2 - Installing SQL Server 2014 with typical BI Install
One of my set up task on new laptop was to install SQL Server 2014 so I thought I'll take the opportunity to measure how long it takes with a fairly typical BI install (Database Engine, SSIS, SSRS Native, SSAS Tabular, SSMS without SSDT/BIDS which is not part of install anymore and without MDS and DQS).
Install was a bit slower than I expected on SSD as it took 10 minutes and 30 seconds and I can only suspect HHD install is much longer.
Test 3 - Windows boot up and shut down time
I always wondered about window boot time with SSD and now I have actual results.
HDD Boot up = 2min 58s (yes that long!)
SSD boot up = 34 seconds
Note: I stopped measuring time when I could see my desktop as it would be difficult to measure accurately the time everything is up and running.
Just for comparison purposes if I start up the laptop 250 times a year than with SSD I would save 10 hours and if I multiply it by my dailly rate than the laptop would almost pay for itself by speeding up boot time alone :)
Shut down is not that different so HDD is 25 seconds and SSD is 12 seconds so per year that is 54 minutes.
Test 4 - Opening Outlook
During my meeting when I have a few windows app (and are not running out of memory) it takes ages, at least a few minutes. I mentioned that because my test involved only opening Outlook without any other apps running and it took 29 seconds and after closing it and opening it again took 14 seconds comparing to SSD 6seconds.
Not much of a saving but I know that in practice the saving is much bigger.
Test 5 - Opening Google Chrome and our website.
HDD took 35 seconds! about 10 seconds chrome and 25s our website and 14 seconds on second attempt, 10s chrome and 4s our website.
SSD took.... well it was pretty much instant opening a browser and our website.
Which means the network/internet is not slow it's the HDD that is slowing it down.
Time Savings calculations
The calculations below assumes you spend 5h a day in front of a laptop/pc x 5 days a week x 45 weeks a year (excluding time off).
|Time Savings a day
HDD vs SSD Review Verdict
Yes buy one!
One a personak note I decided I do need one my personal/work (website) use as amount of time I spend waiting for little things does add up to big time savings, and if you are a developer than you probably know how many little things I haven't included in these tests and if you employ a developer than do buy SSD drives for your developers and it is well worth it!
I would upgrade my laptop drive however limited disk space on SSD is a bit of a problem for my virtual machines usage (hyper-v) so I have decided to wait a little bit longer and get myself a new laptop with USD 3.1 (I still have 2,0) so I can get external drive for virtual machine and I will probably wait until Windows 9 hopeing it is going to be compatible with my Snowball microphone which quality is just outstanding (Important for our YouTube Channel). Windows 8 was not compatible with it untill recent Windows 8 update that fixed low volume issue.
I hope you enjoyed my laptop performance comoparison and I hope you get similar and better performance when you switch.