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 |
|
Harsharan
Starting Member
1 Post |
 Posted - 2009-04-16 : 07:33:54
|
| Hi, hope you can help.I've been looking at a customers poorly performing database (250GB+) and found a lot of fragmentation and low scan density.I've been running an INDEXFRAG for the last day and a half and it looks to have started improving performance.My question is regarding DBREINDEX...I've found some scripts on the web but they all reindex every index or I have to manually select the ones I want to do.Does anybody know of a way to reindex for example, the top 10% worst indexes based in scan density?The resaon for scan density is because I've read this should be above 90%, at this customer I have 138 indexes on the database where this value is between 20 and 89%. Doing this all in one go is going to take a very long time and lock users out of tables whilst running. So wondered if it were possible to run a scheduled job which does them in batches.Hope this makes sense.Thanks in advance for any advice. |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-17 : 17:29:23
|
| You could schedule it in the sql server agent. I would do them all in order, to prevent having to figure out which ones were the worst. |
 |
|
|
|
|
|
Reindexing top 10 worst indexes...