June 9, 2011 at 9:50 am
Hello,
I have two different work stations with management 2008 studio installed. Both are connecting to the same SQL DB server.
Running the same query from each of the WorkStations gives very different performance results. One work station can take 30-seconds and in the other it takes up to 30 minutes. This is for exactly the same query.
Anyone have any ideas?
Thank you,
Michael
June 9, 2011 at 10:00 am
The difference in results can be related to hardware of your workstations. Also, network latency will have some effect. Timing of when you run the queries can also have an effect.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:32 am
When I log on to the server itself and try to run it it is also pretty slow.
Could there be any Management Studio configuration that may cause this?
thanks,
June 9, 2011 at 10:35 am
So direct on the server runs that slowly as well?
Are you sure that the workstation that performs quickly is pointed correctly to that server? Maybe an alias is redirecting it to local?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:38 am
Yes, I am sure the Work station does not have the server installed it only has Management Studio.
June 9, 2011 at 10:40 am
Then I would be looking for something that is blocking or contending with resources.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply