Post reply

Speed issue

  • May 18, 2005 at 5:09 am

    #109710

    I am trying to resolve an issue for one of our clients. They have a database on a SQL server which sits on a different subnet on their LAN to the client machines connecting to it. The performance of this is dreadfully slow. I made an access copy of the data and tried connecting to this. Again it was slow. I then moved the access copy to the local client machine. Connection was instant. I then tried restoring a copy of the sql database to a different sql server that sits on the same subnet as the client machine. Performance of this database was very good. This suggests to me that there is a problem with the performance of their network when trying to access data across subnets. Does anyone have an idea why this would be? All machines on their network have MDAC 2.8 installed.

    Thanks in advance.

    Kindest Regards,

    Steve Williams

  • May 19, 2005 at 3:19 am

    #559792

    Hi, What happens if you add an alias on the "Client Network Utility?"

     

  • May 19, 2005 at 6:46 am

    #559827

    Sounds like a network problem, not a SQL Server problem, such as a mismatch in the Duplex Mode and Media Type settings of the network cards. Could also be a problem with a switch or router. I'd have your network people check it out.

     

  • May 19, 2005 at 9:31 am

    #559886

    I'd agree, we had a similar issue once and it was entirely due to network issues (the router was set at 100MB/s (it was a while ago) and the NIC was set at auto negotiate).

    Setting them both at 100MB/s fixed the problem in a jiffy.

  • May 19, 2005 at 10:51 am

    #559928

    Adding my voice to the bedlam ... it definitely sounds like a network issue, not a SQL issue.

    One additional troubleshooting step that would confirm this for sure:  Try getting to the database from a machine on the same subnet as the SQL server, rather than moving the database across ... moving Mohammed to the mountain instead of vice versa, as it were.  If you get good performance again, then you've confirmed that the drag point is the connection between the two subnets and it becomes a job for the network guy.

    Hopefully that's not also you.  Some of us get to wear two hats ...

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply