finding long result times from 2 MSSQL servers

E

Emagine

Perch
Staff member
Hi guys,

is there any problems with MSSQL1 and 4

Web Wiz Forum (on the actual site) times out, does actions like post a messahge but times out afterwards, takes a few seconds to 15 to render some pages when usually about 1 - 2

also on MSSQL4 pages that ussually take around 1 second are taking 15.

nothing has changed on them and WWG not being mine anyway.

just wondered if anyone has seen any problems/ lagging or is it my connection but still the rendering shouldn't take time. as they are rendered then sent
 
No, I do not think this is DB related. What I assume you are saying is that sometime while posting on www.webwizguide.info (hosted on sql1), the page may timeout or load in 10 or 15 seconds.

I have this issue time to time posting on many forums including this forum and web hosting forums. For me, I am certain its ISP related.

WWG prints the processing time at the end of the page. That will be the actual time it took the server to render the page. The time that it takes after that for your site to load will depend on your connection with the server, which is something we can't control.

However, if you are getting frequent high processing times, that would be an issue. Report it to us in a ticket. If you are getting high processing times, but rarely, then it's something you can expect in a shared hosting environment which we do try to minimize though
 
i'll submit a ticket about it then

because 8 times out of 10 (not 9 lol)

Web wiz Guides forum for me times out, takes up to 20 seconds to render.

nearly every time i visit it.

and the other one i know there is an issue between Win8 and MSSSQL 4, and i get rendering times of 6 seconds at present, when its ussually under a second.

but Web wiz guides forum (its self) has been playing up for me .. for about 3 - 7 days now.

i'll submit a ticket on this . so it can be checked out.
 
Well, there is definately an issue with your connection then. A traceroute would be nice

I can browse the webwizguide site as well as some old mssql1-win5 forums perfectly without issues. Getting processing times around 1 second

Bruce @ WWG is normally pretty fast in letting me know if his site is slow or is having issues

As far as MSSQL4 - Win8 goes. I'd be surprised if there is any lag considering MSSQL4 is no where close to fully loaded and is performing very well

Submit a ticket, we'll monitor
 
heres a tracert

Hop Time 1 Time 2 Time 3 IP Hostname Return TTL Country Time
1 2 ms 5 ms 4 ms 206.196.11.254 [www.DNSstuff.com 1st hop] 64 United States
2 3 ms 7 ms 6 ms 216.26.129.91 core-rtr02.ge-1-3-0.sdf.xodiax.net. 252 United States Unix: 16:32:41.441
3 8 ms 2 ms 6 ms 216.26.129.91 core-rtr02.ge-1-3-0.sdf.xodiax.net. 252 United States Unix: 16:32:41.449
4 466 ms 471 ms 470 ms 216.26.128.229 edge-rtr01.ge-0-2-0.sdf.xodiax.net. 252 United States
5 5 ms 9 ms 8 ms 12.118.180.9 [Missing reverse DNS entry] 252 United States Unix: 16:32:42. 40
6 23 ms 28 ms 27 ms 12.123.210.26 tbr2-p013902.cgcil.ip.att.net. 250 United States
7 87 ms 97 ms 106 ms 12.123.6.37 ggr2-p390.cgcil.ip.att.net. 250 United States
8 39 ms 56 ms 58 ms 4.68.127.165 [Missing reverse DNS entry] 242 United States Unix: 16:32:42.249
9 * * *
10 118 ms 88 ms 137 ms 64.159.0.1 as-1-0.mp1.Miami1.Level3.net. 241 United States
11 109 ms 119 ms 128 ms 64.159.1.162 unknown.Level3.net. 241 United States
12 79 ms 89 ms 97 ms 64.156.220.241 reverse241.acceleratebiz.com.
[Reached Destination] 113 United States Microsoft: 16:40:19.937

not sure if that what you mean .

with regards to MSSQL4 and Win8

there has been some issues on Win8 and MSSQL4 that stephen said is a Win8 issue that is returning a server or access denied error when connecting to MSSQL4

the ticket is FJT-41974-177 if you want more details.

i'm doing a full system check with spyware ad ware and virus checks. im always up to brim with security lol. i think it maybe something to do with my connection as i have MSN troubles very bad.. can't stay on for more than 5 mins sometimes
 
I am fully aware of the SQL denied issue. That is a Win2003 bug resolved in SP1. We plan to upgrade to SP1 as soon as HSphere officially supports it. However, a majority of the sites are unaffected with that issue and those that are, we have solutions worked out

However, this issue would not make the processing time slower.

If you are having issues with MSN as well, might be due to packet loss?
 
You must log in or register to reply here.
Back
Top