Post reply

Data Collection Set

  • August 27, 2011 at 2:33 am

    #242950

    I m enabled datacollection and then ı create trace data collection set after that days my rebuild index time is normaly about 1 hour

    but after enable datacollection it up to 3 hour is it effect performance.

  • August 27, 2011 at 4:52 am

    #1374215

    Data collection could affect performance. I've never seen it do that much to a system before though. Did you look at blocking processes or do you have a metrics of the time when the reindex job was running? What was causing it to run slow? Use the data collection information. That's what you set it up for.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • August 28, 2011 at 1:14 am

    #1374282

    In that time I changed data only data collection feature I look it job history.

Viewing 3 posts - 1 through 2 (of 2 total)

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