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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment