July 7, 2009 at 1:39 pm
Hi,
We have a large website which used 185GB of Bandwidth last month. It has 2500 users constantly filling in large forms which use lots of controls on a daily basis. The site produces reports based upon data entered.
My client has a preferred supplier for hosting and they only provide SQL Server Express which I know only has 1CPU and 1GB of RAM, the site is hosted on a x32 Windows system but the host has given 8GB of RAM which obviously can't be used.
We are getting more & more users and the site is now recycling the App_Process at least twice a day, this seems to be triggered when a few users run reports which in terms of the views or stored procedures are quite complex. I ran a report a while ago and got a Server Error in '/' Application.
Exception of type 'System.OutOfMemoryException' was thrown.
We are fairly sure that the issue is down to having SQL Express and feel it can't now handle the pressure being placed upon it. We had no issues when we had less users.
Our client is beginning to understand this but we would just welcome some views so that we can be fairly sure this is the most likely scenario.
Thanks.
July 7, 2009 at 2:16 pm
You could try caching on the application layer or use regular SQL Server and look into hosting license which I think let you rent the CALs
Kind regards,
Gift Peddie
July 7, 2009 at 2:38 pm
I understand the whole preferred provider thing, but it shouldn't be a suicide pact.. You might see if the vendor would be interested in you co-locating a SQL Server in their environment or for them springing for even SQL Workgroup or Web, you could get 2-4 processors then. Also keep in mind in SQL 2008 is licensed per socket, not per logical processor.. ( http://msdn.microsoft.com/en-us/library/ms143760.aspx), and with workgroup you get 4GB of memory and Web you get OS MAX.. If you are a big customer I would be surprised if they weren't willing to work with you.
CEWII
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply