Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We keep having a nagging problem with our SQL Server. I don't know what changed, but we started having out of memory errors every 3 weeks or so.

I thought I could locate something strange with DBCC MEMORYSTATUS, but I have to admit, I'm not very good at understanding the output (and we don't have a DBA on staff).

Could someone take a look at the output and tell me if there is anything odd? Are there any other things I need to look at? Thanks.

EDIT: Full output is here: DBCC MemoryStatus

Memory Manager                  KB 
------------------------------ --------------------
VM Reserved                    1805144
VM Committed                   1737792
AWE Allocated                  0
Reserved Memory                1024
Reserved Memory In Use         0

(5 row(s) affected)

Memory node Id = 0              KB 
------------------------------ --------------------
VM Reserved                    1800984
VM Committed                   1733784
AWE Allocated                  0
MultiPage Allocator            23528
SinglePage Allocator           43624

(5 row(s) affected)

MEMORYCLERK_SQLGENERAL (Total)                                    KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            3640
 MultiPage Allocator                                             3104

(7 row(s) affected)

MEMORYCLERK_SQLBUFFERPOOL (Total)                                 KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     1654624
 VM Committed                                                    1654624
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            0
 MultiPage Allocator                                             400

(7 row(s) affected)

MEMORYCLERK_SQLQUERYEXEC (Total)                                  KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_SQLOPTIMIZER (Total)                                  KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            2464
 MultiPage Allocator                                             72

(7 row(s) affected)

MEMORYCLERK_SQLUTILITIES (Total)                                  KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     120
 VM Committed                                                    120
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            592
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_SQLSTORENG (Total)                                    KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     8064
 VM Committed                                                    8064
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            4928
 MultiPage Allocator                                             512

(7 row(s) affected)

MEMORYCLERK_SQLCONNECTIONPOOL (Total)                             KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            616
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_SQLCLR (Total)                                        KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     102464
 VM Committed                                                    36208
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            1024
 MultiPage Allocator                                             5232

(7 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKER (Total)                              KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            216
 MultiPage Allocator                                             192

(7 row(s) affected)

MEMORYCLERK_SQLHTTP (Total)                                       KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_SNI (Total)                                           KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            96
 MultiPage Allocator                                             16

(7 row(s) affected)

MEMORYCLERK_FULLTEXT (Total)                                      KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            72
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_SQLXP (Total)                                         KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            16
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_BHF (Total)                                           KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            96
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_HOST (Total)                                          KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            24
 MultiPage Allocator                                             0

(7 row(s) affected)

MEMORYCLERK_SOSNODE (Total)                                       KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            14200
 MultiPage Allocator                                             13760

(7 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total)                     KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            24
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_OBJCP (Total)                                          KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_SQLCP (Total)                                          KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            56
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_PHDR (Total)                                           KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_XPROC (Total)                                          KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            16
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_TEMPTABLES (Total)                                     KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            16
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_NOTIF (Total)                                          KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            16
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_VIEWDEFINITIONS (Total)                                KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            16
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_XMLDBTYPE (Total)                                      KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_XMLDBELEMENT (Total)                                   KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_XMLDBATTRIBUTE (Total)                                 KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            8
 MultiPage Allocator                                             0

(7 row(s) affected)

CACHESTORE_STACKFRAMES (Total)                                    KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            0
 MultiPage Allocator                                             8

(7 row(s) affected)
share
    
do you have one instance of sql server, or do you have multiple instances on one box? –  JonH Oct 3 '12 at 15:43
    
One instance as far as I know –  Dan Oct 3 '12 at 15:44
    
I was going to say I we had similiar issues but we found our issue due to multiple instances on one server. Memory was not allocated properly to each instance. But yours might be a different issue. –  JonH Oct 3 '12 at 17:05
    
I found something about .NET applications that use a connection string with the default packet size of 8KB causing problems with the virtual address space. Our website was using the default. I've changed it, but I guess the only way I'd know if that's the problem is wait and see. –  Dan Oct 3 '12 at 17:32
    
What were the specific errors? –  Thomas Stringer Oct 4 '12 at 13:49
show 3 more comments

migration rejected from stackoverflow.com Sep 30 '13 at 22:09

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Max Vernon, Paul White, Mark Storey-Smith, bluefeet, RolandoMySQLDBA Sep 30 '13 at 22:09

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Paul White, Mark Storey-Smith, bluefeet, RolandoMySQLDBA
If this question can be reworded to fit the rules in the help center, please edit the question.