Post reply

How to check Query Performance in different servers

  • November 15, 2006 at 1:27 am

    #117617

    HI

    I have a query which executes in 2 minutes in one server. But the same query takes nearly an hour to execute. The database schema and server configuration are same in both the servers. Can anyone give me a general check-list that has to be compared between the servers???

  • November 15, 2006 at 3:18 am

    #671888

    hi

    I can give you some tips.

    Check Whthr the hardware configuration is really the same and any other applications running in one server are not running in the other server.

    Check the query plans in both the servers. This will give you a good idea of what is wrong (or right).

    Check the indexes are same and properly tuned.

    Search this site for some really good info on issues such as yours.

     

    "Keep Trying"

  • November 15, 2006 at 3:36 am

    #671892

    Cirag:  Thank You.

  • November 16, 2006 at 9:53 am

    #672363

    Don't forget our good friend UPDATE STATISTICS

    That's a Top 10 gotcha!


    Rick Todd

  • November 16, 2006 at 10:06 am

    #672365

    Can we see a link to this top 10 pls... I'd like to see it .

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

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