Browse by Tags

Error: 'There is insufficient system memory to run this query' and 'Downgrading backup buffers from 960K to 64K"?

Published 28 March 8 4:31 AM | SSQA.net

Have you ever observed the error specified above? Do you need to worry for this issue, yes! First task to check what are the memory settings on SQL Server, by default they will be DYNAMIC and quite common that they might have set with MIN & MAX settings...

Filed under: sql server, memory, error, update statistics, buffers, memtoleave, downgrade, insufficient

SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.

Published 7 March 8 4:54 AM | SSQA.net

Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently...

Filed under: sql server, performance, memory, dmv, windows, 2000, 2005, awe, 64 bit, monitoring, worker threads, paging out, buffers, verison