Sql performance on vista machine client

Question

I have an application written in a language called magic. This application uses MSSQL Server. When it is deployed where the client is on vista machine, and the server is on a remote machine, the performance is dramatically degraded. When that same application is used from an XP client, with the db on remote machine – the performance is ok. Also when the server and client are both on a vista machine, it works ok.

This makes me think that it's some kind of network protocol problem, but I can't seem to solve it.

Help will be appreciated

Note that the vista is 64 bit, and that the application is 32bit

Answer 1

Are you connecting via an IP Address or a host name maybe looking up the hostname is taking an age? I assume the vista and xp machine are in the same location.

Make sure the vista and xp machine use the same dns settings. perhaps its failing on a reverse dns lookup.

Answer 2

Many constraints... mainly internet speed if your remote database communicates through internet.

Answer 3

The problem is cause by some strange vista behaviour around named computers.

You can either use ip instead of names, or change the following vista setting:

Start Run ->

gpedit.msc ->

Computer Configuration\Administrative Templates\Network\DNS Client\Turn off Multicast Name Resolution = Enabled