![]() ![]() dm_os_process_memory-select specific task you were doing when you got this error.Can you check errorlog and see if you can find memorystatus output there.If so please post that complete output on skydrive.Ī simple workaround would be to first put limit on max server memory in sp-configure.And make sure your SQL server service accoutn has locked pages in memory privilege.BTW how much physical RAM is there on the system.Is your SQL server patched to SP1 Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readersĬan you post DBCC MEMORYSTAUTUS output on skydrive or some shared location.Please let me have a look at that output before I comment.Please post output of below queries also select(physical_memory_in_use_kb/1024)Memory_usedby_Sqlserver_MB,(locked_page_allocations_kb/1024 )Locked_pages_used_Sqlserver_MB,(total_virtual_address_space_kb/1024 )Total_VAS_in_MB,process_physical_memory_low,process_virtual_memory_lowfrom sys. >I don't understand how something like this can happen, isn't that why SQL has a lazy writer - To free up pages in the buffer pool.?įor adhoc plans every time new plan needs to be created (almost every time) so this creates a load on cache and if lots of adhoc plans come there wont be enough memory to accomodate new one so in such case you can get OOM error Sp_configure 'optimize for ad hoc workloads',1Ĭached plans would also give good idea about the same so please also paste output of below select objtype, Two things you can do.Below I guess there are lot of adhoc queries hitting your database.And SQLCP is storage for such kinds of temporary plans. Total memory taken by Cached plans is 430 MB.I guess this could be the issue.also MEMORYSTATUS output was not complete. ![]() Thanks ,I basically wanted to know whether it was 32 bit or 64 bitīelow is screenshot of what i found from memorystatus dump CACHESTORE_OBJCP (node 0) KB -ĬACHESTORE_SQLCP (node 0) KB. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |