Maison > Article > base de données > SQLSERVER性能计数器的简单剖析
SQLSERVER性能计数器的简单剖析
- WBOYoriginal
- 2016-06-07 15:45:402203parcourir
SQLSERVER性能计数器的简单剖析 今晚看了这篇文章： SQL Server 2012新performance counter：非常实用的Batch Resp Statistics 文章里介绍到SQLSERVER2012新的性能计数器Batch Resp Statistics 其实我有一个问题： 当我的电脑里有多个版本的SQLSERVER或者多
SQLSERVER性能计数器的简单剖析
今晚看了这篇文章：SQL Server 2012新performance counter：非常实用的Batch Resp Statistics
文章里介绍到SQLSERVER2012新的性能计数器“Batch Resp Statistics”
其实我有一个问题：当我的电脑里有多个版本的SQLSERVER或者多个SQLSERVER实例，SQLSERVER是怎麽区分不同版本的不同计数器的呢？
比如下面SQL脚本，在SQL2012里执行可以看到新的性能计数器Batch Resp Statistics的信息
<span> 1</span> <span>SELECT</span> <span>[</span><span>counter_name</span><span>]</span><span> , </span><span> 2</span> <span> "CPU Time:Total(ms)" , </span><span> 3</span> <span> "CPU Time:Requests" , </span><span> 4</span> <span> "Elapsed Time:Total(ms)" , </span><span> 5</span> <span> "Elapsed Time:Requests" </span><span> 6</span> <span>FROM</span> ( <span>SELECT</span> <span>[</span><span>counter_name</span><span>]</span><span> , </span><span> 7</span> <span>[</span><span>instance_name</span><span>]</span><span> , </span><span> 8</span> <span>[</span><span>cntr_value</span><span>]</span> <span> 9</span> <span>FROM</span> sys.dm_os_performance_counters <span>--</span><span>计数器视图</span> <span>10</span> <span>WHERE</span> <span>OBJECT_NAME</span> <span>LIKE</span> <span>'</span><span>%Batch Resp Statistics%</span><span>'</span> <span>11</span> ) os_pc PIVOT( <span>AVG</span>(<span>[</span><span>cntr_value</span><span>]</span>) <span>FOR</span> <span>[</span><span>instance_name</span><span>]</span> <span>IN</span><span> ( "CPU Time:Total(ms)", </span><span>12</span> <span> "CPU Time:Requests", </span><span>13</span> <span> "Elapsed Time:Total(ms)", </span><span>14</span> "Elapsed Time:Requests" ) )<span>AS</span> Pvt;
而在SQL2005里执行上面的SQL语句则什么都查询不到，因为在SQL2005里没有这个计数器
在性能监视器里添加“Batch Resp Statistics”性能计数器
第一步：
第二步：
第三步：
第四步：
MSDN关于sys.dm_os_performance_counters性能计数器视图的描述
http://technet.microsoft.com/zh-cn/library/ms187743(SQL.90).aspx
更新日期： 2007 年 9 月 15 日
为服务器维护的每个性能计数器返回一行。 有关每个性能计数器的信息，请参阅使用 SQL Server 对象。
| 列名 | 数据类型 | 说明 | |
|---|---|---|---|
|
object_name |
nchar(128) |
该计数器所属的类别。 |
|
|
counter_name |
nchar(128) |
计数器的名称。 |
|
|
instance_name |
nchar(128) |
计数器特定实例的名称。 通常包含数据库名称。 |
|
|
cntr_value |
bigint |
计数器的当前值。
对于每秒计数器，该值是累积的。 速率值必须通过对离散时间间隔的值抽样来进行计算。 任何两个连续抽样值之间的差等于针对所使用时间间隔的速率。
|
|
|
cntr_type |
int |
Windows 性能体系结构定义的计数器类型。 有关性能计数器类型的详细信息，请参阅 WMI Performance Counter Types（WMI 性能计数器类型）或 Windows Server 文档。 |
注意：
权限
需要对服务器具有 VIEW SERVER STATE 权限。
备注
如果 SQL Server 的安装实例无法显示 Windows 操作系统的性能计数器，请使用下面的 Transact-SQL 查询来确认性能计算器已禁用。
<span>1</span> <span>SELECT</span> <span>COUNT</span> (<span>*</span>) <span>FROM</span> sys.dm_os_performance_counters
如果返回值为 0 行，则性能计数器已禁用。 此时，您应查看安装日志并搜索错误 3409“请为此实例重新安装 sqlctr.ini，
并确保实例登录帐户具有正确的注册表权限”，该错误表示性能计数器未启用。
紧列在 3409 前的错误应指示导致性能计数器启用失败的根本原因。 有关安装日志文件的详细信息，
请参阅How to: View SQL Server 2005 Setup Log Files。
分析
我的电脑里安装了SQL2005 、SQL2008 SQLEXPRESS版本 、SQL2012
我安装各个SQLSERVER的路径
SQL2005
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
SQL2008 SQLEXPRESS版本
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn
SQL2012
D:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\Binn
上面三个路径都有一个sqlctr.ini文件
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlctr.ini SQL2005
<span> 1</span> <span>[</span><span>info</span><span>]</span> <span> 2</span> drivername<span>=</span><span>MSSQLServer </span><span> 3</span> trusted<span>=</span> <span> 4</span> symbolfile<span>=</span><span>sqlctr.h </span><span> 5</span> <span> 6</span> <span> 7</span> <span>[</span><span>languages</span><span>]</span> <span> 8</span> <span>009</span><span>=</span><span>English </span><span> 9</span> <span>004</span><span>=</span><span>Chinese </span><span> 10</span> <span> 11</span> <span> 12</span> <span>[</span><span>text</span><span>]</span> <span> 13</span> BUFMGR_OBJECT_009_NAME<span>=</span><span>SQLServer:Buffer Manager </span><span> 14</span> BUFMGR_OBJECT_009_HELP<span>=</span><span>Statistics</span> related <span>to</span><span> SQL Servers buffer manager </span><span> 15</span> <span> 16</span> <span> 17</span> BUFPART_OBJECT_009_NAME<span>=</span><span>SQLServer:Buffer Partition </span><span> 18</span> BUFPART_OBJECT_009_HELP<span>=</span><span>Statistics</span> related <span>to</span> SQL Server<span>'</span><span>s buffer partitions </span><span> 19</span> <span> 20</span> <span> 21</span> <span>BUFNODE_OBJECT_009_NAME=SQLServer:Buffer Node </span><span> 22</span> <span>BUFNODE_OBJECT_009_HELP=Statistics related to SQL Server</span><span>'</span>s buffer pool <span>by</span><span> NUMA node </span><span> 23</span> <span> 24</span> <span> 25</span> GENERAL_OBJECT_009_NAME<span>=</span>SQLServer:General <span>Statistics</span> <span> 26</span> GENERAL_OBJECT_009_HELP<span>=</span>Server General <span>Statistics</span> <span> 27</span> <span> 28</span> <span> 29</span> LOCKS_OBJECT_009_NAME<span>=</span><span>SQLServer:Locks </span><span> 30</span> LOCKS_OBJECT_009_HELP<span>=</span>Describes <span>statistics</span> <span>for</span><span> individual lock server lock requests </span><span> 31</span> <span> 32</span> <span> 33</span> DBMGR_OBJECT_009_NAME<span>=</span><span>SQLServer:Databases </span><span> 34</span> DBMGR_OBJECT_009_HELP<span>=</span>This defines a <span>Database</span> manager object <span>for</span><span> SQL Server </span><span> 35</span> <span> 36</span> <span> 37</span> DBMIRRORING_OBJECT_009_NAME<span>=</span>SQLServer:<span>Database</span><span> Mirroring </span><span> 38</span> DBMIRRORING_OBJECT_009_HELP<span>=</span>This defines a <span>Database</span> Mirroring object <span>for</span><span> SQL Server </span><span> 39</span> <span> 40</span> <span> 41</span> LATCH_OBJECT_009_NAME<span>=</span><span>SQLServer:Latches </span><span> 42</span> LATCH_OBJECT_009_HELP<span>=</span>Collects <span>statistics</span> associated <span>with</span><span> internal server latches </span><span> 43</span> <span> 44</span> <span> 45</span> ACCESS_METHODS_OBJECT_009_NAME<span>=</span><span>SQLServer:Access Methods </span><span> 46</span> ACCESS_METHODS_OBJECT_009_HELP<span>=</span>Collects <span>statistics</span> associated <span>with</span> the <span>database</span><span> server access methods </span><span> 47</span> <span> 48</span> <span> 49</span> SQL_ERROR_OBJECT_009_NAME<span>=</span><span>SQLServer:SQL Errors </span><span> 50</span> SQL_ERROR_OBJECT_009_HELP<span>=</span><span>Statistics</span> about errors <span>in</span><span> SQL Server </span><span> 51</span> <span> 52</span> <span> 53</span> SQL_OBJECT_009_NAME<span>=</span>SQLServer:SQL <span>Statistics</span> <span> 54</span> SQL_OBJECT_009_HELP<span>=</span>Collects <span>statistics</span> associated <span>with</span><span> SQL requests </span><span> 55</span> <span> 56</span> <span> 57</span> PLAN_CACHE_009_NAME<span>=</span>SQLServer:<span>Plan</span><span> Cache </span><span> 58</span> PLAN_CACHE_009_HELP<span>=</span><span>This defines cache counters </span><span> 59</span> <span> 60</span> <span> 61</span> CURSOR_OBJECT_BY_TYPE_009_NAME<span>=</span>SQLServer:<span>Cursor</span> Manager <span>by</span><span> Type </span><span> 62</span> CURSOR_OBJECT_BY_TYPE_009_HELP<span>=</span>Counters <span>for</span> <span>cursor</span> properties grouped <span>by</span><span> type </span><span> 63</span> <span> 64</span> <span> 65</span> CURSOR_OBJECT_TOTAL_009_NAME<span>=</span>SQLServer:<span>Cursor</span><span> Manager Total </span><span> 66</span> CURSOR_OBJECT_TOTAL_009_HELP<span>=</span>Counters <span>for</span> <span>cursor</span> properties <span>not</span> grouped <span>by</span><span> type </span><span> 67</span> <span> 68</span> <span> 69</span> MEMORY_OBJECT_009_NAME<span>=</span><span>SQLServer:Memory Manager </span><span> 70</span> MEMORY_OBJECT_009_HELP<span>=</span><span>This defines memory usage. </span><span> 71</span> <span> 72</span> <span> 73</span> USER_QUERY_OBJECT_009_NAME<span>=</span>SQLServer:<span>User</span><span> Settable </span><span> 74</span> USER_QUERY_OBJECT_009_HELP<span>=</span>This defines <span>user</span><span> definable counters </span><span> 75</span> <span> 76</span> <span> 77</span> REPLICATION_AGENT_OBJECT_009_NAME<span>=</span>SQLServer:<span>Replication</span><span> Agents </span><span> 78</span> REPLICATION_AGENT_OBJECT_009_HELP<span>=</span><span>Replication</span><span> Summary </span><span> 79</span> <span> 80</span> <span> 81</span> MERGE_AGENT_OBJECT_009_NAME<span>=</span>SQLServer:<span>Replication</span><span> Merge </span><span> 82</span> MERGE_AGENT_OBJECT_009_HELP<span>=</span><span>Replication</span> Merge Agent <span>Statistics</span> <span> 83</span> <span> 84</span> <span> 85</span> LOGREADER_AGENT_OBJECT_009_NAME<span>=</span>SQLServer:<span>Replication</span><span> Logreader </span><span> 86</span> LOGREADER_AGENT_OBJECT_009_HELP<span>=</span><span>Replication</span> Logreader Agent <span>Statistics</span> <span> 87</span> <span> 88</span> <span> 89</span> DISTRIBUTION_AGENT_OBJECT_009_NAME<span>=</span>SQLServer:<span>Replication</span><span> Dist. </span><span> 90</span> DISTRIBUTION_AGENT_OBJECT_009_HELP<span>=</span><span>Replication</span> Distribution Agent <span>Statistics</span> <span> 91</span> <span> 92</span> <span> 93</span> SNAPSHOT_AGENT_OBJECT_009_NAME<span>=</span>SQLServer:<span>Replication</span><span> Snapshot </span><span> 94</span> SNAPSHOT_AGENT_OBJECT_009_HELP<span>=</span><span>Replication</span> Snapshot Agent <span>Statistics</span> <span> 95</span> <span> 96</span> <span> 97</span> BACKUP_DEV_OBJECT_009_NAME<span>=</span>SQLServer:<span>Backup</span><span> Device </span><span> 98</span> BACKUP_DEV_OBJECT_009_HELP<span>=</span>This defines a <span>backup</span> device object <span>for</span><span> SQL Server </span><span> 99</span> <span> 100</span> <span> 101</span> XACT_OBJECT_009_NAME<span>=</span><span>SQLServer:Transactions </span><span> 102</span> XACT_OBJECT_009_HELP<span>=</span><span>Statistics</span> related <span>to</span><span> SQL Server transactions. </span><span> 103</span> <span> 104</span> <span> 105</span> BROKER_OBJECT_009_NAME<span>=</span>SQLServer:Broker <span>Statistics</span> <span> 106</span> BROKER_OBJECT_009_HELP<span>=</span>Service Broker <span>Statistics</span> <span> 107</span> <span> 108</span> <span> 109</span> BROKER_TRANSPORT_OBJECT_009_NAME<span>=</span>SQLServer:Broker<span>/</span><span>DBM Transport </span><span> 110</span> BROKER_TRANSPORT_OBJECT_009_HELP<span>=</span>Service Broker<span>/</span><span>Database</span> Mirroring Transport <span>Statistics</span> <span> 111</span> <span> 112</span> <span> 113</span> BROKER_ACTIVATION_OBJECT_009_NAME<span>=</span><span>SQLServer:Broker Activation </span><span> 114</span> BROKER_ACTIVATION_OBJECT_009_HELP<span>=</span><span>Service Broker Activation </span><span> 115</span> <span> 116</span> <span> 117</span> WAITSTATS_OBJECT_009_NAME<span>=</span>SQLServer:Wait <span>Statistics</span> <span> 118</span> WAITSTATS_OBJECT_009_HELP<span>=</span>Wait <span>Statistics</span> <span> 119</span> <span> 120</span> <span> 121</span> EXECSTATS_OBJECT_009_NAME<span>=</span>SQLServer:<span>Exec</span> <span>Statistics</span> <span> 122</span> EXECSTATS_OBJECT_009_HELP<span>=</span>Execution <span>statistics</span> <span>for</span><span> external calls </span><span> 123</span> <span> 124</span> <span> 125</span> SQLCLR_OBJECT_009_NAME<span>=</span><span>SQLServer:CLR </span><span> 126</span> SQLCLR_OBJECT_009_HELP<span>=</span>CLR Execution <span>in</span><span> SQL Server </span><span> 127</span> <span> 128</span> <span> 129</span> METADATAMGR_OBJECT_009_NAME<span>=</span><span>SQLServer:Catalog Metadata </span><span> 130</span> METADATAMGR_OBJECT_009_HELP<span>=</span>This defines a catalog metadata manager object <span>for</span><span> SQL Server </span><span> 131</span> <span> 132</span> <span> 133</span> BUF_CACHE_HIT_RATIO_009_NAME<span>=</span><span>Buffer cache hit ratio </span><span> 134</span> BUF_CACHE_HIT_RATIO_009_HELP<span>=</span>Percentage <span>of</span> pages that were found <span>in</span> the buffer pool without <span>having</span> <span>to</span> incur a <span>read</span> <span>from</span> <span>disk</span><span>. </span><span> 135</span> <span> 136</span> <span> 137</span> BUF_CACHE_RATIO_BASE_009_NAME<span>=</span><span>Buffer cache hit ratio base </span><span> 138</span> BUF_CACHE_RATIO_BASE_009_HELP<span>=</span>Base <span>for</span><span> prior entry </span><span> 139</span> <span> 140</span> <span> 141</span> BUF_PAGE_REQUESTS_009_NAME<span>=</span>Page lookups<span>/</span><span>sec </span><span> 142</span> BUF_PAGE_REQUESTS_009_HELP<span>=</span><span>Number</span> <span>of</span> requests <span>to</span> find a page <span>in</span><span> the buffer pool. </span><span> 143</span> <span> 144</span> <span> 145</span> BUF_FREELIST_STALLS_009_NAME<span>=</span>Free list stalls<span>/</span><span>sec </span><span> 146</span> BUF_FREELIST_STALLS_009_HELP<span>=</span><span>Number</span> <span>of</span> requests that had <span>to</span> wait <span>for</span><span> a free page. </span><span> 147</span> <span> 148</span> <span> 149</span> BUF_NUM_FREE_BUFFERS_009_NAME<span>=</span><span>Free pages </span><span> 150</span> BUF_NUM_FREE_BUFFERS_009_HELP<span>=</span>Total <span>number</span> <span>of</span> pages <span>on</span> <span>all</span><span> free lists. </span><span> 151</span> <span> 152</span> <span> 153</span> BUF_COMMITTED_PAGE_COUNT_009_NAME<span>=</span><span>Total pages </span><span> 154</span> BUF_COMMITTED_PAGE_COUNT_009_HELP<span>=</span><span>Number</span> <span>of</span> pages <span>in</span> the buffer pool (includes <span>database</span>, free, <span>and</span><span> stolen). </span><span> 155</span> <span> 156</span> <span> 157</span> BUF_TARGET_PAGE_COUNT_009_NAME<span>=</span><span>Target pages </span><span> 158</span> BUF_TARGET_PAGE_COUNT_009_HELP<span>=</span>Ideal <span>number</span> <span>of</span> pages <span>in</span><span> the buffer pool. </span><span> 159</span> <span> 160</span> <span> 161</span> BUF_HASHED_PAGE_COUNT_009_NAME<span>=</span><span>Database</span><span> pages </span><span> 162</span> BUF_HASHED_PAGE_COUNT_009_HELP<span>=</span><span>Number</span> <span>of</span> pages <span>in</span> the buffer pool <span>with</span> <span>database</span><span> content. </span><span> 163</span> <span> 164</span> <span> 165</span> BUF_RESERVED_PAGE_COUNT_009_NAME<span>=</span><span>Reserved pages </span><span> 166</span> BUF_RESERVED_PAGE_COUNT_009_HELP<span>=</span><span>Number</span> <span>of</span><span> buffer pool reserved pages. </span><span> 167</span> <span> 168</span> <span> 169</span> BUF_STOLEN_PAGE_COUNT_009_NAME<span>=</span><span>Stolen pages </span><span> 170</span> BUF_STOLEN_PAGE_COUNT_009_HELP<span>=</span><span>Number</span> <span>of</span> pages used <span>for</span> miscellaneous server purposes (including <span>procedure</span><span> cache). </span><span> 171</span> <span> 172</span> <span> 173</span> BUF_LAZY_WRITES_009_NAME<span>=</span>Lazy writes<span>/</span><span>sec </span><span> 174</span> BUF_LAZY_WRITES_009_HELP<span>=</span><span>Number</span> <span>of</span> buffers written <span>by</span> buffer manager<span>'</span><span>s lazy writer. </span><span> 175</span> <span> 176</span> <span> 177</span> <span>BUF_READAHEAD_PAGES_009_NAME=Readahead pages/sec </span><span> 178</span> <span>BUF_READAHEAD_PAGES_009_HELP=Number of pages read in anticipation of use. </span><span> 179</span> <span> 180</span> <span> 181</span> <span>BUF_BLOCK_READS_009_NAME=Page reads/sec </span><span> 182</span> <span>BUF_BLOCK_READS_009_HELP=Number of physical database page reads issued. </span><span> 183</span> <span> 184</span> <span> 185</span> <span>BUF_BLOCK_WRITES_009_NAME=Page writes/sec </span><span> 186</span> <span>BUF_BLOCK_WRITES_009_HELP=Number of physical database page writes issued. </span><span> 187</span> <span> 188</span> <span> 189</span> <span>BUF_CHECKPOINT_WRITES_009_NAME=Checkpoint pages/sec </span><span> 190</span> <span>BUF_CHECKPOINT_WRITES_009_HELP=Number of pages flushed by checkpoint or other operations that require all dirty pages to be flushed. </span><span> 191</span> <span> 192</span> <span> 193</span> <span>BUF_AWE_LOOKUP_MAPS_009_NAME=AWE lookup maps/sec </span><span> 194</span> <span>BUF_AWE_LOOKUP_MAPS_009_HELP=Number of AWE map calls made for pages found in the buffer pool. </span><span> 195</span> <span> 196</span> <span> 197</span> <span>BUF_AWE_STOLEN_MAPS_009_NAME=AWE stolen maps/sec </span><span> 198</span> <span>BUF_AWE_STOLEN_MAPS_009_HELP=Number of AWE map calls made for pages stolen from the buffer pool. </span><span> 199</span> <span> 200</span> <span> 201</span> <span>BUF_AWE_WRITE_MAPS_009_NAME=AWE write maps/sec </span><span> 202</span> <span>BUF_AWE_WRITE_MAPS_009_HELP=Number of AWE map calls made for pages to be written to disk. </span><span> 203</span> <span> 204</span> <span> 205</span> <span>BUF_AWE_UNMAP_CALLS_009_NAME=AWE unmap calls/sec </span><span> 206</span> <span>BUF_AWE_UNMAP_CALLS_009_HELP=Number of AWE unmap calls. </span><span> 207</span> <span> 208</span> <span> 209</span> <span>BUF_AWE_UNMAP_PAGES_009_NAME=AWE unmap pages/sec </span><span> 210</span> <span>BUF_AWE_UNMAP_PAGES_009_HELP=Number of AWE pages unmapped. </span><span> 211</span> <span> 212</span> <span> 213</span> <span>BUF_LIFE_EXPECTANCY_009_NAME=Page life expectancy </span><span> 214</span> <span>BUF_LIFE_EXPECTANCY_009_HELP=Number of seconds a page will stay in the buffer pool without references. </span><span> 215</span> <span> 216</span> <span> 217</span> <span>BUFPART_NUM_FREE_BUFFERS_009_NAME=Free pages </span><span> 218</span> <span>BUFPART_NUM_FREE_BUFFERS_009_HELP=Number of pages on partition free list. </span><span> 219</span> <span> 220</span> <span> 221</span> <span>BUFPART_FREE_BUFFERS_USED_009_NAME=Free list requests/sec </span><span> 222</span> <span>BUFPART_FREE_BUFFERS_USED_009_HELP=Number of times a free page was requested. </span><span> 223</span> <span> 224</span> <span> 225</span> <span>BUFPART_FREE_BUFFERS_EMPTY_009_NAME=Free list empty/sec </span><span> 226</span> <span>BUFPART_FREE_BUFFERS_EMPTY_009_HELP=Number of times a free page was requested and none were available. </span><span> 227</span> <span> 228</span> <span> 229</span> <span>BUFNODE_NUM_FREE_BUFFERS_009_NAME=Free pages </span><span> 230</span> <span>BUFNODE_NUM_FREE_BUFFERS_009_HELP=Free pages on node. </span><span> 231</span> <span> 232</span> <span> 233</span> <span>BUFNODE_COMMITTED_PAGE_COUNT_009_NAME=Total pages </span><span> 234</span> <span>BUFNODE_COMMITTED_PAGE_COUNT_009_HELP=Committed pages on node. </span><span> 235</span> <span> 236</span> <span> 237</span> <span>BUFNODE_FOREIGN_PAGE_COUNT_009_NAME=Foreign pages </span><span> 238</span> <span>BUFNODE_FOREIGN_PAGE_COUNT_009_HELP=Number of pages which are not from NUMA-local memory. </span><span> 239</span> <span> 240</span> <span> 241</span> <span>BUFNODE_HASHED_PAGE_COUNT_009_NAME=Database pages </span><span> 242</span> <span>BUFNODE_HASHED_PAGE_COUNT_009_HELP=Database pages on node. </span><span> 243</span> <span> 244</span> <span> 245</span> <span>BUFNODE_STOLEN_PAGE_COUNT_009_NAME=Stolen pages </span><span> 246</span> <span>BUFNODE_STOLEN_PAGE_COUNT_009_HELP=Stolen pages on node. </span><span> 247</span> <span> 248</span> <span> 249</span> <span>BUFNODE_TARGET_PAGE_COUNT_009_NAME=Target pages </span><span> 250</span> <span>BUFNODE_TARGET_PAGE_COUNT_009_HELP=Target pages on node. </span><span> 251</span> <span> 252</span> <span> 253</span> <span>BUFNODE_LIFE_EXPECTANCY_009_NAME=Page life expectancy </span><span> 254</span> <span>BUFNODE_LIFE_EXPECTANCY_009_HELP=Number of seconds a page will stay in the buffer pool without references. </span><span> 255</span> <span> 256</span> <span> 257</span> <span>GO_TEMP_TABLES_IN_USE_009_NAME=Active Temp Tables </span><span> 258</span> <span>GO_TEMP_TABLES_IN_USE_009_HELP=Number of temporary tables/table variables in use </span><span> 259</span> <span> 260</span> <span> 261</span> <span>GO_TEMP_TABLES_CREATION_RATE_009_NAME=Temp Tables Creation Rate </span><span> 262</span> <span>GO_TEMP_TABLES_CREATION_RATE_009_HELP=Number of temporary tables/table variables created/sec </span><span> 263</span> <span> 264</span> <span> 265</span> <span>GO_LOGINS_009_NAME=Logins/sec </span><span> 266</span> <span>GO_LOGINS_009_HELP=Total number of logins started per second. </span><span> 267</span> <span> 268</span> <span> 269</span> <span>GO_LOGOUTS_009_NAME=Logouts/sec </span><span> 270</span> <span>GO_LOGOUTS_009_HELP=Total number of logouts started per second. </span><span> 271</span> <span> 272</span> <span> 273</span> <span>GO_USER_CONNECTIONS_009_NAME=User Connections </span><span> 274</span> <span>GO_USER_CONNECTIONS_009_HELP=Number of users connected to the system. </span><span> 275</span> <span> 276</span> <span> 277</span> <span>GO_LOGICAL_CONNECTIONS_009_NAME=Logical Connections </span><span> 278</span> <span>GO_LOGICAL_CONNECTIONS_009_HELP=Number of logical connections to the system. </span><span> 279</span> <span> 280</span> <span> 281</span> <span>GO_TRANSACTIONS_009_NAME=Transactions </span><span> 282</span> <span>GO_TRANSACTIONS_009_HELP=Number of transaction enlistments (local, dtc, and bound). </span><span> 283</span> <span> 284</span> <span> 285</span> <span>GO_NON_ATOMIC_YIELD_RATE_009_NAME=Non-atomic yield rate </span><span> 286</span> <span>GO_NON_ATOMIC_YIELD_RATE_009_HELP=Number of non-atomic yields per second. </span><span> 287</span> <span> 288</span> <span> 289</span> <span>GO_MARS_DEADLOCKS_DETECTED_009_NAME=Mars Deadlocks </span><span> 290</span> <span>GO_MARS_DEADLOCKS_DETECTED_009_HELP=Number of Mars Deadlocks detected. </span><span> 291</span> <span> 292</span> <span> 293</span> <span>GO_HTTP_AUTH_REQS_009_NAME=HTTP Authenticated Requests </span><span> 294</span> <span>GO_HTTP_AUTH_REQS_009_HELP=Number of authenticated HTTP requests started per second. </span><span> 295</span> <span> 296</span> <span> 297</span> <span>GO_SOAP_EMPTY_REQS_009_NAME=SOAP Empty Requests </span><span> 298</span> <span>GO_SOAP_EMPTY_REQS_009_HELP=Number of empty SOAP requests started per second. </span><span> 299</span> <span> 300</span> <span> 301</span> <span>GO_SOAP_QUERY_REQS_009_NAME=SOAP SQL Requests </span><span> 302</span> <span>GO_SOAP_QUERY_REQS_009_HELP=Number of SOAP SQL requests started per second. </span><span> 303</span> <span> 304</span> <span> 305</span> <span>GO_SOAP_SP_REQS_009_NAME=SOAP Method Invocations </span><span> 306</span> <span>GO_SOAP_SP_REQS_009_HELP=Number of SOAP method invocations started per second. </span><span> 307</span> <span> 308</span> <span> 309</span> <span>GO_SOAP_WSDL_REQS_009_NAME=SOAP WSDL Requests </span><span> 310</span> <span>GO_SOAP_WSDL_REQS_009_HELP=Number of SOAP Web Service Description Language requests started per second. </span><span> 311</span> <span> 312</span> <span> 313</span> <span>GO_SOAP_SESSION_INITIATES_009_NAME=SOAP Session Initiate Requests </span><span> 314</span> <span>GO_SOAP_SESSION_INITIATES_009_HELP=Number of SOAP Session initiate requests started per second. </span><span> 315</span> <span> 316</span> <span> 317</span> <span>GO_SOAP_SESSION_TERMINATES_009_NAME=SOAP Session Terminate Requests </span><span> 318</span> <span>GO_SOAP_SESSION_TERMINATES_009_HELP=Number of SOAP Session terminate requests started per second. </span><span> 319</span> <span> 320</span> <span> 321</span> <span>GO_USERS_BLOCKED_009_NAME=Processes blocked </span><span> 322</span> <span>GO_USERS_BLOCKED_009_HELP=Number of currently blocked processes. </span><span> 323</span> <span> 324</span> <span> 325</span> <span>GO_TEMP_TABLES_FOR_DESTRUCTION_009_NAME=Temp Tables For Destruction </span><span> 326</span> <span>GO_TEMP_TABLES_FOR_DESTRUCTION_009_HELP=Number of temporary tables/table variables waiting to be destroyed by the cleanup system thread </span><span> 327</span> <span> 328</span> <span> 329</span> <span>GO_EVT_NOTIF_DELAYED_DROP_009_NAME=Event Notifications Delayed Drop </span><span> 330</span> <span>GO_EVT_NOTIF_DELAYED_DROP_009_HELP=Number of event notifications waiting to be dropped by a system thread </span><span> 331</span> <span> 332</span> <span> 333</span> <span>GO_TRACE_EVT_NOTIF_QUEUE_SIZE_009_NAME=Trace Event Notification Queue </span><span> 334</span> <span>GO_TRACE_EVT_NOTIF_QUEUE_SIZE_009_HELP=Number of trace event notification instances waiting in the internal queue to be sent thru Service Broker </span><span> 335</span> <span> 336</span> <span> 337</span> <span>GO_TRACE_IO_PROVIDER_EVENTLOCK_009_NAME=SQL Trace IO Provider Lock Waits </span><span> 338</span> <span>GO_TRACE_IO_PROVIDER_EVENTLOCK_009_HELP=Number of waits for the File IO Provider lock per second </span><span> 339</span> <span> 340</span> <span> 341</span> <span>LCK_NUM_REQUESTS_009_NAME=Lock Requests/sec </span><span> 342</span> <span>LCK_NUM_REQUESTS_009_HELP=Number of new locks and lock conversions requested from the lock manager. </span><span> 343</span> <span> 344</span> <span> 345</span> <span>LCK_NUM_TIMEOUTS_009_NAME=Lock Timeouts/sec </span><span> 346</span> <span>LCK_NUM_TIMEOUTS_009_HELP=Number of lock requests that timed out. This includes requests for NOWAIT locks. </span><span> 347</span> <span> 348</span> <span> 349</span> <span>LCK_NUM_DEADLOCKS_009_NAME=Number of Deadlocks/sec </span><span> 350</span> <span>LCK_NUM_DEADLOCKS_009_HELP=Number of lock requests that resulted in a deadlock. </span><span> 351</span> <span> 352</span> <span> 353</span> <span>LCK_NUM_WAITS_009_NAME=Lock Waits/sec </span><span> 354</span> <span>LCK_NUM_WAITS_009_HELP=Number of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock. </span><span> 355</span> <span> 356</span> <span> 357</span> <span>LCK_TOTAL_WAITTIME_009_NAME=Lock Wait Time (ms) </span><span> 358</span> <span>LCK_TOTAL_WAITTIME_009_HELP=Total wait time (milliseconds) for locks in the last second. </span><span> 359</span> <span> 360</span> <span> 361</span> <span>LCK_AVERAGE_WAITTIME_009_NAME=Average Wait Time (ms) </span><span> 362</span> <span>LCK_AVERAGE_WAITTIME_009_HELP=The average amount of wait time (milliseconds) for each lock request that resulted in a wait. </span><span> 363</span> <span> 364</span> <span> 365</span> <span>LCK_AVERAGE_WAITTIME_BASE_009_NAME=Average Wait Time Base </span><span> 366</span> <span>LCK_AVERAGE_WAITTIME_BASE_009_HELP=Base for Averate Wait Time. </span><span> 367</span> <span> 368</span> <span> 369</span> <span>LCK_NUM_TIMEOUTS_NONPROBE_009_NAME=Lock Timeouts (timeout > 0)/sec </span><span> 370</span> <span>LCK_NUM_TIMEOUTS_NONPROBE_009_HELP=Number of lock requests that timed out. This does not include requests for NOWAIT locks. </span><span> 371</span> <span> 372</span> <span> 373</span> <span>DB_DATA_SIZE_009_NAME=Data File(s) Size (KB) </span><span> 374</span> <span>DB_DATA_SIZE_009_HELP=The cumulative size of all the data files in the database. </span><span> 375</span> <span> 376</span> <span> 377</span> <span>DB_LOG_SIZE_009_NAME=Log File(s) Size (KB) </span><span> 378</span> <span>DB_LOG_SIZE_009_HELP=The cumulative size of all the log files in the database. </span><span> 379</span> <span> 380</span> <span> 381</span> <span>DB_LOG_USED_009_NAME=Log File(s) Used Size (KB) </span><span> 382</span> <span>DB_LOG_USED_009_HELP=The cumulative used size of all the log files in the database. </span><span> 383</span> <span> 384</span> <span> 385</span> <span>DB_LOG_USED_PERCENT_009_NAME=Percent Log Used </span><span> 386</span> <span>DB_LOG_USED_PERCENT_009_HELP=The percent of space in the log that is in use. </span><span> 387</span> <span> 388</span> <span> 389</span> <span>DB_ACT_XTRAN_009_NAME=Active Transactions </span><span> 390</span> <span>DB_ACT_XTRAN_009_HELP=Number of active update transactions for the database. </span><span> 391</span> <span> 392</span> <span> 393</span> <span>DB_TOTAL_XTRAN_009_NAME=Transactions/sec </span><span> 394</span> <span>DB_TOTAL_XTRAN_009_HELP=Number of transactions started for the database. </span><span> 395</span> <span> 396</span> <span> 397</span> <span>DB_REPLTRANS_009_NAME=Repl. Pending Xacts </span><span> 398</span> <span>DB_REPLTRANS_009_HELP=Number of pending replication transactions in the database. </span><span> 399</span> <span> 400</span> <span> 401</span> <span>DB_REPLCOUNT_009_NAME=Repl. Trans. Rate </span><span> 402</span> <span>DB_REPLCOUNT_009_HELP=Replication transaction rate (replicated transactions/sec.). </span><span> 403</span> <span> 404</span> <span> 405</span> <span>DB_LOGCACHE_READS_009_NAME=Log Cache Reads/sec </span><span> 406</span> <span>DB_LOGCACHE_READS_009_HELP=Reads performed through the log manager cache. </span><span> 407</span> <span> 408</span> <span> 409</span> <span>DB_LOGCACHE_RATIO_009_NAME=Log Cache Hit Ratio </span><span> 410</span> <span>DB_LOGCACHE_RATIO_009_HELP=Percentage of log cache reads that were satisfied from the log cache. </span><span> 411</span> <span> 412</span> <span> 413</span> <span>DB_LOGCACHE_BASE_009_NAME=Log Cache Hit Ratio Base </span><span> 414</span> <span>DB_LOGCACHE_BASE_009_HELP=Base for log cache calculations </span><span> 415</span> <span> 416</span> <span> 417</span> <span>DB_BULK_ROWS_009_NAME=Bulk Copy Rows/sec </span><span> 418</span> <span>DB_BULK_ROWS_009_HELP=Number of rows bulk copied. </span><span> 419</span> <span> 420</span> <span> 421</span> <span>DB_BULK_KILOBYTES_009_NAME=Bulk Copy Throughput/sec </span><span> 422</span> <span>DB_BULK_KILOBYTES_009_HELP=KiloBytes bulk copied. </span><span> 423</span> <span> 424</span> <span> 425</span> <span>DB_BCK_DB_THROUGHPUT_009_NAME=Backup/Restore Throughput/sec </span><span> 426</span> <span>DB_BCK_DB_THROUGHPUT_009_HELP=Read/write throughput for backup/restore of a database. </span><span> 427</span> <span> 428</span> <span> 429</span> <span>DB_DBCC_SCANRATE_009_NAME=DBCC Logical Scan Bytes/sec </span><span> 430</span> <span>DB_DBCC_SCANRATE_009_HELP=Logical read scan rate for DBCC commands </span><span> 431</span> <span> 432</span> <span> 433</span> <span>DB_DBCC_MOVERATE_009_NAME=Shrink Data Movement Bytes/sec </span><span> 434</span> <span>DB_DBCC_MOVERATE_009_HELP=The rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE. </span><span> 435</span> <span> 436</span> <span> 437</span> <span>DB_FLUSHES_009_NAME=Log Flushes/sec </span><span> 438</span> <span>DB_FLUSHES_009_HELP=Number of log flushes. </span><span> 439</span> <span> 440</span> <span> 441</span> <span>DB_BYTES_FLUSHED_009_NAME=Log Bytes Flushed/sec </span><span> 442</span> <span>DB_BYTES_FLUSHED_009_HELP=Total number of log bytes flushed. </span><span> 443</span> <span> 444</span> <span> 445</span> <span>DB_FLUSH_WAITS_009_NAME=Log Flush Waits/sec </span><span> 446</span> <span>DB_FLUSH_WAITS_009_HELP=Number of commits waiting on log flush. </span><span> 447</span> <span> 448</span> <span> 449</span> <span>DB_FLUSH_WAIT_TIME_009_NAME=Log Flush Wait Time </span><span> 450</span> <span>DB_FLUSH_WAIT_TIME_009_HELP=Total wait time (milliseconds). </span><span> 451</span> <span> 452</span> <span> 453</span> <span>DB_LOG_TRUNCS_009_NAME=Log Truncations </span><span> 454</span> <span>DB_LOG_TRUNCS_009_HELP=Total number of log truncations for this database. </span><span> 455</span> <span> 456</span> <span> 457</span> <span>DB_LOG_GROWTHS_009_NAME=Log Growths </span><span> 458</span> <span>DB_LOG_GROWTHS_009_HELP=Total number of log growths for this database. </span><span> 459</span> <span> 460</span> <span> 461</span> <span>DB_LOG_SHRINKS_009_NAME=Log Shrinks </span><span> 462</span> <span>DB_LOG_SHRINKS_009_HELP=Total number of log shrinks for this database. </span><span> 463</span> <span> 464</span> <span> 465</span> <span>DB_DBMIRRORING_BYTES_SENT_009_NAME=Bytes Sent/sec </span><span> 466</span> <span>DB_DBMIRRORING_BYTES_SENT_009_HELP=Number of bytes sent per second </span><span> 467</span> <span> 468</span> <span> 469</span> <span>DB_DBMIRRORING_PAGES_SENT_009_NAME=Pages Sent/sec </span><span> 470</span> <span>DB_DBMIRRORING_PAGES_SENT_009_HELP=Number of pages sent per second </span><span> 471</span> <span> 472</span> <span> 473</span> <span>DB_DBMIRRORING_SENDS_009_NAME=Sends/sec </span><span> 474</span> <span>DB_DBMIRRORING_SENDS_009_HELP=Number of sends initiated per second </span><span> 475</span> <span> 476</span> <span> 477</span> <span>DB_DBMIRRORING_TRANSACTION_DELAY_009_NAME=Transaction Delay </span><span> 478</span> <span>DB_DBMIRRORING_TRANSACTION_DELAY_009_HELP=Average delay in transaction termination waiting for acknowledgement </span><span> 479</span> <span> 480</span> <span> 481</span> <span>DB_DBM_REDO_DELTA_009_NAME=Redo Queue KB </span><span> 482</span> <span>DB_DBM_REDO_DELTA_009_HELP=Total number of kilobytes that redo on the mirror database is behind the hardened log </span><span> 483</span> <span> 484</span> <span> 485</span> <span>DB_DBM_REDO_RATE_009_NAME=Redo Bytes/sec </span><span> 486</span> <span>DB_DBM_REDO_RATE_009_HELP=Number of bytes of log redone by the mirror database per second </span><span> 487</span> <span> 488</span> <span> 489</span> <span>DB_DBM_LOG_SEND_QUEUE_009_NAME=Log Send Queue KB </span><span> 490</span> <span>DB_DBM_LOG_SEND_QUEUE_009_HELP=Total number of kilobytes of log that have not been sent to the mirror server </span><span> 491</span> <span> 492</span> <span> 493</span> <span>DB_DBM_BYTES_RECEIVED_009_NAME=Bytes Received/sec </span><span> 494</span> <span>DB_DBM_BYTES_RECEIVED_009_HELP=Number of bytes received per second </span><span> 495</span> <span> 496</span> <span> 497</span> <span>DB_DBM_RECEIVES_009_NAME=Receives/sec </span><span> 498</span> <span>DB_DBM_RECEIVES_009_HELP=Number of mirroring message receives per second </span><span> 499</span> <span> 500</span> <span> 501</span> <span>DB_DBM_LOG_BYTES_RECEIVED_009_NAME=Log Bytes Received/sec </span><span> 502</span> <span>DB_DBM_LOG_BYTES_RECEIVED_009_HELP=Number of bytes of log received per second </span><span> 503</span> <span> 504</span> <span> 505</span> <span>DB_DBM_LOG_BYTES_SENT_009_NAME=Log Bytes Sent/sec </span><span> 506</span> <span>DB_DBM_LOG_BYTES_SENT_009_HELP=Number of bytes of log sent per second </span><span> 507</span> <span> 508</span> <span> 509</span> <span>DB_DBM_ACK_TIME_009_NAME=Send/Receive Ack Time </span><span> 510</span> <span>DB_DBM_ACK_TIME_009_HELP=Milliseconds packets waited in flow control per second. </span><span> 511</span> <span> 512</span> <span> 513</span> <span>LATCH_WAITS_NP_009_NAME=Latch Waits/sec </span><span> 514</span> <span>LATCH_WAITS_NP_009_HELP=Number of latch requests that could not be granted immediately and had to wait before being granted. </span><span> 515</span> <span> 516</span> <span> 517</span> <span>LATCH_AVG_WAIT_NP_009_NAME=Average Latch Wait Time (ms) </span><span> 518</span> <span>LATCH_AVG_WAIT_NP_009_HELP=Average latch wait time (milliseconds) for latch requests that had to wait. </span><span> 519</span> <span> 520</span> <span> 521</span> <span>LATCH_AVG_WAIT_BASE_009_NAME=Average Latch Wait Time Base </span><span> 522</span> <span>LATCH_AVG_WAIT_BASE_009_HELP=Base for Average Latch Wait Time. </span><span> 523</span> <span> 524</span> <span> 525</span> <span>LATCH_TOTAL_WAIT_NP_009_NAME=Total Latch Wait Time (ms) </span><span> 526</span> <span>LATCH_TOTAL_WAIT_NP_009_HELP=Total latch wait time (milliseconds) for latch requests that had to wait in the last second. </span><span> 527</span> <span> 528</span> <span> 529</span> <span>LATCH_SUPERLATCHES_009_NAME=Number of SuperLatches </span><span> 530</span> <span>LATCH_SUPERLATCHES_009_HELP=Number of latches that are currently SuperLatches. </span><span> 531</span> <span> 532</span> <span> 533</span> <span>LATCH_PROMOTIONS_009_NAME=SuperLatch Promotions/sec </span><span> 534</span> <span>LATCH_PROMOTIONS_009_HELP=Number of latches that have been promoted to SuperLatches </span><span> 535</span> <span> 536</span> <span> 537</span> <span>LATCH_DEMOTIONS_009_NAME=SuperLatch Demotions/sec </span><span> 538</span> <span>LATCH_DEMOTIONS_009_HELP=Number of SuperLatches that have been demoted to regular latches </span><span> 539</span> <span> 540</span> <span> 541</span> <span>AM_FULL_SCAN_009_NAME=Full Scans/sec </span><span> 542</span> <span>AM_FULL_SCAN_009_HELP=Number of unrestricted full scans. These can either be base table or full index scans. </span><span> 543</span> <span> 544</span> <span> 545</span> <span>AM_RANGE_SCAN_009_NAME=Range Scans/sec </span><span> 546</span> <span>AM_RANGE_SCAN_009_HELP=Number of qualified range scans through indexes per second. </span><span> 547</span> <span> 548</span> <span> 549</span> <span>AM_PROBE_SCAN_009_NAME=Probe Scans/sec </span><span> 550</span> <span>AM_PROBE_SCAN_009_HELP=Number of probe scans per second that are used to find at most one single qualified row in an index or base table directly. </span><span> 551</span> <span> 552</span> <span> 553</span> <span>AM_SCAN_REPOSITION_009_NAME=Scan Point Revalidations/sec </span><span> 554</span> <span>AM_SCAN_REPOSITION_009_HELP=Number of times the scan point had to be revalidated to continue the scan. </span><span> 555</span> <span> 556</span> <span> 557</span> <span>AM_WORKFILES_CREATED_009_NAME=Workfiles Created/sec </span><span> 558</span> <span>AM_WORKFILES_CREATED_009_HELP=Number of work files created per second. For example, work files could be used to store temporary results for hash joins and hash aggregates. </span><span> 559</span> <span> 560</span> <span> 561</span> <span>AM_WORKTABLES_CREATED_009_NAME=Worktables Created/sec </span><span> 562</span> <span>AM_WORKTABLES_CREATED_009_HELP=Number of work tables created per second. For example, work tables could be used to store temporary results for query spool, LOB variables, XML variables, and cursors. </span><span> 563</span> <span> 564</span> <span> 565</span> <span>AM_WORKTABLES_FROM_CACHE_009_NAME=Worktables From Cache Ratio </span><span> 566</span> <span>AM_WORKTABLES_FROM_CACHE_009_HELP=Percentage of work tables created where the initial two pages of the work table were not allocated but were immediately available from the work table cache. </span><span> 567</span> <span> 568</span> <span> 569</span> <span>AM_WORKTABLES_FROM_CACHE_BASE_009_NAME=Worktables From Cache Base </span><span> 570</span> <span>AM_WORKTABLES_FROM_CACHE_BASE_009_HELP=Percent of worktables from cache base. </span><span> 571</span> <span> 572</span> <span> 573</span> <span>AM_FORWARDED_RECS_009_NAME=Forwarded Records/sec </span><span> 574</span> <span>AM_FORWARDED_RECS_009_HELP=Number of records fetched through forwarded record pointers. </span><span> 575</span> <span> 576</span> <span> 577</span> <span>AM_GHOSTED_SKIPS_009_NAME=Skipped Ghosted Records/sec </span><span> 578</span> <span>AM_GHOSTED_SKIPS_009_HELP=Number of ghosted records per second skipped during scans. </span><span> 579</span> <span> 580</span> <span> 581</span> <span>AM_INDEX_SEARCHES_009_NAME=Index Searches/sec </span><span> 582</span> <span>AM_INDEX_SEARCHES_009_HELP=Number of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index. </span><span> 583</span> <span> 584</span> <span> 585</span> <span>AM_FREESPACE_SCANS_009_NAME=FreeSpace Scans/sec </span><span> 586</span> <span>AM_FREESPACE_SCANS_009_HELP=Number of scans per second that were initiated to search for free space within pages already allocated to an allocation unit to insert or modify record fragments. Each scan may find multiple pages. </span><span> 587</span> <span> 588</span> <span> 589</span> <span>AM_FREESPACE_PAGES_009_NAME=FreeSpace Page Fetches/sec </span><span> 590</span> <span>AM_FREESPACE_PAGES_009_HELP=Number of pages fetched per second by free space scans. These scans search for free space within pages already allocated to an allocation unit, to satisfy requests to insert or modify record fragments. </span><span> 591</span> <span> 592</span> <span> 593</span> <span>AM_PAGES_ALLOCATED_009_NAME=Pages Allocated/sec </span><span> 594</span> <span>AM_PAGES_ALLOCATED_009_HELP=Number of pages allocated per second in all databases in this SQL Server instance. These include pages allocations from both mixed extents and uniform extents. </span><span> 595</span> <span> 596</span> <span> 597</span> <span>AM_EXTENTS_ALLOCATED_009_NAME=Extents Allocated/sec </span><span> 598</span> <span>AM_EXTENTS_ALLOCATED_009_HELP=Number of extents allocated per second in all databases in this SQL Server instance. </span><span> 599</span> <span> 600</span> <span> 601</span> <span>AM_SINGLE_PAGE_ALLOCS_009_NAME=Mixed page allocations/sec </span><span> 602</span> <span>AM_SINGLE_PAGE_ALLOCS_009_HELP=Number of pages allocated per second from mixed extents. These could be used for storing the IAM pages and the first eight pages that are allocated to an allocation unit. </span><span> 603</span> <span> 604</span> <span> 605</span> <span>AM_EXTENTS_DEALLOCATED_009_NAME=Extent Deallocations/sec </span><span> 606</span> <span>AM_EXTENTS_DEALLOCATED_009_HELP=Number of extents deallocated per second in all databases in this SQL Server instance. </span><span> 607</span> <span> 608</span> <span> 609</span> <span>AM_PAGE_DEALLOCS_009_NAME=Page Deallocations/sec </span><span> 610</span> <span>AM_PAGE_DEALLOCS_009_HELP=Number of pages deallocated per second in all databases in this SQL Server instance. These include pages from mixed extents and uniform extents. </span><span> 611</span> <span> 612</span> <span> 613</span> <span>AM_PAGE_SPLITS_009_NAME=Page Splits/sec </span><span> 614</span> <span>AM_PAGE_SPLITS_009_HELP=Number of page splits per second that occur as a result of overflowing index pages. </span><span> 615</span> <span> 616</span> <span> 617</span> <span>AM_LOCKESCALATIONS_009_NAME=Table Lock Escalations/sec </span><span> 618</span> <span>AM_LOCKESCALATIONS_009_HELP=The number of times locks on a table were escalated. </span><span> 619</span> <span> 620</span> <span> 621</span> <span>AM_DEFDROPPEDROWSETQUEUELENGTH_009_NAME=Deferred Dropped rowsets </span><span> 622</span> <span>AM_DEFDROPPEDROWSETQUEUELENGTH_009_HELP=The number of rowsets created as a result of aborted online index build operations that are waiting to be dropped by the background task that cleans up deferred dropped rowsets. </span><span> 623</span> <span> 624</span> <span> 625</span> <span>AM_DEFDROPPEDROWSETSCLEANED_009_NAME=Dropped rowset cleanups/sec </span><span> 626</span> <span>AM_DEFDROPPEDROWSETSCLEANED_009_HELP=The number of rowsets per second created as a result of aborted online index build operations that were successfully dropped by the background task that cleans up deferred dropped rowsets. </span><span> 627</span> <span> 628</span> <span> 629</span> <span>AM_DEFDROPPEDROWSETSSKIPPED_009_NAME=Dropped rowsets skipped/sec </span><span> 630</span> <span>AM_DEFDROPPEDROWSETSSKIPPED_009_HELP=The number of rowsets per second created as a result of aborted online index build operations that were skipped by the background task that cleans up deferred dropped rowsets created. </span><span> 631</span> <span> 632</span> <span> 633</span> <span>AM_DDALLOCUNITQUEUELENGTH_009_NAME=Deferred dropped AUs </span><span> 634</span> <span>AM_DDALLOCUNITQUEUELENGTH_009_HELP=The number of allocation units waiting to be dropped by the background task that cleans up deferred dropped allocation units. </span><span> 635</span> <span> 636</span> <span> 637</span> <span>AM_DDALLOCUNITSCLEANED_009_NAME=AU cleanups/sec </span><span> 638</span> <span>AM_DDALLOCUNITSCLEANED_009_HELP=The number of allocation units per second that were successfully dropped by the background task that cleans up deferred dropped allocation units. Each allocation unit drop requires multiple batches. </span><span> 639</span> <span> 640</span> <span> 641</span> <span>AM_DDALLOCUNITBATCHESCOMPLETED_009_NAME=AU cleanup batches/sec </span><span> 642</span> <span>AM_DDALLOCUNITBATCHESCOMPLETED_009_HELP=The number of batches that completed successfully per second by the background task that cleans up deferred dropped allocation units. </span><span> 643</span> <span> 644</span> <span> 645</span> <span>AM_DDALLOCUNITBATCHESFAILED_009_NAME=Failed AU cleanup batches/sec </span><span> 646</span> <span>AM_DDALLOCUNITBATCHESFAILED_009_HELP=The number of batches per second that failed and required retry, by the background task that cleans up deferred dropped allocation units. Failure could be due to lack of memory or disk space, hardware failure and other reasons. </span><span> 647</span> <span> 648</span> <span> 649</span> <span>TREE_PAGE_COOKIE_SUCCEED_009_NAME=Used tree page cookie </span><span> 650</span> <span>TREE_PAGE_COOKIE_SUCCEED_009_HELP=Number of times a tree page cookie was used successfully during an index search since no change happened on the parent page of the tree page. The cookie is used to speed up index search. </span><span> 651</span> <span> 652</span> <span> 653</span> <span>TREE_PAGE_COOKIE_FAIL_009_NAME=Failed tree page cookie </span><span> 654</span> <span>TREE_PAGE_COOKIE_FAIL_009_HELP=The number of times that a tree page cookie could not be used during an index search since changes happened on the parent pages of those tree pages. The cookie is used to speed up index search. </span><span> 655</span> <span> 656</span> <span> 657</span> <span>LEAF_PAGE_COOKIE_SUCCEED_009_NAME=Used leaf page cookie </span><span> 658</span> <span>LEAF_PAGE_COOKIE_SUCCEED_009_HELP=Number of times a leaf page cookie was used successfully during an index search since no change happened on the leaf page. The cookie is used to speed up index search. </span><span> 659</span> <span> 660</span> <span> 661</span> <span>LEAF_PAGE_COOKIE_FAIL_009_NAME=Failed leaf page cookie </span><span> 662</span> <span>LEAF_PAGE_COOKIE_FAIL_009_HELP=The number of times that a leaf page cookie could not be used during an index search since changes happened on the leaf page. The cookie is used to speed up index search. </span><span> 663</span> <span> 664</span> <span> 665</span> <span>AM_LOBSS_PROVIDERS_CREATED_009_NAME=LobSS Provider Create Count </span><span> 666</span> <span>AM_LOBSS_PROVIDERS_CREATED_009_HELP=Count of LOB Storage Service Providers created. One worktable created per LOB Storage Service Provider. </span><span> 667</span> <span> 668</span> <span> 669</span> <span>AM_LOBSS_PROVIDERS_DESTROYED_009_NAME=LobSS Provider Destroy Count </span><span> 670</span> <span>AM_LOBSS_PROVIDERS_DESTROYED_009_HELP=Count of LOB Storage Service Providers destroyed. </span><span> 671</span> <span> 672</span> <span> 673</span> <span>AM_LOBSS_PROVIDERS_TRUNCATED_009_NAME=LobSS Provider Truncation Count </span><span> 674</span> <span>AM_LOBSS_PROVIDERS_TRUNCATED_009_HELP=Count of LOB Storage Service Providers truncated. </span><span> 675</span> <span> 676</span> <span> 677</span> <span>AM_LOBSS_LOBHANDLES_CREATED_009_NAME=LobHandle Create Count </span><span> 678</span> <span>AM_LOBSS_LOBHANDLES_CREATED_009_HELP=Count of temporary LOBs created. </span><span> 679</span> <span> 680</span> <span> 681</span> <span>AM_LOBSS_LOBHANDLES_DESTROYED_009_NAME=LobHandle Destroy Count </span><span> 682</span> <span>AM_LOBSS_LOBHANDLES_DESTROYED_009_HELP=Count of temporary LOBs destroyed. </span><span> 683</span> <span> 684</span> <span> 685</span> <span>AM_ORPHANS_CREATED_009_NAME=By-reference Lob Create Count </span><span> 686</span> <span>AM_ORPHANS_CREATED_009_HELP=Count of large object (LOB) values that were passed by reference. By-reference lobs are used in certain bulk operations to avoid the cost of passing them by value. </span><span> 687</span> <span> 688</span> <span> 689</span> <span>AM_ORPHANS_INSERTED_009_NAME=By-reference Lob Use Count </span><span> 690</span> <span>AM_ORPHANS_INSERTED_009_HELP=Count of by-reference lob values that were used. By-reference lobs are used in certain bulk operations to avoid the cost of passing them by value. </span><span> 691</span> <span> 692</span> <span> 693</span> <span>AM_COLS_PUSHED_OFFROW_009_NAME=Count Push Off Row </span><span> 694</span> <span>AM_COLS_PUSHED_OFFROW_009_HELP=Count of values that were pushed from in-row to off-row. </span><span> 695</span> <span> 696</span> <span> 697</span> <span>AM_COLS_PULLED_INROW_009_NAME=Count Pull In Row </span><span> 698</span> <span>AM_COLS_PULLED_INROW_009_HELP=Count of values that were pulled in-row from off-row. </span><span> 699</span> <span> 700</span> <span> 701</span> <span>AM_LOB_READAHEAD_ISSUED_009_NAME=Count Lob Readahead </span><span> 702</span> <span>AM_LOB_READAHEAD_ISSUED_009_HELP=Count of lob pages on which readahead was issued. </span><span> 703</span> <span> 704</span> <span> 705</span> <span>SQL_ERROR_RATE_009_NAME=Errors/sec </span><span> 706</span> <span>SQL_ERROR_RATE_009_HELP=Number of errors/sec </span><span> 707</span> <span> 708</span> <span> 709</span> <span>SQL_BATCH_REQ_009_NAME=Batch Requests/sec </span><span> 710</span> <span>SQL_BATCH_REQ_009_HELP=Number of SQL batch requests received by server. </span><span> 711</span> <span> 712</span> <span> 713</span> <span>SQL_UNIVPARAM_009_NAME=Forced Parameterizations/sec </span><span> 714</span> <span>SQL_UNIVPARAM_009_HELP=Number of statements parameterized by forced parameterization per second. </span><span> 715</span> <span> 716</span> <span> 717</span> <span>SQL_AUTOPARAM_REQ_009_NAME=Auto-Param Attempts/sec </span><span> 718</span> <span>SQL_AUTOPARAM_REQ_009_HELP=Number of auto-parameterization attempts. </span><span> 719</span> <span> 720</span> <span> 721</span> <span>SQL_AUTOPARAM_FAIL_009_NAME=Failed Auto-Params/sec </span><span> 722</span> <span>SQL_AUTOPARAM_FAIL_009_HELP=Number of failed auto-parameterizations. </span><span> 723</span> <span> 724</span> <span> 725</span> <span>SQL_AUTOPARAM_SAFE_009_NAME=Safe Auto-Params/sec </span><span> 726</span> <span>SQL_AUTOPARAM_SAFE_009_HELP=Number of safe auto-parameterizations. </span><span> 727</span> <span> 728</span> <span> 729</span> <span>SQL_AUTOPARAM_UNSAFE_009_NAME=Unsafe Auto-Params/sec </span><span> 730</span> <span>SQL_AUTOPARAM_UNSAFE_009_HELP=Number of unsafe auto-parameterizations. </span><span> 731</span> <span> 732</span> <span> 733</span> <span>SQL_COMPILES_009_NAME=SQL Compilations/sec </span><span> 734</span> <span>SQL_COMPILES_009_HELP=Number of SQL compilations. </span><span> 735</span> <span> 736</span> <span> 737</span> <span>SQL_RECOMPILES_009_NAME=SQL Re-Compilations/sec </span><span> 738</span> <span>SQL_RECOMPILES_009_HELP=Number of SQL re-compiles. </span><span> 739</span> <span> 740</span> <span> 741</span> <span>SQL_ATTENTION_RATE_009_NAME=SQL Attention rate </span><span> 742</span> <span>SQL_ATTENTION_RATE_009_HELP=Number of attentions per second. </span><span> 743</span> <span> 744</span> <span> 745</span> <span>PLAN_CACHE_HIT_RATIO_009_NAME=Cache Hit Ratio </span><span> 746</span> <span>PLAN_CACHE_HIT_RATIO_009_HELP=Ratio between cache hits and lookups </span><span> 747</span> <span> 748</span> <span> 749</span> <span>PLAN_CACHE_HIT_RATIO_BASE_009_NAME=Cache Hit Ratio Base </span><span> 750</span> <span>PLAN_CACHE_HIT_RATIO_BASE_009_HELP=Base for prior entry </span><span> 751</span> <span> 752</span> <span> 753</span> <span>PLAN_CACHE_PGS_IN_USE_009_NAME=Cache Pages </span><span> 754</span> <span>PLAN_CACHE_PGS_IN_USE_009_HELP=Number of 8k pages used by cache objects </span><span> 755</span> <span> 756</span> <span> 757</span> <span>PLAN_CACHE_OBJECT_COUNT_009_NAME=Cache Object Counts </span><span> 758</span> <span>PLAN_CACHE_OBJECT_COUNT_009_HELP=Number of cache objects in the cache </span><span> 759</span> <span> 760</span> <span> 761</span> <span>PLAN_CACHE_USE_COUNT_009_NAME=Cache Objects in use </span><span> 762</span> <span>PLAN_CACHE_USE_COUNT_009_HELP=Number of cache objects in use </span><span> 763</span> <span> 764</span> <span> 765</span> <span>CURSOR_CACHE_HIT_RATIO_009_NAME=Cache Hit Ratio </span><span> 766</span> <span>CURSOR_CACHE_HIT_RATIO_009_HELP=Ratio between cache hits and lookups </span><span> 767</span> <span> 768</span> <span> 769</span> <span>CURSOR_CACHE_HIT_RATIO_BASE_009_NAME=Cache Hit Ratio Base </span><span> 770</span> <span>CURSOR_CACHE_HIT_RATIO_BASE_009_HELP=Base for prior entry </span><span> 771</span> <span> 772</span> <span> 773</span> <span>CURSOR_CACHE_COUNT_009_NAME=Cached Cursor Counts </span><span> 774</span> <span>CURSOR_CACHE_COUNT_009_HELP=Number of cursors of a given type in the cache </span><span> 775</span> <span> 776</span> <span> 777</span> <span>CURSOR_CACHE_USE_COUNT_009_NAME=Cursor Cache Use Counts/sec </span><span> 778</span> <span>CURSOR_CACHE_USE_COUNT_009_HELP=Times each type of cached cursor has been used </span><span> 779</span> <span> 780</span> <span> 781</span> <span>CURSOR_REQ_009_NAME=Cursor Requests/sec </span><span> 782</span> <span>CURSOR_REQ_009_HELP=Number of SQL cursor requests received by server. </span><span> 783</span> <span> 784</span> <span> 785</span> <span>CURSOR_IN_USE_009_NAME=Active cursors </span><span> 786</span> <span>CURSOR_IN_USE_009_HELP=Number of active cursors. </span><span> 787</span> <span> 788</span> <span> 789</span> <span>CURSOR_MEMORY_USAGE_009_NAME=Cursor memory usage </span><span> 790</span> <span>CURSOR_MEMORY_USAGE_009_HELP=Amount of memory consumed by cursors (KB). </span><span> 791</span> <span> 792</span> <span> 793</span> <span>CURSOR_WORKTABLE_USAGE_009_NAME=Cursor worktable usage </span><span> 794</span> <span>CURSOR_WORKTABLE_USAGE_009_HELP=Number of worktables used by cursors. </span><span> 795</span> <span> 796</span> <span> 797</span> <span>CURSOR_PLANS_009_NAME=Number of active cursor plans </span><span> 798</span> <span>CURSOR_PLANS_009_HELP=Number of cursor plans. </span><span> 799</span> <span> 800</span> <span> 801</span> <span>CURSOR_CONVERSION_RATE_009_NAME=Cursor conversion rate </span><span> 802</span> <span>CURSOR_CONVERSION_RATE_009_HELP=Number of cursor conversions/sec. </span><span> 803</span> <span> 804</span> <span> 805</span> <span>CURSOR_ASYNC_POPULATION_009_NAME=Async population count </span><span> 806</span> <span>CURSOR_ASYNC_POPULATION_009_HELP=Number of cursors being populated asynchronously. </span><span> 807</span> <span> 808</span> <span> 809</span> <span>CURSOR_XSTMT_FLUSH_009_NAME=Cursor flushes </span><span> 810</span> <span>CURSOR_XSTMT_FLUSH_009_HELP=Total number of times a flush for a cursor xstmt occured. </span><span> 811</span> <span> 812</span> <span> 813</span> <span>MEMORY_CONNECTION_MEMORY_009_NAME=Connection Memory (KB) </span><span> 814</span> <span>MEMORY_CONNECTION_MEMORY_009_HELP=Total amount of dynamic memory the server is using for maintaining connections </span><span> 815</span> <span> 816</span> <span> 817</span> <span>MEMORY_MEMGRANT_OUTSTANDING_009_NAME=Granted Workspace Memory (KB) </span><span> 818</span> <span>MEMORY_MEMGRANT_OUTSTANDING_009_HELP=Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations. </span><span> 819</span> <span> 820</span> <span> 821</span> <span>MEMORY_LOCK_MEMORY_009_NAME=Lock Memory (KB) </span><span> 822</span> <span>MEMORY_LOCK_MEMORY_009_HELP=Total amount of dynamic memory the server is using for locks </span><span> 823</span> <span> 824</span> <span> 825</span> <span>MEMORY_LOCKS_ALLOCATED_009_NAME=Lock Blocks Allocated </span><span> 826</span> <span>MEMORY_LOCKS_ALLOCATED_009_HELP=The current number of allocated lock blocks. </span><span> 827</span> <span> 828</span> <span> 829</span> <span>MEMORY_LOCKOWNERS_ALLOCATED_009_NAME=Lock Owner Blocks Allocated </span><span> 830</span> <span>MEMORY_LOCKOWNERS_ALLOCATED_009_HELP=The current number of allocated lock owner blocks. </span><span> 831</span> <span> 832</span> <span> 833</span> <span>MEMORY_LOCKS_009_NAME=Lock Blocks </span><span> 834</span> <span>MEMORY_LOCKS_009_HELP=The current number of lock blocks that are in use on the server. Refreshed periodically. </span><span> 835</span> <span> 836</span> <span> 837</span> <span>MEMORY_LOCKOWNERS_009_NAME=Lock Owner Blocks </span><span> 838</span> <span>MEMORY_LOCKOWNERS_009_HELP=The number of lock owner blocks that are currently in use on the server. Refreshed periodically. </span><span> 839</span> <span> 840</span> <span> 841</span> <span>MEMORY_MEMGRANT_MAXIMUM_009_NAME=Maximum Workspace Memory (KB) </span><span> 842</span> <span>MEMORY_MEMGRANT_MAXIMUM_009_HELP=Total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations. </span><span> 843</span> <span> 844</span> <span> 845</span> <span>MEMORY_MEMGRANT_ACQUIRES_009_NAME=Memory Grants Outstanding </span><span> 846</span> <span>MEMORY_MEMGRANT_ACQUIRES_009_HELP=Current number of processes that have successfully acquired a workspace memory grant </span><span> 847</span> <span> 848</span> <span> 849</span> <span>MEMORY_MEMGRANT_WAITERS_009_NAME=Memory Grants Pending </span><span> 850</span> <span>MEMORY_MEMGRANT_WAITERS_009_HELP=Current number of processes waiting for a workspace memory grant </span><span> 851</span> <span> 852</span> <span> 853</span> <span>MEMORY_OPTIMIZER_MEMORY_009_NAME=Optimizer Memory (KB) </span><span> 854</span> <span>MEMORY_OPTIMIZER_MEMORY_009_HELP=Total amount of dynamic memory the server is using for query optimization </span><span> 855</span> <span> 856</span> <span> 857</span> <span>MEMORY_SQL_CACHE_MEMORY_009_NAME=SQL Cache Memory (KB) </span><span> 858</span> <span>MEMORY_SQL_CACHE_MEMORY_009_HELP=Total amount of dynamic memory the server is using for the dynamic SQL cache </span><span> 859</span> <span> 860</span> <span> 861</span> <span>MEMORY_SERVER_MEMORY_TARGET_009_NAME=Target Server Memory (KB) </span><span> 862</span> <span>MEMORY_SERVER_MEMORY_TARGET_009_HELP=Total amount of dynamic memory the server is willing to consume </span><span> 863</span> <span> 864</span> <span> 865</span> <span>MEMORY_SERVER_MEMORY_009_NAME=Total Server Memory (KB) </span><span> 866</span> <span>MEMORY_SERVER_MEMORY_009_HELP=Total amount of dynamic memory the server is currently consuming </span><span> 867</span> <span> 868</span> <span> 869</span> <span>QUERY_INSTANCE_009_NAME=Query </span><span> 870</span> <span>QUERY_INSTANCE_009_HELP=As defined by the user. </span><span> 871</span> <span> 872</span> <span> 873</span> <span>RUNNING_INSTANCE_009_NAME=Running </span><span> 874</span> <span>RUNNING_INSTANCE_009_HELP=The number of replication agents currently running. </span><span> 875</span> <span> 876</span> <span> 877</span> <span>UPLOAD_INSTANCE_009_NAME=Uploaded Changes/sec </span><span> 878</span> <span>UPLOAD_INSTANCE_009_HELP=The number of rows per second merged from the Subscriber to the Publisher. </span><span> 879</span> <span> 880</span> <span> 881</span> <span>DOWNLOAD_INSTANCE_009_NAME=Downloaded Changes/sec </span><span> 882</span> <span>DOWNLOAD_INSTANCE_009_HELP=The number of rows per second merged from the Publisher to the Subscriber. </span><span> 883</span> <span> 884</span> <span> 885</span> <span>MERGE_CONFLICTS_INSTANCE_009_NAME=Conflicts/sec </span><span> 886</span> <span>MERGE_CONFLICTS_INSTANCE_009_HELP=The number of conflicts per second occurring during the merge process. </span><span> 887</span> <span> 888</span> <span> 889</span> <span>LOGREADER_LATENCY_INSTANCE_009_NAME=Logreader:Delivery Latency </span><span> 890</span> <span>LOGREADER_LATENCY_INSTANCE_009_HELP=The current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor. </span><span> 891</span> <span> 892</span> <span> 893</span> <span>LOGREADER_COMMANDS_INSTANCE_009_NAME=Logreader:Delivered Cmds/sec </span><span> 894</span> <span>LOGREADER_COMMANDS_INSTANCE_009_HELP=The number of commands per second delivered to the Distributor. </span><span> 895</span> <span> 896</span> <span> 897</span> <s></s>
Déclaration：
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn
Article précédent：SQLSERVER数据库备份操作和还原操作做了什么Article suivant：VB.net数据库编程（03）：一个SQLserver连接查询的简单例子