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.
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
saj |
|
|
|
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 |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
SQL Server 2008 fragmentation