SQL Using 70% resources

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
alehawk Members Profile Find Members Posts Newbie Joined: 04 September 2002 Location: Argentina Status: Offline Points: 19	Post Options Post Reply Quote alehawk Report Post Thanks(0) Quote Reply Topic: SQL Using 70% resources 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!!!!

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

baraddur Members Profile Find Members Posts Newbie Joined: 02 November 2005 Location: Turkey Status: Offline Points: 4	Post Options Post Reply Quote baraddur Report Post Thanks(0) Quote Reply 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!

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply 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

MadDog Members Profile Find Members Posts Mod Builder Group Joined: 01 January 2002 Status: Offline Points: 3008	Post Options Post Reply Quote MadDog Report Post Thanks(0) Quote Reply 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.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum