There is two ways to do the consolidation. The first is to take a
really
big chunk and make your SQL Server crawl and fail authentication while
its
working. This is how 2.2 worked and wasn't very nice. The other choice
is
to take smaller pieces and work on each one. Thats what 2.5 does. Its
much
more friendly on your SQL Server.
I'm guessing if you are seeing continual table scans, that you have some
out of date indexes/stats or you are missing some indexes. Check
instindx.sql
and see if you have the seven indexes on your calls table that it lists.
One missing index can change a query from 2 seconds to 2 hours, on a
large
table like the calls table.
> Most of it seems to be disk activity. The cpu never goes much over 10% usage
> and it never maxes out the memory either. But the whole time it's beating
> crap out of my disks.
What kind of disk subsystem does it have? SQL Server is really
disk-intense
for some operations, which don't suit well for IDE based disk
subsystems.
Typically a hardware RAID5 disk controller is recommended to handle the
IO. I rarely see SQL Servers that are CPU bound. Most are either
memory
or IO/Disk bound.
Also, double check your memory settings and make sure your giving SQL
all
you can. That should help on the IO processing some.
> How big is your tempdb? Also, since switching to SQL7 I have not figured out
> how to put tempdb in RAM like I did on SQL 6.5, is there a way to do that?
Its not an option in 7.0 They changed how the memory works and this is
wrapped up into the general memory settings now.
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart