Re: Index statistics not updated ?
As Uri said, don't worry about small tables, and small is much larger than
100 pages.
More importantly, if your database doesn't have free space (which almost
none do since everyone takes default database settings which will leave just
1MEGABYTE of free space!!) then you can't really have successful defrag
operations in a lot of cases. Double the size of your database and see if a
rebuild works better. It will avoid sever external fragmentation also!
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"wpher56" <jstealque@xxxxxxxxxxx> wrote in message
news:OEzk745sKHA.4492@xxxxxxxxxxxxxxxxxxxxxxx
Hello
When querying the table sys.dm_db_index_physical_stats for information
about index fragmentation, I get a row concerning the indexid 1 of msdb
being about 60% fragmented. Well, I run a job to rebuild the index ... and
the query always shows 60% of fragmentation on the same index of msdb.
I tried to do a reorg index + update statistics, no chance, still 60%
fragmentation.
Note that this index on msdb is not a particular case: I have plenty of
other indexes that remain fragmented (at least if I believe
sys.dm_db_index_physical_stats) after rebuilding indexes.
What can I do now ?
Pierrot
.
Relevant Pages
- Re: Sudden growth of a table
... You could use DBCC SHOWCONTIG to confirm if you have a fragmentation issue. ... Is .NET important for a database professional? ... I have a SQL Server that has increased dramatically in size from 9GB to ... Remove unused space from data files (leave 10% free space after shrink) ...
(microsoft.public.sqlserver.server) - Re: SQL 2005 Index fragmentation
... How much free space do you have in the index? ... number and are not managing your database size proactively. ... thus it will still show fragmentation. ... run with the index rebuilds? ...
(microsoft.public.sqlserver.server) - Re: DBCC SHRINKFILE Taking Forever & GROWING Data File Instead of Shrinking It
... What is more reasonable would be the internal data and index fragmentation ... shrink your data file, only do so after a database reorganization, using ... Just make sure you have a good backup first and it> is a good idea to stop sql server before you attempt it. ... When you shrink the file sql server> moves any data that is near the end of the file to an open spot near the> beginning. ...
(microsoft.public.sqlserver.replication) - Re: DBCC SHRINKFILE Taking Forever & GROWING Data File Instead of Shrinking It
... What is more reasonable would be the internal data and index fragmentation ... shrink your data file, only do so after a database reorganization, using ... Just make sure you have a good backup first and it> is a good idea to stop sql server before you attempt it. ... When you shrink the file sql server> moves any data that is near the end of the file to an open spot near the> beginning. ...
(microsoft.public.sqlserver.server) - Re: DBCC SHRINKFILE Taking Forever & GROWING Data File Instead of Shrinking It
... What is more reasonable would be the internal data and index fragmentation ... shrink your data file, only do so after a database reorganization, using ... Just make sure you have a good backup first and it> is a good idea to stop sql server before you attempt it. ... When you shrink the file sql server> moves any data that is near the end of the file to an open spot near the> beginning. ...
(microsoft.public.sqlserver.tools) |
|
