February 22, 2007 at 8:12 am
My instance of SQL Server over a period of a few days seems to capture more and more of the servers resources (A couple gig of memory), basically slowing everything on the server down to a crawl until I restart the SQL Server Service Manager, which seems to clear it out and start the process over. I'm moving lot's of data in and out of using ADO.NET. Is this normal, and if not, anybody have any idea what might be causing it and/or how to resolve it without having to do a manual restart every few days?
February 22, 2007 at 9:48 am
Unless you specifically limit it, the SQL Server will take whatever memory it needs, up to and including everything the server has. If you have a lot of other things running alongside the server, you might get to the point where you're swapping yourself to death. Sounds like you might be there already.
Memory is a configuration option, so give it a quick read in BOL. You might have to do some experimentation to find the best mix of SQL Server vs OS memory.
February 22, 2007 at 9:58 am
Ah, thanks, that was just what I was looking for.
February 23, 2007 at 2:03 pm
Not sure what SP of 2005 you are on but check out the details of SP2. It has several bug fixes that correct issues with SQL taking more and more memory and causing slower and slower transaction times.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply