SQL Server Performance

Column reads vs Column writes in 2000

Discussion in 'Performance Tuning for DBAs' started by dchetwynd, Oct 1, 2008.

  1. dchetwynd New Member

    Hi,
    In my role we have a lot of Vendor applications that are extremely large and complex. Some of these are running slowly and if I was in 2005 I would query the Management views.
    I am particularly interested in how many times a column has been accessed (read) as opposed to how many times it has been written to, or the equivalent. sys.dm_db_index_usage_stats and others are of great help but I am not sure if they have an equivalent in 2000.
    Can anyone help?
    dchetwynd, Oct 1, 2008
    #2

  2. satya Moderator

    When was the last time you performed the REINDEX of these tables?
    satya, Oct 2, 2008
    #3

  3. dchetwynd New Member

    I have checked fragmentation but this is not a problem. So I performed the REINDEX about 3 months ago.
    dchetwynd, Oct 2, 2008
    #4

Share This Page