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 |
|
learntsql
524 Posts |
 Posted - 2009-12-16 : 00:04:33
|
| Hi..Today I created some indexes in my Production server what type of maintanance should i take on this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
learntsql
524 Posts |
Posted - 2009-12-16 : 00:57:47
|
| Thnaks Tara,Its the time to me to prepare a check list for index maintanance like1.Update Stats,Rebuild/ReOrganize Index,Drop unused index and things like these2.How frequent should i do all/some of these?Or even if more.TIA. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
learntsql
524 Posts |
Posted - 2009-12-16 : 23:34:31
|
| Should i blindly run rebuild index or any measurments do i follow?Any Script for rebuild index?.Any how i have to go through BOL once for better understand.TIA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2009-12-18 : 09:23:42
|
| May be your indexes can be maintain through reorganize, in such case why u want delete reorganize step it will take less time and less systems resources.You can maintain it by some calculation on sys.dm_db_index_physical_stats dmv, it is suggested that if your index is fragmented by less then 30 %, u can use reorganize else if it more than 30 % the u should use Rebuild index.RAQ Report: Web-based Excel-like Java reporting tool |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Index maintanance