May 29, 2007 at 11:40 pm
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:
Can anyone suggest me how to check the performance in this problem?
Thanks
Pavan
May 30, 2007 at 3:20 am
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
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