This page was generated in XX,XXX seconds
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29786
Printed Date: 01 April 2026 at 4:22am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: This page was generated in XX,XXX seconds
Posted By: AndreasE
Subject: This page was generated in XX,XXX seconds
Date Posted: 19 September 2011 at 11:05pm
|
Something has happened to the speed on my forum, it all started somewhere in mid-life of 9.xx and its still with me on the 10.3. Often Im loosing the connection to the SQL server 5 out of 10 times, and the rest 5 times results in "This page was generated in 24,719 seconds" or worse. My Web-host have tried to restart the MSQL server i few times without any positive result. Im pasting a few of the error msg I received and hope for a miracle  --------- Server Error in Forum Application An error has occurred while connecting to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_db_connection File Name:- database_connection.asp Error details:- Microsoft OLE DB Provider for SQL Server Timeout expired ------ Server Error in Forum Application An error has occurred while writing to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_getSessionData()_save_new_session_data File Name:- functions_session_data.asp Error details:- Microsoft OLE DB Provider for SQL Server Violation of PRIMARY KEY constraint 'tblSession$PrimaryKey'. Cannot insert duplicate key in object 'dbo.tblSession'. ------- Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.
Support Error Code:- err_SQLServer_db_connection
File Name:- database_connection.asp
Error details:-
Provider
Unspecified error -------- Best regards Andreas Eriksson |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 20 September 2011 at 9:43am
|
The problem is with your providers servers. Either their servers are overloaded or the network between database and web server has to higher latency. If your web host can not fix the performance issue then it's time to switch to a new host. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: WebWiz-Bruce
Date Posted: 20 September 2011 at 9:51am
|
If you have a look at the page below at the 'Live Production Forums' section there are some links to some of our customers Web Wiz Forums that are running on our own shared hosting that have over three quarters of a million posts, so that you can get an idea of how fast larger forums should be running using SQL Server:- http://www.webwiz.net/web-wiz-forums/forum-demo.htm" rel="nofollow - http://www.webwiz.net/web-wiz-forums/forum-demo.htm ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: AndreasE
Date Posted: 20 September 2011 at 9:56am
Thx Bruce, its as i expected but I just needed your words on it  Will try one last time with my host!
|
Posted By: yandr
Date Posted: 21 September 2011 at 9:34am
|
Bruce I appreciate your answer too, but I have to say that I am facing similar problems.
The first provider kicked me out claiming that my forum's traffic is not permitted on shared hosting. The second provider did the same thing and forced me to upgrade to a business package. Today I am facing similar difficulties and I am not sure who is to blame. When they fix the problem, the forum is extremely responsive. But the performance deteriorates after a few days and weeks to the point described by the first poster (query timeouts and other errors). For me this indicates a problem with the hosting company, but this is the second one in less than 12 months and a business package too. I wonder if there is a memory leack or a problem with connections left open somewhere. I am considering my options, but wish to ask you:
As you can understand with 300 active users the performance of the forum is a real concern for me. |
Posted By: WebWiz-Bruce
Date Posted: 21 September 2011 at 10:03am
|
Performance of Web Wiz Forums is not the issue as the forum is already had allot of work done on performance with server side paging, all database connections closed, and all objects released. The cost of running servers is very high, while the cost charged to customers for shared hosting is very low, so shared hosts have to pack as many websites on a server as they can. Typically most shared hosts will have over 1,000 websites per server. 300 active users in Web Wiz Forums translates to around 300 concurrent connections to your website. Whether it be just a basic website or a forum, 300 concurrent connections is allot for shared hosting. At these levels you would be reaching the limits of resources available for shared web hosting and so you would be getting performance issues. With our own shared hosting we typically place under 500 websites per server. Even with our low populated shared hosting at 300 concurrent connections to your website we would be asking you to either look at your own server or we setup one of our custom semi dedcated shared hosting package on a server with 10 or less websites to give your website enough resources to run. At the type of levels that you are talking about with 300 active forums users you have reached the limits of shared hosting and unfortunately would need to dig deep and pay out for a semi dedicated hosting package or your own server. If you would like us to put together a quote for hosting your busy website then http://www.webwiz.net/contact/contact-sales.htm" rel="nofollow - contact our sales department with some statistics and resources levels and will look at putting together a quote for either a custom semi dedicated package or your own server. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: yandr
Date Posted: 21 September 2011 at 10:54am
|
I will keep this in mind Bruce. I am definately looking into VPS hosting rather than dedicated servers, because the cost is significantly lower. Your post was very enlightening as I always wanted to know the 'limits' for shared hosting and decide that if I want my site to continue I will have to look into more expensive solution. Very greatful for that and I will probably contact the sales department to get a quote.
|
Posted By: yandr
Date Posted: 21 September 2011 at 1:10pm
|
By the way, I just wanted to add that 300 active users does not mean 300 connections to the database, since it is 300 active users the last 20 minutes! Personally I reduced it to 15 minutes and now it shows about 200-220 users online.
|
Posted By: WebWiz-Bruce
Date Posted: 21 September 2011 at 2:15pm
|
The 300 concurrent connections that I refer to is not database connections this is the number of simultaneous connections to your website. This number is based on Web Wiz Forums that we host for customers that have this number of active users in their forums. Each time someone looks at a page on your website quite a few connections will be made to the server to download the webpage, images on that web page, and any external JS or CSS files. Most of our own servers host between 300 and 500 websites and typically have around 200 and 400 concurrent connections across all these websites hosted on the shared server. So you can see one web site using 300 concurrent connections would be using the same number of resources as 300 to 500 websites. This means for a shared web host 1 website using 300 concurrent connections your website is using the same number of resources as 300 to 500 typically websites that are hosted on a shared server and so would be loosing money on your website and so will either ask for more money to host your website or throttle the amount of resources allocated to your website so they do not loose money on hosting your site. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: WebWiz-Bruce
Date Posted: 21 September 2011 at 2:25pm
|
We can also supply you Virtual Server hosting if you wish. When it comes to Virtual Server Hosting there are two types, VPS and VDS. The cheaper VPS is typically based on Virtuozzo where you share the OS with other customers and you just have a container on the shared OS. I have tried this and find it not very good as you have allot of performance issues and a rouge user could take down your own VPS. The slightly more expensive VDS hosting you get your own decated virtual server with it's own OS, diskspace, CPU, memory, etc. This is based on Hyper-V or VMare and works just like a dedicated server and gives you decent amount of resources and a rouge user on another VDS would not take down your own. The page below explains all this in more detail:- http://www.webwiz.net/virtual-servers/what-is-hyper-v-hosting.htm" rel="nofollow - http://www.webwiz.net/virtual-servers/what-is-hyper-v-hosting.htm ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: billd3
Date Posted: 22 September 2011 at 6:21pm
|
Nice part about VM servers is that if one server isn't using much for resources, the host can move resources to where they are needed. You can really run a minimum of memory and processors for each VM that way. We've got 20 servers at work, but we don't have 20 physical processors - when one server is sitting idle, another is using the resources the first might have had earlier. It's great way to use resources more efficiently. Our IIS servers, SharePoint and SQL are VMWare based, and we're attempting to put together a clustered SQL server under VMWare- it would be almost bullet-proof. ------------- BillD http://theamcpages.com http://theamcforum.com |
Posted By: WebWiz-Bruce
Date Posted: 22 September 2011 at 7:08pm
|
Were big fans here of Microsofts Hyper-v and are already using Clustering for Virtual Servers allowing Virtual Machines to be Live Migrated between Clustered Nodes when they need extra resources or we need to do some hardware maintenance. It also allows Virtual Machines to failover to another clustered node in the event of a hardware failure. Like you say clustering makes it almost bullet proof. Windows Server 8 will soon be here with Hyper-V 3 which will certainly give VMware a run for it's money as new features with it's virtual switches and improved monitoring look really promising. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |