6 reputation
1
bio website
location
age
visits member for 1 year, 10 months
seen 2 days ago

Oct
4
awarded  Student
Oct
4
comment SQL Server 2005 Memory Pressure
We've restarted our SQL Server and I asked that the maximum memory be lowered from 2GB to 1.5. We have some CLR code running on insert/update/delete for auditing purposes. I think what may have been happening is this ran outside the 2GB and once SQL Server used up the entire 2GB, there wasn't enough remaining memory in the system to run the CLR. Does that sound plausible?
Oct
4
comment SQL Server 2005 Memory Pressure
There is insufficient system memory to run this query.
Oct
3
asked SQL Server 2005 Memory Pressure