August 9, 2008 at 5:51 am
Hi
I am using SQL Server 2005 Workgroup with an IIS application on the same server. SQL Server is installed with all the default settings. I haven't changed anything. For example:
Memory usage = Dynamic (0 to 4 GB - Max RAM )
Max worker threads = 255
Database Auto Close = Off (unchecked)
etc.
The problem is that memory usage is growing time after time and reaches to almost 3 GB and even now when the application is not running on this server, my SQLSERVR.exe memory usage is stuck on that increased value. I must have to restart the SQL service to get it down.
Why is this happening ?
Please Help.
August 9, 2008 at 6:50 am
By its very nature, SQL Server does not share well, especially memory. If you need it to leave space for IIS, then you will need to limit SQL Servers maximum memory.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 10, 2008 at 5:07 pm
I would limit SQL Server, as Barry mentioned, though I'd make sure you at least give it 1-1.5GB at a minimum.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply