July 14, 2010 at 11:24 am
Hi everyone,
I've been checking on the objects that are using the most memory on my servers and once in a while I see some system tables that have allocated 2-5GB of space in memory. Anyone know what these tables are and why they grow to such enormous size?
sysallocunits
syscolpars
sysobjvalues
July 14, 2010 at 11:26 am
They're tables related to the allocation structures of tables and indexes. Got a lot of tables?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 16, 2010 at 11:11 am
Sorry for the late response.
There are about 200 tables. Weird thing is that when I looked at the objects in memory, one of the sys* tables (forget which one) was 4GB and there were a handful of other user tables in memory along with a bunch of sys* tables. So, are you saying that even though there were only a few user tables in memory, it's normal for the sys* table to get so big?
July 16, 2010 at 11:32 am
How are you measuring memory usage?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply