troubleshooting Question

How to improve the speed of a heavily fragmented table?

Avatar of ale1981
ale1981 asked on
DatabasesMicrosoft SQL Server
17 Comments1 Solution401 ViewsLast Modified:
We have a SQL 2000 database with several tables. During a day these tables have LOTS of SELECT / UPDATE / INSERT commands. Our system is beginning to be VERY slow so I thought i would investigate why this could be. After a bit of reading i researched into table indexes. Worryingly one of the most searched tables had this DBCC SHOWCONTIG info;

ScanDensity 99.898
LogicalFrag 99.9999
ExtentFrag 82.5969

This was AFTER i did a DBCC DBREINDEX on the table, any ideas on how i can improve this?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros