sp performance

  • I'd suggest breaking up your index rebuilds, only do a few at a time in small chunks. And don't swap the recovery model to bulk-logged. If you need to restore to a point in time, that could ruin your chances. Better to keep it at FULL.

    Otherwise, just make sure you have enough disk space. Don't be shrinking the log over and over. If it needs X amount of space, you'll need to supply X amount of space.

    "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

Viewing post 16 (of 15 total)

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