I hope the format comes accross well, I moved some of the index fill factors to 95% for tbl_ccStatus, tbl_ccAssigned and tbl_ccNotes which are where most of the data resides...

Should...

Antares686,

I'm not sure I know how to play with the Fill Factors, they are all currently defaulted to 0%, I tried moving some to 95% but...

Andy,

Here are the counters you commented about. This system is not mission critical or a 24x7 server, but it serves as a backup to the call center...

Thanks Antares686 and Andy Warren for your prompt replies! The server does have 2 cpu's (XEON 800mhz IIRC). I ran both the sp_updatestats and DBCC UPDATEUSAGE, the reply...