PErformance difference with Management Studio

  • 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

  • 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

  • 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,

  • 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

  • Yes, I am sure the Work station does not have the server installed it only has Management Studio.

  • 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