March 14, 2016 at 2:01 pm
I have a sql server 2012 sp2. Dbcc checkDB job has been failing and getting the following error messages
There is insufficient system memory in resource pool 'internal' to run this query.
The server has 8 gb of memory. Task manager shows 68% of memory are in use. The max server memory is set to 6553 MB for the sql server. The highest wait stats is RESOURCE_SEMAPHORE.
I ran the following query
SELECT
(physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB,
(locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB,
(total_virtual_address_space_kb/1024) AS Total_VAS_in_MB,
process_physical_memory_low,
process_virtual_memory_low
FROM sys.dm_os_process_memory;
Memory_usedby_Sqlserver_MBLocked_pages_used_Sqlserver_MBTotal_VAS_in_MBprocess_physical_memory_lowprocess_virtual_memory_low
3530013421772710
It looks like sql server is not consuming the max server memory. Can anyone help please? Thanks.
March 14, 2016 at 7:02 pm
1) patch up. Some SIGNIFCANT fixes have been put out there for dbcc checkdb recently
2) search web for argenis Fernandez dbcc checkdb (and paul randal too) to find some good stuff on how to make checkdb better
3) how much database size are you trying to run on this little 8GB box?
4) what is your tempdb configuration?
5) do you have things like computed columns or other "esoteric" stuff in the database of concern?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 15, 2016 at 12:33 pm
Kevin, Thanks for your reply.
1) patch up. Some SIGNIFCANT fixes have been put out there for dbcc checkdb recently
This is not a new sql server. It has been running fine for over a year. All the sudden, the integrity check job failed.
2) search web for argenis Fernandez dbcc checkdb (and paul randal too) to find some good stuff on how to make checkdb better
3) how much database size are you trying to run on this little 8GB box?
The total size of the databases are about 6gb
4) what is your tempdb configuration?
tempdb and templog are in separated drives
5) do you have things like computed columns or other "esoteric" stuff in the database of concern?
there are no computed columns
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply