SQL Server Performance

Table fragmentation, Index contention and locking issues to resolve

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jul 31, 2007.

  1. Anonymous New Member

    Yet another important factors that every DBA needs to concerned about table &amp; index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to updates and delets on the table and the golden rule is that to have relevant indexes for better performance. As you may aware that indexes involve both a maintenance cost and a read benefit, the overall index cost benefit can be determined by comparing...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/07/31/1197.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1197" width="1" height="1">

Share This Page