75,730
I was called in to look at a GP database because users noticed a slowdown in performance.
Upon running dm_db_index_physical_stats on the company databases I found over 160 tables where the avg_fragmentation_in_percent is over 95%. Just about every transaction table plus most of the historical transaction tables were like this.The SOP tables were near 100%.
What have others used to reduce this type of index fragmentation on a GP database?
*This post is locked for comments
I agree, but over three years later I find this.
This is very good topic to disucss
We should discuss this like a senate debate and share our experiences and have general recommanded policy as best practices.
There are lot of confusions floating around while there is still no guidelines set to follow.
I will also suggest that MS should also outline some recommondations to help the community for the future
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (