Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server 2008 fragmentation

Author  Topic 

sayed_anjum
Starting Member

3 Posts

Posted - 2014-03-31 : 04:34:13
Dear All.
I am doing defragmentation on sql server 2008 R2 (Standard edition).
But it is not taking effect. The level of fragmentation is as high as 50%. Even i tried from SSMS by doing padding and with different combination.Even there is no issue of foreign key as all index are primary key only .
Kindly help me.


saj

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-03-31 : 13:11:42
Some indexes can't be defragmented due to the number of pages. How many pages are in these indexes? How many rows?

I suspect you are talking about a table with less than a few thousand rows.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

sayed_anjum
Starting Member

3 Posts

Posted - 2014-04-01 : 01:42:06
quote:
Originally posted by tkizer

Some indexes can't be defragmented due to the number of pages. How many pages are in these indexes? How many rows?

I suspect you are talking about a table with less than a few thousand rows.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/



saj
Go to Top of Page

sayed_anjum
Starting Member

3 Posts

Posted - 2014-04-01 : 01:53:06
dear friend.
thanks for ur valuable help.
yes i thinks u are correct.
The row count of the table is 250;pages=2;partitionid=1;maximium row size=33; page fullness=54% fragmentation=50%;
I am trying to give the page fullness=90% it is not taking.whatever i do the result is same page fullness=54% fragmentation=50%; ????

warm Regards.

saj
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-04-02 : 14:20:58
You can ignore that table. Don't bother defragmenting it as it's not possible.

I recommend page fullness be 100/0 in most cases due to performance testing that we conducted. The performance improvement with inserts was greatly discounted by the huge performance degradation of selects. Your mileage may vary though!

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -