[dba-VB] SQL Server over Hamachi: First test not hopeful

jwcolby jwcolby at colbyconsulting.com
Sun Jan 16 07:40:56 CST 2011


Are you running this over the internet I assume - over Hamachi wold imply that.  What are your 
connection speeds at either end using speedtest.net?

John W. Colby
www.ColbyConsulting.com

On 1/16/2011 5:39 AM, Mark Breen wrote:
> Hello John,
>
> I am using Hamachi - since you mentioned it here a few years ago -  and
> Access and SQL server since Jan 2008 and it works the same as a VLan over
> Cisco hardware.  No performance difference between Hamachi and CISCO,
>
> Thanks for the info on Hamachi in 2007/8 BTW :)
>
> HTH
>
> Mark
>
> On 15 January 2011 23:37, jwcolby<jwcolby at colbyconsulting.com>  wrote:
>
>> I developed a SQL Server database, with perhaps 10-15 tables, populated a
>> few with just a handful of records, created an Access database and built a
>> few forms.  My strategy is to do Access because I can do it quickly, but
>> link it to SQL Server, the run the FE on a remote computer over Hamachi.
>>
>> Tonight I went to a local Arby's to test the speed of the system.  The
>> local Arby's has an open wifi, which using Speedtest.net tested 5 mbit down,
>> 1 mbit up - typical low end cable in my area.
>>
>> So I tried to use the system and... well... it took an extremely long time
>> to connect, if it connected at all.  Access mostly timed out trying to log
>> on.  SQL Server Management System would log on sometimes.  Sometimes not.
>>   Trying to hit it at the actual Hamachi IP address worked but took awhile.
>>   15 - 30 seconds to connect (I did not time it).
>>
>> To be honest I am puzzled.  Google finds plenty of folks trying this, some
>> succeeding, most pretty slow.  Remote desktop is plenty fast.
>>
>>  From inside of my office, out across the internet via Hamachi I have done
>> things like file transfers etc (in the past).  Remote desktop has always
>> been very speedy, but there isn't much needed for RD.
>>
>> I had really expected faster connections / operation.  I really expected
>> SSMS to just work, pretty much at speed.  It didn't.
>>
>> Sigh, back to the drawing boards.
>> --
>> John W. Colby
>> www.ColbyConsulting.com
>> _______________________________________________
>> dba-VB mailing list
>> dba-VB at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-vb
>> http://www.databaseadvisors.com
>>
>>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>



More information about the dba-VB mailing list