Post reply

Stored Procedure perfomance slow over the network

  • May 29, 2007 at 11:40 pm

    #173823

    Hi,

    If I am executing a SP in local machine the output is coming in 30secs, the SP is executed from client machine on the network the output is seen more than 5mins.

    Local Machine: US

    Client Machine: India

    Can anyone suggest me how to check the performance in this problem?

    Thanks

    Pavan

  • May 30, 2007 at 3:20 am

    #709615

    Possibly the network bandwidth is veryvery slow. You can check these with the performance monitor counters that are avialable with the windows operating system.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 6, 2007 at 10:05 am

    #711174

    this also depends upon the size of the result set, as well as the connection speed and bandwidth, qos settings etc. etc.

    If a query runs slower from a client than locally on the server the issue is always between client and server . e.g. network or middle tier.

    Hmm I just thought set options in a connection string can sometmes adversely affect performance. You might want to check that.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 3 posts - 1 through 2 (of 2 total)

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