cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
467
Views
0
Helpful
1
Replies

MS SQL Server Maintenance

mknepper
Level 1
Level 1

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

1 Reply 1

Gergely Szabo
VIP Alumni
VIP Alumni

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.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: