SQL Using 70% resources
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=17208
Printed Date: 15 April 2026 at 11:33pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Using 70% resources
Posted By: alehawk
Subject: SQL Using 70% resources
Date Posted: 10 November 2005 at 5:46pm
|
Hi!
I'm using the SQL version of the forum and my hosting provider called me to tell me that the forum is cosuming 70% of micro resources.
How can that be? Can that be fixed? Tnx!!!! |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 11 November 2005 at 4:35am
|
Any forum software puts allot of strain on the database, as it requires
allot of hits on the database getting data to and from the database. Web Wiz Forums is focused on performance and I am always looking at ways to improve performance, so as far as forum software goes, Web Wiz Forums isn't to bad. Has your host said why the forum is using 70% resources? It could be that everyone else using the SQL Server is only running small apps, and if you have a busy forum then yes you probably would be using more resources than the people who only have small databases on the server. Maybe it's time then to look for 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: baraddur
Date Posted: 11 November 2005 at 2:08pm
 wahat is a SQL server.I`m a Child.Can`t creating a web wiz forums.please help!
|
Posted By: dj air
Date Posted: 11 November 2005 at 2:54pm
|
SQL server is a Web Performance friendly on on the internet its a server that manages big databases, and as ist created for the internet/big databasess its better performance etc than access thats a flat file/desktop application |
Posted By: MadDog
Date Posted: 11 November 2005 at 5:59pm
|
Some web hosts do not release that SQL Server is actually designed to use up a certain amount of resources if the option to "Boost" its performance is on.
This means that SQL Server will and can use anywhere from 70%-90% of the servers resources at all times. If the computer needs more memory or CPU for something else, SQL Server will reduce its usuage. The reason for this is for database performance. If a website is getting zero visitors, then all the sudden jumps to 1000 visitors, SQL Server is ready to take that hit because its already using the resources it needs. If SQL Server is not setup to us many resources then if a website is getting a 1000 visitors at one time the website will become extremly slow because SQL Server can not keep up with the requests. But also keep in mind there is stuff coded by beginners that do not release the memory so that also could be a problem, but this is not the cause with WebWizForums. ------------- http://www.iportalx.net" rel="nofollow"> 
|