ÿþ<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>database_name</td><td>file_id</td><td>type</td><td>last_number_reads_per_min</td><td>avg_number_reads_per_min</td><td>max_number_reads_per_min</td><td>sdev_number_reads_per_min</td><td>last_number_writes_per_min</td><td>avg_number_writes_per_min</td><td>max_number_writes_per_min</td><td>sdev_number_writes_per_min</td><td>last_bytes_read_per_min</td><td>avg_bytes_read_per_min</td><td>max_bytes_read_per_min</td><td>sdev_bytes_read_per_min</td><td>last_bytes_written_per_min</td><td>avg_bytes_written_per_min</td><td>max_bytes_written_per_min</td><td>sdev_bytes_written_per_min</td><td>last_iostallms_per_min</td><td>avg_iostallms_per_min</td><td>max_iostallms_per_min</td><td>sdev_iostallms_per_min</td><td>pct_iostallms_per_min</td><td>logical_drive</td><td>physical_file</td></tr><tr class="datarow"><td>controlctr</td><td>1</td><td>data</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>2502.00</td><td>2555.25</td><td>5643.00</td><td>249.53</td><td>156.00</td><td>120.25</td><td>1405.00</td><td>105.26</td><td>0.00</td><td>0.04</td><td>1.00</td><td>0.20</td><td>0.00</td><td>S</td><td>X:\SQLData\controlctr_data.mdf</td></tr><tr class="datarow"><td>controlctr</td><td>2</td><td>log</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>6.00</td><td>5.05</td><td>42.00</td><td>4.05</td><td>63.00</td><td>69.64</td><td>252.00</td><td>19.29</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>T</td><td>Y:\SQLLog\controlctr_log.ldf</td></tr><tr class="datarow"><td>master</td><td>1</td><td>data</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>2645.00</td><td>2155.99</td><td>4920.00</td><td>310.05</td><td>216.00</td><td>201.09</td><td>1453.00</td><td>23.26</td><td>1.00</td><td>0.52</td><td>15.00</td><td>1.55</td><td>0.00</td><td>S</td><td>X:\SQLData\master.mdf</td></tr><tr class="datarow"><td>master</td><td>2</td><td>log</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.02</td><td>5.00</td><td>0.35</td><td>14.00</td><td>16.12</td><td>34.00</td><td>5.15</td><td>241.00</td><td>335.29</td><td>29155.00</td><td>1565.02</td><td>0.00</td><td>0.16</td><td>10.00</td><td>1.19</td><td>0.00</td><td>S</td><td>X:\SQLData\mastlog.ldf</td></tr><tr class="datarow"><td>model</td><td>1</td><td>data</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>1006.00</td><td>905.52</td><td>2133.00</td><td>125.59</td><td>102.00</td><td>101.33</td><td>204.00</td><td>9.22</td><td>0.00</td><td>0.14</td><td>11.00</td><td>0.29</td><td>0.00</td><td>S</td><td>X:\SQLData\model.mdf</td></tr><tr class="datarow"><td>model</td><td>2</td><td>log</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>14.00</td><td>14.63</td><td>22.00</td><td>2.12</td><td>91.00</td><td>92.03</td><td>122.00</td><td>5.59</td><td>0.00</td><td>0.00</td><td>3.00</td><td>0.25</td><td>0.00</td><td>S</td><td>X:\SQLData\modellog.ldf</td></tr><tr class="datarow"><td>msdb</td><td>1</td><td>data</td><td>1.00</td><td>0.23</td><td>2.00</td><td>0.42</td><td>1.00</td><td>0.95</td><td>1.00</td><td>0.15</td><td>192635.00</td><td>120021.55</td><td>401519.00</td><td>53119.40</td><td>19521.00</td><td>15351.25</td><td>64595.00</td><td>2944.26</td><td>45.00</td><td>22.64</td><td>129.00</td><td>22.20</td><td>0.15</td><td>S</td><td>X:\SQLData\MSDBData.mdf</td></tr><tr class="datarow"><td>msdb</td><td>2</td><td>log</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>15.00</td><td>12.42</td><td>25.00</td><td>1.29</td><td>3291.00</td><td>1526.12</td><td>4693.00</td><td>1024.03</td><td>56566.00</td><td>20154.99</td><td>120924.00</td><td>5251.14</td><td>21.00</td><td>134.29</td><td>2535.00</td><td>369.54</td><td>0.50</td><td>S</td><td>X:\SQLData\MSDBLog.ldf</td></tr><tr class="datarow"><td>reportdb</td><td>1</td><td>data</td><td>1.00</td><td>0.09</td><td>2.00</td><td>0.31</td><td>0.00</td><td>0.02</td><td>2.00</td><td>0.15</td><td>52520.00</td><td>15125.21</td><td>59360.00</td><td>2995.45</td><td>3626.00</td><td>4150.22</td><td>25352.00</td><td>3626.23</td><td>14.00</td><td>5.04</td><td>42.00</td><td>6.30</td><td>0.03</td><td>S</td><td>X:\SQLData\reportdb.mdf</td></tr><tr class="datarow"><td>reportdb</td><td>2</td><td>log</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.01</td><td>2.00</td><td>0.14</td><td>656.00</td><td>1166.51</td><td>20269.00</td><td>2562.15</td><td>1595.00</td><td>1999.22</td><td>22235.00</td><td>2614.59</td><td>0.00</td><td>2.03</td><td>35.00</td><td>4.55</td><td>0.01</td><td>T</td><td>Y:\SQLLog\reportdb_log.ldf</td></tr><tr class="datarow"><td>tinyDB</td><td>1</td><td>data</td><td>3.00</td><td>1.25</td><td>3.00</td><td>1.12</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>224525.00</td><td>102925.21</td><td>224525.00</td><td>54641.69</td><td>4510.00</td><td>4435.50</td><td>5159.00</td><td>535.52</td><td>20.00</td><td>44.50</td><td>111.00</td><td>31.26</td><td>0.01</td><td>S</td><td>X:\SQLData\tinyDB_data.mdf</td></tr><tr class="datarow"><td>tinyDB</td><td>2</td><td>log</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>1462.00</td><td>1313.31</td><td>1523.00</td><td>355.20</td><td>2055.00</td><td>1906.50</td><td>2321.00</td><td>345.29</td><td>1.00</td><td>1.63</td><td>5.00</td><td>1.36</td><td>0.00</td><td>T</td><td>Y:\SQLLog\tinyDB_log.ldf</td></tr><tr class="datarow"><td>metricsDB</td><td>1</td><td>data</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>5296.00</td><td>2505.94</td><td>6229.00</td><td>1205.22</td><td>2554.00</td><td>1305.92</td><td>3055.00</td><td>634.04</td><td>2.00</td><td>0.52</td><td>2.00</td><td>0.62</td><td>0.00</td><td>S</td><td>X:\SQLData\metricsDB_data.mdf</td></tr><tr class="datarow"><td>metricsDB</td><td>2</td><td>log</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.64</td><td>30.00</td><td>4.25</td><td>554.00</td><td>533.32</td><td>15654.00</td><td>2205.25</td><td>1365.00</td><td>1324.52</td><td>16262.00</td><td>2202.35</td><td>0.00</td><td>1.52</td><td>53.00</td><td>5.55</td><td>0.00</td><td>T</td><td>Y:\SQLLog\metricsDB_log.ldf</td></tr><tr class="datarow"><td>maindb</td><td>1</td><td>data</td><td>50.00</td><td>13.52</td><td>52.00</td><td>15.22</td><td>102.00</td><td>20.29</td><td>251.00</td><td>41.34</td><td>5159145.00</td><td>2563263.29</td><td>10695264.00</td><td>1220210.05</td><td>1012042.00</td><td>224055.13</td><td>3354200.00</td><td>565912.20</td><td>3203.00</td><td>1029.49</td><td>10920.00</td><td>1412.95</td><td>5.35</td><td>S</td><td>X:\SQLData\maindb.mdf</td></tr><tr class="datarow"><td>maindb</td><td>2</td><td>log</td><td>0.00</td><td>0.52</td><td>13.00</td><td>1.35</td><td>149.00</td><td>220.15</td><td>1350.00</td><td>334.90</td><td>224210.00</td><td>226211.95</td><td>6905650.00</td><td>1122155.50</td><td>221512.00</td><td>250639.20</td><td>6225225.00</td><td>1159661.25</td><td>301.00</td><td>1252.61</td><td>143316.00</td><td>14416.23</td><td>9.21</td><td>T</td><td>Y:\SQLLog\maindb_2.ldf</td></tr><tr class="datarow"><td>maindb</td><td>3</td><td>data</td><td>33.00</td><td>5.60</td><td>43.00</td><td>5.25</td><td>4.00</td><td>4.25</td><td>42.00</td><td>4.43</td><td>945452.00</td><td>662560.95</td><td>2510622.00</td><td>303306.11</td><td>43051.00</td><td>126954.99</td><td>1533465.00</td><td>149252.34</td><td>262.00</td><td>206.90</td><td>932.00</td><td>226.21</td><td>1.02</td><td>S</td><td>X:\SQLData\maindb_1.ndf</td></tr><tr class="datarow"><td>tempdb</td><td>1</td><td>data</td><td>39.00</td><td>203.65</td><td>4525.00</td><td>425.44</td><td>35.00</td><td>224.20</td><td>4232.00</td><td>453.44</td><td>2132595.00</td><td>12306256.62</td><td>229529226.00</td><td>29534233.55</td><td>2292522.00</td><td>14342059.66</td><td>313535405.00</td><td>30540112.36</td><td>625.00</td><td>3912.35</td><td>52225.00</td><td>2533.52</td><td>20.43</td><td>S</td><td>X:\SQLData\tempdb.mdf</td></tr><tr class="datarow"><td>tempdb</td><td>2</td><td>log</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>153.00</td><td>69.91</td><td>325.00</td><td>69.24</td><td>0.00</td><td>6.05</td><td>403.00</td><td>39.94</td><td>9401442.00</td><td>4006232.40</td><td>19525469.00</td><td>4325313.66</td><td>452.00</td><td>253.22</td><td>1521.00</td><td>315.55</td><td>1.43</td><td>S</td><td>Y:\SQLLog\templog.ldf</td></tr><tr class="datarow"><td>tempdb</td><td>3</td><td>data</td><td>39.00</td><td>203.55</td><td>4522.00</td><td>425.31</td><td>35.00</td><td>223.59</td><td>4229.00</td><td>453.25</td><td>2122611.00</td><td>12301626.34</td><td>229533422.00</td><td>29526052.42</td><td>2223950.00</td><td>14340110.46</td><td>313569029.00</td><td>30531535.22</td><td>622.00</td><td>3209.55</td><td>54506.00</td><td>2255.54</td><td>19.29</td><td>S</td><td>X:\SQLData\tempdev2.ndf</td></tr><tr class="datarow"><td>tempdb</td><td>4</td><td>data</td><td>39.00</td><td>203.52</td><td>4521.00</td><td>425.25</td><td>35.00</td><td>223.22</td><td>4225.00</td><td>453.23</td><td>2126992.00</td><td>12304560.62</td><td>229523324.00</td><td>29525295.20</td><td>2223253.00</td><td>14341226.53</td><td>313511425.00</td><td>30531445.62</td><td>592.00</td><td>3294.59</td><td>55242.00</td><td>2411.50</td><td>20.33</td><td>S</td><td>X:\SQLData\tempdev3.ndf</td></tr><tr class="datarow"><td>tempdb</td><td>5</td><td>data</td><td>39.00</td><td>203.61</td><td>4522.00</td><td>425.35</td><td>35.00</td><td>223.25</td><td>4229.00</td><td>453.35</td><td>2132126.00</td><td>12305569.22</td><td>229595259.00</td><td>29533429.11</td><td>2296422.00</td><td>14343246.59</td><td>313635211.00</td><td>30540036.52</td><td>600.00</td><td>3216.12</td><td>55651.00</td><td>2233.09</td><td>19.92</td><td>S</td><td>X:\SQLData\tempdev4.ndf</td></tr><tr class="datarow"><td>virtualDBA</td><td>1</td><td>data</td><td>1.00</td><td>0.14</td><td>2.00</td><td>0.36</td><td>1.00</td><td>0.30</td><td>2.00</td><td>0.42</td><td>504506.00</td><td>293223.51</td><td>232556.00</td><td>150923.92</td><td>12262.00</td><td>20525.29</td><td>323624.00</td><td>44626.22</td><td>50.00</td><td>32.90</td><td>220.00</td><td>25.02</td><td>0.15</td><td>S</td><td>X:\SQLData\virtualDBA_system.mdf</td></tr><tr class="datarow"><td>virtualDBA</td><td>2</td><td>log</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>2.00</td><td>1.22</td><td>2.00</td><td>0.90</td><td>253.00</td><td>105.03</td><td>1059.00</td><td>165.32</td><td>36696.00</td><td>41156.69</td><td>341236.00</td><td>22210.13</td><td>4.00</td><td>13.15</td><td>562.00</td><td>44.05</td><td>0.05</td><td>T</td><td>Y:\SQLLog\virtualDBA_log.ldf</td></tr><tr class="datarow"><td>virtualDBA</td><td>3</td><td>data</td><td>0.00</td><td>0.21</td><td>2.00</td><td>0.25</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>5463.00</td><td>145251.20</td><td>605152.00</td><td>150513.50</td><td>39.00</td><td>140.25</td><td>3640.00</td><td>402.53</td><td>1.00</td><td>23.04</td><td>465.00</td><td>40.39</td><td>0.12</td><td>S</td><td>X:\SQLData\virtualDBA_audit.ndf</td></tr><tr class="datarow"><td>virtualDBA</td><td>4</td><td>data</td><td>2.00</td><td>0.24</td><td>2.00</td><td>0.42</td><td>4.00</td><td>6.65</td><td>12.00</td><td>1.25</td><td>241505.00</td><td>126252.51</td><td>262965.00</td><td>20224.96</td><td>112322.00</td><td>163049.55</td><td>332422.00</td><td>50314.92</td><td>55.00</td><td>29.53</td><td>945.00</td><td>22.41</td><td>0.45</td><td>S</td><td>X:\SQLData\virtualDBA_data.ndf</td></tr><tr class="datarow"><td>migratedb</td><td>1</td><td>data</td><td>0.00</td><td>0.00</td><td>2.00</td><td>0.15</td><td>0.00</td><td>0.02</td><td>22.00</td><td>1.25</td><td>415.00</td><td>3422.93</td><td>939144.00</td><td>53634.15</td><td>250.00</td><td>4491.52</td><td>4241920.00</td><td>335235.69</td><td>0.00</td><td>0.20</td><td>322.00</td><td>25.55</td><td>0.00</td><td>S</td><td>X:\SQLData\migratedb.mdf</td></tr><tr class="datarow"><td>migratedb</td><td>2</td><td>log</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.00</td><td>0.05</td><td>23.00</td><td>10.21</td><td>0.00</td><td>515.21</td><td>292254.00</td><td>25522.56</td><td>259.00</td><td>263.01</td><td>3566245.00</td><td>226214.03</td><td>0.00</td><td>0.09</td><td>645.00</td><td>52.12</td><td>0.00</td><td>t</td><td>Y:\SQLLog\migratedb_log.ldf</td></tr></table></font></font><br><font size="1">2010-01-23 05:22:44.493<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>