in

Database Index Rebuild On MSSQL05

Last post 01-25-2008 4:13 PM by skozyuk. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 01-25-2008 4:13 PM

    • skozyuk
    • Top 10 Contributor
    • Joined on 10-28-2007
    • Westlake, OH
    • Posts 152
    • Points 819

    Database Index Rebuild On MSSQL05

    We have detected a high level of index fragmentation on a significant number of databases hosted on mssql05.ihostasp.net database server. Fragmented table indexes cause poor query performance and increase disk and CPU IO which further degrades server performance. As the result, we are executing index rebuild script on all databases located on this server. The rebuild process will run approximately 12 to 14 hours and may cause temporary table locks and/or query delays.

     

    • Post Points: 0
Page 1 of 1 (1 items)
2004 - 2008 IHOST, LLC