Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Indexes not rebuilding

Status
Not open for further replies.

mebenz

IS-IT--Management
Jun 7, 2007
88
CA
I run the database maintenance to rebuild on all indexes once a week on all our databases. One database is running extremely slow. I ran the showcontig on a main table and get this result
- Extent Scan Fragmentation ...................: 84.76%

I have tried running ReindexDatabase as well, but nothing is fixing the slowness.

Is there any reason why they are not rebuilding?
 
Do that table have a PK?

- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top