First, did you go into the Admin, DB Maintence and run the calls
Update? If you don't, the consolidation will run really slow and
not actually do much.
Secondly, make sure you have indexes on your Satus, AccountID,
and ServerID fields (these are the fields the Update Calls option
in the admin modifies, and the primary fields of the consolidation.
Lastly, you might want to look at your indexesin SQLEW and see if
the statistics are up to date (right click over the calls table,
select indexes, choose each index and select the distribution button).
If the stats have not been updated recently, update them before
the consolidation. The latest checkdb.sql also includes a cursor
at the bottom that will update the stats on all your indexes. I
would recommend running it atleast once a week.
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html