micheal,

i've got them off now as i'm trying to turn off most everything i can to make it bearable..  the page that seems to have slowed down the most is default.asp..  it used to take anywhere from 0-10 seconds during the worst part of the day... now it can get over 60 seconds and timeout...

also in your previous post you mentioend 2 db's.. they are one in the same.. i had a second 7.9 when i was testing, but i converted my 7.01 to 7.9.. so when i "switch" back i just replace the old files and use the same db. 

thanks for offering some help!

i'll start with the server.. here is what you requested:

affinity mask -2147483648 2147483647 0 0
allow updates 0 1 0 0
awe enabled 0 1 0 0
c2 audit mode 0 1 0 0
cost threshold for parallelism 0 32767 5 5
Cross DB Ownership Chaining 0 1 0 0
cursor threshold -1 2147483647 -1 -1
default full-text language 0 2147483647 1033 1033
default language 0 9999 0 0
fill factor (%) 0 100 0 0
index create memory (KB) 704 2147483647 0 0
lightweight pooling 0 1 0 0
locks 5000 2147483647 0 0
max degree of parallelism 0 32 0 0
max server memory (MB) 4 2147483647 2147483647 2147483647
max text repl size (B) 0 2147483647 65536 65536
max worker threads 32 32767 255 255
media retention 0 365 0 0
min memory per query (KB) 512 2147483647 1024 1024
min server memory (MB) 0 2147483647 2560 2560
nested triggers 0 1 1 1
network packet size (B) 512 65536 4096 4096
open objects 0 2147483647 0 0
priority boost 0 1 0 0
query governor cost limit 0 2147483647 0 0
query wait (s) -1 2147483647 -1 -1
recovery interval (min) 0 32767 0 0
remote access 0 1 1 1
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 600 600
scan for startup procs 0 1 0 0
set working set size 0 1 0 0
show advanced options 0 1 1 1
two digit year cutoff 1753 9999 2049 2049
user connections 0 32767 0 0
user options 0 32767 0 0

description/minimum/maximum/config value/run value

I have been having major speed problem since migrating to WWF 7.9 from 7.01.  speed will improve greatly if i switch back to 7.01 so i know it isn't my servers.. plus they are dedicated.. 1 for IIS and 1 for SQL 2000.

What is the best tool to use to troubleshoot this problem?  Borg i understand you say it should be faster, but bottom line it isn't and i'd like to find out why so i can resolve it and continue to enjoy the improved security of 7.9.

as it is my 7.9 has less mods than my 7.01 and it still runs slower. 

so far i've turned off page statistics, teh fancy editor, forum statistics and that hasn't made any noticible difference.. i've even disabled the search founction for a while and it doesn't seem to impact it (i thought someone might have been running a search over and over again).  the sql server is dual processor so i would apprecaite any SQL server settings tips you guru's may have to offer..