September 14, 2006 at 12:10 pm
Hi,
Every time I check the task manager processes on our web server, the memory usage for sqlservr.exe process is always the maximum. Its anywhere from 100,000 kb to 230,000 kb. Is this the normal usage level? If not, what should I check for?
Sql server is on the same machine as the iis server. The website is medium sized, moderate traffic, less then 50,000 users.
Thanks.
September 14, 2006 at 12:17 pm
SQL will take as much memory as it needs, up to certain limits which can be controlled by boot.ini switches, AWE settings, and Memory settings in SQL Server properties.
In most cases it best just to let SQL, IIS, and your OS dynamically determine what they want to use. Are you having any issues?
September 14, 2006 at 3:00 pm
I get timeout expired error once in a while from random stored procedures. Its been happening for a long time now. Could not figure out whats causing it.
September 15, 2006 at 2:26 am
It means that your stored procedures are taking too long to execute.
The connection from the web server has a timout set in it, if the server doesn't return results in that time, the web page times out and returns an error. It could be related to poorly running queries, insufficient hardware, intermittant large load, etc.
You can either increase the timeout in the we page, or you can try and get your procedures to run quicker.
You can try and run the stored procs from query analyser to see how long they take to run.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 15, 2006 at 3:14 am
We had this happen to one of our server once, and we found out that the Log file was full, and could not autogrow.
So, check that as well.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply