July 11, 2008 at 4:32 am
Dear All,
In our Application we are facing SQL Server memory usage and CPU usage problem as it handles lakhs of data. We are updating data in different databases(7 DB's) using several windows services (say 14 Services). In this process SQL Server occupies memory more than 1GB. After completing the process also, it is not releasing the occupied memory. Is there any method for releasing the memory after the processing?
If anyone came across the problem please share with us and give a solution to resolve this?
[font="Arial"]Nothing is impossible with Hard Work[/font]:)
July 11, 2008 at 6:43 am
How much memory is on the server? How much is allocated to SQL? SQL grabs the allocated memory on startup and keeps it. It won't release it. How big are your databases? Seven databases and SQL server seems like a lot for 1GB of RAM (which isn't very much). Personally, I'd look to add more if funds permit it.
edit - And from my experience, you should set upper limits of RAM for SQL so it's doesn't starve the OS.
-- You can't be late until you show up.
July 11, 2008 at 8:03 am
right there with tosscrosby.
Check your SQL Server memory Settings.
Post the SQL info as requested by tosscrosby, then we can figure out the issue (if there is).
Do you see a performance issue with SQL Server?
Do you See Server Slow Down?
Can you check your Physical disk READ/WRITE/AVERAGE Transfer Rates.
how about SQL Server BUFFER CACHE HIT RATIO Value..?
All this info is require to, Get a Good picture of whats Going on in there.
Jaya : a Pointer, not everybody Undestands the terms as LAKH. Put this as hundren thousand or 100,000. 🙂
Maninder
www.dbanation.com
July 11, 2008 at 8:22 am
Actually I've googled lakh and knew what it meant. It's become fairly common on the web boards and, as our world grows smaller due to the internet, we should try a little harder to understand the differences in terminology. It's inevitable....:cool:
-- You can't be late until you show up.
July 11, 2008 at 8:23 am
I Agree 🙂
Maninder
www.dbanation.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply