Post reply

Sql Server vs Sql server

  • January 12, 2009 at 6:16 am

    #73429

    Hi All,

    I have fine tuned a query from 4 hours to 5 minutes. I have execute the same query( fine tuned one) in other server. It took 45 seconds only.

    say for example,

    Server Details:

    DEV_SERVER1

    DEV_SERVER2

    Assume, i have execute my query on DEV_SERVER1. It took 5 minutes.

    Now, i have executed the same query(Not even modified a single dot) on DEV_SERVER2. It took 45 seconds only.

    So i just thought the following things may get affect the query performance.

    1) RAM capability

    2) HARD DISK space

    3) No of users connected to that server

    4) No of applications installed in that server

    Please let me know whether my thoughts are correct or not.

    it would be appreciable if somebody add more points.

    🙂

    karthik

  • January 12, 2009 at 6:18 am

    #925212

    I have posted it twice. How should i delete it ?

    I clicked 'DELETE' button. but i am unable to delete it.

    karthik

  • January 12, 2009 at 6:25 am

    #925217

    Add...

    Indexes & Statistics

    --Ramesh

  • January 12, 2009 at 6:28 am

    #925220

    Perhaps an obvious question but is the quantity of data the same on each DEV_SERVER as many organisations run different projects on different DEV servers resulting in completely different volumes of data on each?

    Regards,

    Simon

  • January 12, 2009 at 6:30 am

    #925221

    Some more points...

    I have tested the indexes and statistics...there is no difference between both servers and number of rows are almost same between the two server.

    karthik

  • January 12, 2009 at 7:16 am

    #925245

    karthikeyan (1/12/2009)

    Some more points...

    I have tested the indexes and statistics...there is no difference between both servers and number of rows are almost same between the two server.

    I meant last index/statistics update on the database....

    --Ramesh

  • January 12, 2009 at 7:23 am

    #925254

    yes..it was run 15 days back only ( in both server).

    karthik

  • January 12, 2009 at 7:35 am

    #925262

    Have you checked the execution plans? Can you attach those with the post?

    --Ramesh

  • January 12, 2009 at 7:55 am

    #925275

    One thing I run into with such problems is fragmentation.

    Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2

Viewing 9 posts - 1 through 8 (of 8 total)

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