Post reply

Performance Tuning Indexes

  • January 15, 2007 at 2:46 pm

    #683361

    I added server trace option under Query Analyzer and the values for "reads" is higher in the production server by 200.

    I checked the disk activity in production and there is none. Almost seems like something is holding up in production.

    I was wondering what this higher "read" number means.

    Thanks.

    -W R

  • January 16, 2007 at 4:05 am

    #683422

    If means that on your production server the query is reading more data pages, either from memory or disk, than on the dev server.

    There shouldn't be much disk activity on a well-running sql server. The majority of the 'reads' should be from the data buffer.

    Is the data on the two the same? If the prod server has much more data, that's a good and valid reason for it to have higher IOs. If not, you'll have to check the execution plan of the query in dev and prod to see where the difference is.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 16 through 16 (of 16 total)

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