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>
陳述
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn
說明InnoDB重做日誌和撤消日誌的作用。Apr 15, 2025 am 12:16 AMInnoDB使用redologs和undologs確保數據一致性和可靠性。 1.redologs記錄數據頁修改，確保崩潰恢復和事務持久性。 2.undologs記錄數據原始值，支持事務回滾和MVCC。
在解釋輸出（類型，鍵，行，額外）中要查找的關鍵指標是什麼？Apr 15, 2025 am 12:15 AMEXPLAIN命令的關鍵指標包括type、key、rows和Extra。 1）type反映查詢的訪問類型，值越高效率越高，如const優於ALL。 2）key顯示使用的索引，NULL表示無索引。 3）rows預估掃描行數，影響查詢性能。 4）Extra提供額外信息，如Usingfilesort提示需要優化。
在解釋中使用臨時狀態以及如何避免它是什麼？Apr 15, 2025 am 12:14 AMUsingtemporary在MySQL查詢中表示需要創建臨時表，常見於使用DISTINCT、GROUPBY或非索引列的ORDERBY。可以通過優化索引和重寫查詢避免其出現，提升查詢性能。具體來說，Usingtemporary出現在EXPLAIN輸出中時，意味著MySQL需要創建臨時表來處理查詢。這通常發生在以下情況：1)使用DISTINCT或GROUPBY時進行去重或分組；2)ORDERBY包含非索引列時進行排序；3)使用複雜的子查詢或聯接操作。優化方法包括：1)為ORDERBY和GROUPB
描述不同的SQL交易隔離級別（讀取未讀取，讀取，可重複的讀取，可序列化）及其在MySQL/InnoDB中的含義。Apr 15, 2025 am 12:11 AMMySQL/InnoDB支持四種事務隔離級別：ReadUncommitted、ReadCommitted、RepeatableRead和Serializable。 1.ReadUncommitted允許讀取未提交數據，可能導致臟讀。 2.ReadCommitted避免臟讀，但可能發生不可重複讀。 3.RepeatableRead是默認級別，避免臟讀和不可重複讀，但可能發生幻讀。 4.Serializable避免所有並發問題，但降低並發性。選擇合適的隔離級別需平衡數據一致性和性能需求。
MySQL與其他數據庫：比較選項Apr 15, 2025 am 12:08 AMMySQL適合Web應用和內容管理系統，因其開源、高性能和易用性而受歡迎。 1)與PostgreSQL相比，MySQL在簡單查詢和高並發讀操作上表現更好。 2)相較Oracle，MySQL因開源和低成本更受中小企業青睞。 3)對比MicrosoftSQLServer，MySQL更適合跨平台應用。 4)與MongoDB不同，MySQL更適用於結構化數據和事務處理。
MySQL索引基數如何影響查詢性能？Apr 14, 2025 am 12:18 AMMySQL索引基数对查询性能有显著影响：1.高基数索引能更有效地缩小数据范围，提高查询效率；2.低基数索引可能导致全表扫描，降低查询性能；3.在联合索引中，应将高基数列放在前面以优化查询。
MySQL：新用戶的資源和教程Apr 14, 2025 am 12:16 AMMySQL學習路徑包括基礎知識、核心概念、使用示例和優化技巧。 1)了解表、行、列、SQL查詢等基礎概念。 2)學習MySQL的定義、工作原理和優勢。 3)掌握基本CRUD操作和高級用法，如索引和存儲過程。 4)熟悉常見錯誤調試和性能優化建議，如合理使用索引和優化查詢。通過這些步驟，你將全面掌握MySQL的使用和優化。
現實世界Mysql：示例和用例Apr 14, 2025 am 12:15 AMMySQL在現實世界的應用包括基礎數據庫設計和復雜查詢優化。 1)基本用法：用於存儲和管理用戶數據，如插入、查詢、更新和刪除用戶信息。 2)高級用法：處理複雜業務邏輯，如電子商務平台的訂單和庫存管理。 3)性能優化：通過合理使用索引、分區表和查詢緩存來提升性能。
熱AI工具
Undresser.AI Undress
人工智慧驅動的應用程序，用於創建逼真的裸體照片
AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。
Undress AI Tool
免費脫衣圖片
Clothoff.io
AI脫衣器
AI Hentai Generator
免費產生 AI 無盡。
熱門文章
R.E.P.O.能量晶體解釋及其做什麼（黃色晶體）
4 週前By尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.最佳圖形設置
4 週前By尊渡假赌尊渡假赌尊渡假赌
刺客信條陰影：貝殼謎語解決方案
2 週前ByDDD
R.E.P.O.如果您聽不到任何人，如何修復音頻
4 週前By尊渡假赌尊渡假赌尊渡假赌
WWE 2K25：如何解鎖Myrise中的所有內容
1 個月前By尊渡假赌尊渡假赌尊渡假赌
熱工具
SecLists
SecLists是最終安全測試人員的伙伴。它是一個包含各種類型清單的集合，這些清單在安全評估過程中經常使用，而且都在一個地方。 SecLists透過方便地提供安全測試人員可能需要的所有列表，幫助提高安全測試的效率和生產力。清單類型包括使用者名稱、密碼、URL、模糊測試有效載荷、敏感資料模式、Web shell等等。測試人員只需將此儲存庫拉到新的測試機上，他就可以存取所需的每種類型的清單。
Atom編輯器mac版下載
最受歡迎的的開源編輯器
DVWA
Damn Vulnerable Web App (DVWA) 是一個PHP/MySQL的Web應用程序，非常容易受到攻擊。它的主要目標是成為安全專業人員在合法環境中測試自己的技能和工具的輔助工具，幫助Web開發人員更好地理解保護網路應用程式的過程，並幫助教師/學生在課堂環境中教授/學習Web應用程式安全性。 DVWA的目標是透過簡單直接的介面練習一些最常見的Web漏洞，難度各不相同。請注意，該軟體中
mPDF
mPDF是一個PHP庫，可以從UTF-8編碼的HTML產生PDF檔案。原作者Ian Back編寫mPDF以從他的網站上「即時」輸出PDF文件，並處理不同的語言。與原始腳本如HTML2FPDF相比，它的速度較慢，並且在使用Unicode字體時產生的檔案較大，但支援CSS樣式等，並進行了大量增強。支援幾乎所有語言，包括RTL（阿拉伯語和希伯來語）和CJK（中日韓）。支援嵌套的區塊級元素（如P、DIV），
SAP NetWeaver Server Adapter for Eclipse
將Eclipse與SAP NetWeaver應用伺服器整合。
