Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Troubleshooting speed issues
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Troubleshooting speed issues

 Post Reply Post Reply
Author
ndamico View Drop Down
Groupie
Groupie
Avatar

Joined: 03 September 2003
Location: United States
Status: Offline
Points: 46
Post Options Post Options   Thanks (0) Thanks(0)   Quote ndamico Quote  Post ReplyReply Direct Link To This Post Topic: Troubleshooting speed issues
    Posted: 29 September 2004 at 12:27pm

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..

Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 29 September 2004 at 1:17pm
Run sp_configure in Query Analyzer and post results, this may show a mis-configuration on your server. Thus as you ongoing problem is the difference of 2 db's on one server you would have to analyze query costs, query performance etc. Compare the locks/connections between both databases; Run Profiler to see how much get's executet as opposed to 7.01, you may want to add 'ApplicationName=XXX' to your connectionstring so you can differentiate them better. besides that there are of course tools that can analyze your data, database etc. but they are generally very expensive
ApexSQL Audit ($599) from ApexSQL Software
NetworkSmart 2003 ($449) from LeadByte Software
Back to Top
ndamico View Drop Down
Groupie
Groupie
Avatar

Joined: 03 September 2003
Location: United States
Status: Offline
Points: 46
Post Options Post Options   Thanks (0) Thanks(0)   Quote ndamico Quote  Post ReplyReply Direct Link To This Post Posted: 29 September 2004 at 10:49pm

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

Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 30 September 2004 at 9:24am
looks pretty much like default. when you say that 7.9 is slower...what do the page calculation values say on the bottom of each version? Like page generated in xxx seconds. If they differ a lot we may be able to narrow down the bottleneck.
Back to Top
ndamico View Drop Down
Groupie
Groupie
Avatar

Joined: 03 September 2003
Location: United States
Status: Offline
Points: 46
Post Options Post Options   Thanks (0) Thanks(0)   Quote ndamico Quote  Post ReplyReply Direct Link To This Post Posted: 30 September 2004 at 2:56pm

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!

Back to Top
ctscott View Drop Down
Senior Member
Senior Member


Joined: 27 May 2003
Location: United States
Status: Offline
Points: 246
Post Options Post Options   Thanks (0) Thanks(0)   Quote ctscott Quote  Post ReplyReply Direct Link To This Post Posted: 30 September 2004 at 4:59pm
thinking you may have missed removing/not adding some code......the only true speed test would be for your 7.9 to be modded like your 7.01.
______________________
College Football Trivia
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.