microsoft.public.sqlserver.programming

Gail Erickson [MS]

3/28/2007 1:08:00 AM

Hi Jodie,
Assuming your table has at least 1000 pages, then consider defragmenting the
index when fragmentation is greater than 20%. This execellent white paper
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2...
provides all the details you need.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/...

"Jodie" <Jodie@discussions.microsoft.com> wrote in message
news:CF14A9CC-4990-4A4D-A66F-920A3B7012BA@microsoft.com...
> Hi All,
> What is the optimize number of fragmentation to allow for table before
> we need to run the "DBCC INDEXDEFRAG" for the table to
> improve the performance,
> Thanks In Advance,
> JP