THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Need to run SQL Server VPCs faster? -> Fast flash drives do help

This blog has moved! You can find this content at the following new location:

http://greglow.com/index.php/2008/08/31/need-to-run-sql-server-vpcs-faster-fast-flash-drives-do-help/

Published Saturday, August 30, 2008 8:57 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Felipe Ferreira said:

hey Greg,

I was thinking to do the same to remove the VPCs from my notebook HD, but I was thinking now...wouldn't be better (faster) to use a external HD case and attach a 500GB SATA II hard drive?

best regards

August 31, 2008 7:14 AM
 

John Paul Cook said:

I performed extensive test over a year ago and did not find external USB flash memory to be faster. Of course, flash memory is improving quickly, probably faster than Moore's law. I did find that performance testing of Virtual PC is fraught with peril because of caching. I recommend booting the physical machine, do a test, then reboot the physical machine, do another test. Do twoing consecutive tests on the same physical boot can lead to skewed results because of caching. That's the very short summary of 100s of tests.

August 31, 2008 10:21 AM
 

Greg Low said:

Hi Felipe and John,

I did find much superior performance compared to using an external hard drive. I'm guessing it's simply the lack of seek time.

I'm guessing if you tested it a year ago, you weren't using flash that could do 34 mb/sec. I suspect that's what's changed.

Regards,

Greg

September 1, 2008 1:57 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

Archives

Privacy Statement