ÿþ<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 - Performance</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="140">Title:</td><td class="datarow" width="500">System Profile - Performance</td></tr><tr><td class="titlerow" width="140">Description:</td><td class="datarow" width="500">System Profile - Performance</td></tr></table><br><font face="arial"><table border=2 cellpadding="5" cellspacing="0" bordercolorlight="#cccccc" bordercolordark="#999999"><tr class="titlerow"><td>object_name</td><td>counter_name</td><td>instance_name</td><td>last_sample_value</td><td>avg_sample_value</td><td>max_sample_value</td><td>sample_count</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Access Methods</td><td>Full Scans/sec</td><td>&nbsp</td><td>146</td><td>81</td><td>673</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Access Methods</td><td>Page Splits/sec</td><td>&nbsp</td><td>193</td><td>186</td><td>7859</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Buffer Manager</td><td>Buffer cache hit ratio</td><td>&nbsp</td><td>5716</td><td>3170</td><td>7776</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Buffer Manager</td><td>Buffer cache hit ratio base</td><td>&nbsp</td><td>5774</td><td>3174</td><td>7734</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Buffer Manager</td><td>Lazy writes/sec</td><td>&nbsp</td><td>0</td><td>0</td><td>6</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Buffer Manager</td><td>Page life expectancy</td><td>&nbsp</td><td>13711</td><td>748145</td><td>1633573</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Buffer Manager</td><td>Page lookups/sec</td><td>&nbsp</td><td>170736</td><td>174646</td><td>1895030</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Buffer Manager</td><td>Page reads/sec</td><td>&nbsp</td><td>1</td><td>10</td><td>1161</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Buffer Manager</td><td>Page writes/sec</td><td>&nbsp</td><td>14</td><td>137</td><td>4460</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>_Total</td><td>741</td><td>145</td><td>1813</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>master</td><td>109</td><td>95</td><td>793</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>model</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>msdb</td><td>0</td><td>0</td><td>10</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>mssqlsystemresource</td><td>0</td><td>0</td><td>3</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>imagehub</td><td>0</td><td>0</td><td>1</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>onlinewhs</td><td>0</td><td>0</td><td>13</td><td>17978</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>newsmedia</td><td>0</td><td>1</td><td>7</td><td>10366</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>coretrade</td><td>78</td><td>13</td><td>143</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>bigretailer</td><td>0</td><td>0</td><td>0</td><td>10366</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>support_db</td><td>0</td><td>0</td><td>1</td><td>10366</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>support_db7</td><td>0</td><td>0</td><td>1</td><td>10366</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>tinydb</td><td>0</td><td>0</td><td>1</td><td>10366</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>tempdb</td><td>101</td><td>40</td><td>1700</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>virtualDBA</td><td>0</td><td>0</td><td>147</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Databases</td><td>Transactions/sec</td><td>datamig</td><td>0</td><td>0</td><td>73</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:General Statistics</td><td>Active TempDB Tables</td><td>&nbsp</td><td>700</td><td>171</td><td>730</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:General Statistics</td><td>Logins/sec</td><td>&nbsp</td><td>109</td><td>95</td><td>797</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:General Statistics</td><td>Logouts/sec</td><td>&nbsp</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:General Statistics</td><td>User Connections</td><td>&nbsp</td><td>45</td><td>37</td><td>161</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Latches</td><td>Latch Waits/sec</td><td>&nbsp</td><td>171</td><td>64</td><td>7447</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>_Total</td><td>0</td><td>13</td><td>9759</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>AllocUnit</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>Application</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>Database</td><td>0</td><td>0</td><td>413</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>Extent</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>File</td><td>0</td><td>0</td><td>4</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>HoBT</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>Key</td><td>0</td><td>1</td><td>7455</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>Metadata</td><td>0</td><td>0</td><td>57</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>Object</td><td>0</td><td>11</td><td>9780</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>Page</td><td>0</td><td>0</td><td>3539</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Wait Time (ms)</td><td>RID</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>_Total</td><td>0</td><td>0</td><td>1</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>AllocUnit</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>Application</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>Database</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>Extent</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>File</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>HoBT</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>Key</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>Metadata</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>Object</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>Page</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Locks</td><td>Lock Waits/sec</td><td>RID</td><td>0</td><td>0</td><td>0</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Memory Manager</td><td>Target Server Memory (KB)</td><td>&nbsp</td><td>14771077</td><td>13659981</td><td>14680064</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Memory Manager</td><td>Total Server Memory (KB)</td><td>&nbsp</td><td>14119077</td><td>17773576</td><td>14680064</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:SQL Statistics</td><td>Batch Requests/sec</td><td>&nbsp</td><td>110</td><td>100</td><td>796</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Wait Statistics</td><td>Network IO waits</td><td>Average wait time (ms)</td><td>14</td><td>0</td><td>671</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Wait Statistics</td><td>Network IO waits</td><td>Cumulative wait time (ms) per second</td><td>0</td><td>0</td><td>7000</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Wait Statistics</td><td>Network IO waits</td><td>Waits in progress</td><td>0</td><td>0</td><td>3</td><td>10377</td></tr><tr class="datarow"><td>MSSQL$MYSQLINST:Wait Statistics</td><td>Network IO waits</td><td>Waits started per second</td><td>10</td><td>197</td><td>8369</td><td>43044</td></tr></table></font></font><br><font size="1">2010-01-23 07:22:38.457<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>