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 |
|
Blin
Starting Member
36 Posts |
 Posted - 2007-04-25 : 14:26:06
|
| I'd like to know if anyone know any good scripts to automatically analyze fragmentation and reindex for all databases in an instance?Thank you.Ben |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-25 : 14:41:19
|
| I do have isp_DBCC_DBREINDEX, however it does not check fragmentation levels. isp_ALTER_INDEX does check fragmentation levels but it works on 2005 only.My database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspxI can't find my bookmark of a 2000 script that does check fragmentation levels. I must've deleted it a little while ago since we barely have any 2000 database servers out there anymore. I know it was posted here and on sql-server-performance.com as well. Perhaps you can search for it.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Kristen
Test
22859 Posts |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
|
|
|
|
|
Scripts for frag analysis and reindex