ÿþ<html><head><meta content="text/html; charset=utf-8" http-equiv=content-type><meta name="virtualDBA" content="ver 3.1.5"><title>virtualDBA | System Profile - Memory</title><style type="text/css"><!--a {text-decoration: none;}a:link {COLOR: black;}a:visited {COLOR: black;}.titlerow, .titlerow td{text-align:left;font-family:arial;vertical-align:top;background-color:#6699CC;color:#000000;}.datarow, .datarow td{text-align:left;font-family:arial;vertical-align:top;background-color:#FFFFFF;color:#000000;}--></style></head><body><br><font face="arial"><b><font color="grey">reports.</font>virtualDBA</b><br><br><br><img src="http://static.virtualdba.ca/img/png/samp_logo.png"/><br><br></font><table border=2 cellpadding="5" cellspacing="0" bordercolorlight="#cccccc" bordercolordark="#999999"><tr><td class="titlerow" width="150">Title:</td><td class="datarow" width="500">System Profile - Memory</td></tr><tr><td class="titlerow" width="150">Description:</td><td class="datarow" width="500">System Profile - Memory</td></tr></table><br><font face="arial"><table border=2 cellpadding="5" cellspacing="0" bordercolorlight="#cccccc" bordercolordark="#999999"><tr class="titlerow"><td>type</td><td>name</td><td>avg_pages_kb</td><td>max_pages_kb</td><td>avg_virtual_reserved_kb</td><td>max_virtual_reserved_kb</td><td>avg_virtual_committed_kb</td><td>max_virtual_committed_kb</td></tr><tr class="datarow"><td>USERSTORE_TOKENPERM</td><td>TokenAndPermUserStore</td><td>874</td><td>3104</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_SXC</td><td>sxcCacheStore</td><td>246</td><td>1008</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_SCHEMAMGR</td><td>SchemaMgr Store</td><td>19439</td><td>33016</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - virtualDBA</td><td>44</td><td>72</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - controlctr</td><td>44</td><td>72</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - tempdb</td><td>44</td><td>72</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - maindb</td><td>45</td><td>80</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - mssqlsystemresource</td><td>44</td><td>72</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - test1</td><td>40</td><td>40</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - temp2</td><td>40</td><td>40</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - cntrlDB</td><td>51</td><td>72</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - reportingDB</td><td>40</td><td>40</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - metricsdb</td><td>72</td><td>72</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - mydb1</td><td>40</td><td>40</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - temp</td><td>40</td><td>40</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - tempresource1</td><td>40</td><td>40</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - tinydb</td><td>72</td><td>72</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - migratedb</td><td>44</td><td>72</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - master</td><td>44</td><td>72</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - model</td><td>44</td><td>72</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_OBJPERM</td><td>ObjPerm - msdb</td><td>44</td><td>72</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>tempdb</td><td>386</td><td>768</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>temp2</td><td>156</td><td>584</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>maindb</td><td>874</td><td>1088</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>tinydb</td><td>156</td><td>248</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>virtualDBA</td><td>1664</td><td>1864</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>tempresource1</td><td>173</td><td>624</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>master</td><td>305</td><td>344</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>metricsdb</td><td>221</td><td>312</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>msdb</td><td>1387</td><td>1544</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>migratedb</td><td>122</td><td>616</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>model</td><td>203</td><td>232</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>controlctr</td><td>221</td><td>256</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>cntrlDB</td><td>258</td><td>328</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>temp</td><td>156</td><td>584</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>mssqlsystemresource</td><td>4959</td><td>5632</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>mydb1</td><td>192</td><td>640</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>reportingDB</td><td>166</td><td>728</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>USERSTORE_DBMETADATA</td><td>test1</td><td>77</td><td>256</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SNI_PACKET</td><td>SNIPacket</td><td>2664</td><td>18016</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker rollback handler task object pool</td><td>16</td><td>16</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker send messages</td><td>29</td><td>248</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker transport send blocks</td><td>16</td><td>16</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker transport dialog messages</td><td>24</td><td>24</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker transport received blocks</td><td>16</td><td>16</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker task local storage object pool</td><td>16</td><td>16</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker transmission transaction data</td><td>22</td><td>32</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker transport forwarded messages</td><td>24</td><td>24</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker endpoint connect tasks</td><td>16</td><td>16</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Database Mirroring messages</td><td>16</td><td>16</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker received messages</td><td>16</td><td>16</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker rollback handler vlr object pool</td><td>16</td><td>16</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker dialog timer events</td><td>195</td><td>1952</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_SERVICE_BROKER</td><td>Broker transmission transaction element</td><td>261</td><td>3024</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_LOCK_MANAGER</td><td>Lock Manager : Node 0</td><td>5160</td><td>41880</td><td>65536</td><td>65536</td><td>65536</td><td>65536</td></tr><tr class="datarow"><td>OBJECTSTORE_LOCK_MANAGER</td><td>Lock Manager : DAC Node</td><td>24</td><td>24</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_LOCK_MANAGER</td><td>Lock Manager : Node 1</td><td>7271</td><td>41336</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>OBJECTSTORE_LBSS</td><td>LbssCache</td><td>1232</td><td>4008</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLXP</td><td>Default</td><td>16</td><td>16</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLXML</td><td>Default</td><td>0</td><td>112</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLUTILITIES</td><td>Default</td><td>141</td><td>2192</td><td>150</td><td>5368</td><td>150</td><td>5368</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLSTORENG</td><td>Default</td><td>17040</td><td>22056</td><td>8306</td><td>29696</td><td>8306</td><td>29696</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLSOAPSESSIONSTORE</td><td>Default</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLSOAP</td><td>Default</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLSERVICEBROKERTRANSPORT</td><td>Service Broker Transport</td><td>48</td><td>48</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLSERVICEBROKER</td><td>Default</td><td>756</td><td>2240</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLQUERYPLAN</td><td>Default</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLQUERYEXEC</td><td>Default</td><td>674</td><td>2888</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLQUERYCOMPILE</td><td>Default</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLQERESERVATIONS</td><td>Default</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLOPTIMIZER</td><td>Default</td><td>1455</td><td>8032</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLHTTP</td><td>Default</td><td>8</td><td>8</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLGENERAL</td><td>Default</td><td>52729</td><td>70344</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLCONNECTIONPOOL</td><td>Default</td><td>841</td><td>2296</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLCLRASSEMBLY</td><td>Default</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLCLR</td><td>Default</td><td>8</td><td>8</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SQLBUFFERPOOL</td><td>Default</td><td>16</td><td>16</td><td>16809984</td><td>16809984</td><td>13095614</td><td>14807816</td></tr><tr class="datarow"><td>MEMORYCLERK_SOSNODE</td><td>SOS_Node</td><td>79446</td><td>144024</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_SNI</td><td>Default</td><td>148</td><td>272</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_QSRANGEPREFETCH</td><td>Default</td><td>6</td><td>640</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_HOST</td><td>MSDART</td><td>143</td><td>240</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_HOST</td><td>SNI</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_FULLTEXT_SHMEM</td><td>Full-text IG</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_FULLTEXT</td><td>Default</td><td>757</td><td>1536</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>MEMORYCLERK_BHF</td><td>Default</td><td>121</td><td>864</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_XPROC</td><td>Extended Stored Procedures</td><td>158</td><td>240</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_XMLDBTYPE</td><td>XMLDBCACHE</td><td>15</td><td>16</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_XMLDBELEMENT</td><td>XMLDBCACHE</td><td>8</td><td>8</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_XMLDBATTRIBUTE</td><td>XMLDBCACHE</td><td>8</td><td>8</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_VIEWDEFINITIONS</td><td>View Definition Cache</td><td>87</td><td>176</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_TEMPTABLES</td><td>Temporary Tables & Table Variables</td><td>106</td><td>184</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_SYSTEMROWSET</td><td>SystemRowsetStore</td><td>2891</td><td>3824</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_STACKFRAMES</td><td>SOS_StackFramesStore</td><td>24</td><td>24</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_SQLCP</td><td>SQL Plans</td><td>3227392</td><td>3557936</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_PHDR</td><td>Bound Trees</td><td>43756</td><td>77152</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_OBJCP</td><td>Object Plans</td><td>126225</td><td>178592</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_NOTIF</td><td>Notification Store</td><td>143</td><td>1728</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_EVENTS</td><td>EventNotificationCache</td><td>16</td><td>16</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_BROKERUSERCERTLOOKUP</td><td>Service Broker user certificates lookup result cache</td><td>8</td><td>8</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_BROKERTO</td><td>Service Broker Transmission Object Cache</td><td>672</td><td>7984</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_BROKERTBLACS</td><td>Broker dormant rowsets</td><td>2467</td><td>9040</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_BROKERRSB</td><td>Service Broker Null Remote Service Binding Cache</td><td>902</td><td>4264</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_BROKERREADONLY</td><td>Service broker dialog cache</td><td>4812</td><td>32568</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_BROKERREADONLY</td><td>Service broker routing cache</td><td>763</td><td>4032</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_BROKERREADONLY</td><td>Service broker mapping table</td><td>898</td><td>4480</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_BROKERREADONLY</td><td>Service broker configuration</td><td>8</td><td>8</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_BROKERKEK</td><td>Service Broker Key Exchange Key Cache</td><td>8</td><td>8</td><td>0</td><td>0</td><td>0</td><td>0</td></tr><tr class="datarow"><td>CACHESTORE_BROKERDSH</td><td>Service Broker Dialog Security Header Cache</td><td>8</td><td>8</td><td>0</td><td>0</td><td>0</td><td>0</td></tr></table></font></font><br><font size="1">2010-01-23 07:22:41.700<br><br><img src="http://www.virtualdba.ca/favicon.ico" /><a href="http://www.virtualdba.ca/">virtualDBA &copy; 2006, All Rights Reserved</a></font><br><br></body></html>