I am curious if anybody has seen or had this proble before.
Starting today whenever I do anything to my local MSDE 2000 SP3 installmemory just gets eaten up on my machine until there is none left andthe machine starts crawling. I end up having to stop SQL Server andanything local that might have been using it to get control of mymachine back. As I speak I am looking at Task Manager on the the othermonitor and memory is just draining like there is no tomorrow. Andthere are no queries running right now. It happens when I try to runany SELECT, browse the local machine via Enterprise Manager, and alsowhen I have tried changing the width of a column. AFAIK it happens witheverything I have tried today. I am on SP3 so I am prettycurrent. I can't think of anything that has changed, and I am doingnothing except for some small time local Win32 development.
Any ideas would be appreciated. I'll keep looking around the Internet to see if I can find anything.
TIA
Hmmm, well you might check this KB article:INF: SQL Server Memory Usage. SQL Server will use whatever memory is available to it.
Showing posts with label installmemory. Show all posts
Showing posts with label installmemory. Show all posts
Subscribe to:
Posts (Atom)