MS SQL Server Maintenance

[mknepper]

My client has MS SQL database administrators that are highly recommending doing a periodic reindex as they are seeing a high level of fragmentation. I am unable to find any documents on proper MS SQL Server maintenance from Cisco. In the absence of recommendations from "the vendor" (as the DBA puts it) should we apply generally accepted maitenance procedures for MS SQL? Should we set our log files to Autogrow as they are currently set to none?

Thanks,

Mark

[Gergely Szabo]

Hi,

since MS SQL Server is not used in UCCX anymore, I assume you are talking about Cisco ICM.

It has already a system implemented that periodically checks the size of tables and removes old data according to the schedule.

I don't really see the meaning of index "defragmentation", as data is written sequentially to the historical tables. You can rebuild the index of the configuration tables, if, for instance, agents are added and removed frequently.

G.