November 3, 2009 at 9:38 pm
Hi,
I have got insufficient memory error when I open the Schema change History report from the Object explorer in Management studio. We have 4 GB RAM and Max Memory is set to 2 GB. Its a SQL Server 2005 Developer edition 32 bit server with SP3.
Are these standard reports(from object explorer in Management studio ) Memory intensive?
Can we run these reports or not? Because in another server which has 16 GB Memory also got the same Memory issue.
From error log(posting first few lines)
2009-11-03 20:22:13.07 spid78 Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 524288
2009-11-03 20:22:13.08 spid78
Memory Manager
VM Reserved = 1960584 KB
VM Committed = 1933024 KB
AWE Allocated = 0 KB
Reserved Memory = 1024 KB
Reserved Memory In Use = 0 KB
thanks for your help
December 6, 2009 at 4:07 pm
Could you please advice me on viewing these standard reports from management studio? because when ever I open this reports, I'm getting Memory issues, seeing low virtual memory message in event viewer.
December 6, 2009 at 6:13 pm
Is that the entire error from the log? I had a similar issue happen with an SCCM instance lately. It came down to a CLR function that was running out of memory on a 32-bit box that had 16GB of RAM with AWE enabled and SQL set to use 8GB. The problem is that we were running 32-bit SQL, which is less efficient in it memory management, and although SQL was set to use 8GB, most of that went only to the buffer cache.
If you are running 32-bit SQL, try setting the -g startup parameter and set it to something like 512 or 1024. Otherwise it will only take the standard 256MB for external processes.
Joie Andrew
"Since 1982"
December 6, 2009 at 10:56 pm
Mani-584606 (12/6/2009)
Could you please advice me on viewing these standard reports from management studio? because when ever I open this reports, I'm getting Memory issues, seeing low virtual memory message in event viewer.
try to get the query the report uses and run it in ssms...post your findings....
Regards,
[font="Verdana"]Sqlfrenzy[/font]
December 7, 2009 at 3:34 am
What is the process (spid78) doing? Can you please paste the query plan for the process if getting hold of the complete SQL?
December 7, 2009 at 4:33 am
SQL Server is trying to allocate memory but for reason it can't. Now I'd say that given that it says that it's reserved 1.8 GB or so of VAS, and has committed about 1.6 GB or so of it, it may be that it's trying to free up space from one memory pool but it's having issues doing so.
Can you see what's running in the cache?
I'd be curious to see what are the sizes of the various the memory pools.
Can you run:
select name, type,
(single_pages_kb + multi_pages_kb) as sumPages,
(single_pages_in_use_kb + multi_pages_in_use_kb) as pagesInUse,
entries_count, entries_in_use_count
from sys.dm_os_memory_cache_counters
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply