项目维护需要,要定时返回如下指标,如何写select语句可以获得到这些指标,请各位老大帮忙答疑
全局指标:
服务器名
数据缓冲区命中率
可用缓存数
用户连接数
锁总数
进程锁总数
用户锁数单数据库指标:
数据库ID数据库ID和数据库名称是一个意思吧
数据库名称已有获得方法
数据库大小已有获得方法
数据库未分配空间大小未分配空间,这个有可能获得么?
数据库保留空间大小保留空间和未使用空间是一个意思么?
数据库已使用数据空间大小已有获得方法
数据库索引空间大小
数据库未使用空间大小已有获得方法
无法确定是全局指标还是单数据库指标
数据库最大连接数
数据库工作线程数
数据库动态内存占用
全局指标:
服务器名
数据缓冲区命中率
可用缓存数
用户连接数
锁总数
进程锁总数
用户锁数单数据库指标:
数据库ID数据库ID和数据库名称是一个意思吧
数据库名称已有获得方法
数据库大小已有获得方法
数据库未分配空间大小未分配空间,这个有可能获得么?
数据库保留空间大小保留空间和未使用空间是一个意思么?
数据库已使用数据空间大小已有获得方法
数据库索引空间大小
数据库未使用空间大小已有获得方法
无法确定是全局指标还是单数据库指标
数据库最大连接数
数据库工作线程数
数据库动态内存占用
数据库工作线程数 --- 难道不是"最大连接数"? 或者问的是"并行处理"??
数据库动态内存占用 --- .....
数据库工作线程数
数据库动态内存占用
-------------------------------------------
像这几个. 在 sql server 中, 似乎只有控制整个实例最大允许的连接数, 没有针对数据库的
似乎也没有明细到数据库级的工作线程数和内存占用情况
数据缓冲区命中率
可用缓存数
用户连接数 这些, 可以查
SELECT * FROM master..sysperfinfo空间大小之类, 使用 sp_spaceused 去查
具体要翻书才知道...
学习ing~
邮件收到了,单数据库的指标都有获得方法了。用户连接数 是不是这个
SELECT * FROM master..sysperfinfo where counter_name ='User Connections'痛恨英文~~~
但是里面的values显示的是4,除了我没有其他人登陆服务器啊。我用的windows身份验证的方法登陆的
hostname program_name nt_username loginame
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
sa
ZTE-995219E76C7 Microsoft SQL Server Management Studio Administrator ZTE-995219E76C7\Administrator
ZTE-995219E76C7 Microsoft SQL Server Management Studio - 查询 Administrator ZTE-995219E76C7\Administrator
ZTE-995219E76C7 SQLAgent - Generic Refresher SYSTEM NT AUTHORITY\SYSTEM
全局指标的另外几个在哪里?
果然是高手
狂汗ing
也不知道对不,供参考
1 服务器名
SELECT @@serverName
2 数据缓冲区命中率
sqlserver中是否有此名词,请老大解惑
3 可用缓存数
select sum(entries_count - entries_in_use_count) from sys.dm_os_memory_cache_counters
4 用户连接数
select count(*) from sys.sysprocesses
5 锁总数
select count(*) from sys.dm_tran_locks
6 进程锁总数
7 用户锁数
8 库id
select db_id('库名')
9 数据库未分配空间大小
不明
10 保留空间
不明
11 数据库索引空间大小
sp_spaceused
12 允许的最大连接数
SELECT @@MAX_CONNECTIONS
13 工作线程数
14 数据库动态内存占用
select * from sys.dm_os_memory_clerks
服务器名
数据缓冲区命中率
可用缓存数
用户连接数
锁总数
进程锁总数
用户锁数
================
以上可以在性能分析器里得到数据 然后保存到CSV文件 然后在用程序或SQL来定时拿到数据单数据库指标:
数据库ID数据库ID和数据库名称是一个意思吧
数据库名称已有获得方法
数据库大小已有获得方法
数据库未分配空间大小未分配空间,这个有可能获得么?
数据库保留空间大小保留空间和未使用空间是一个意思么?
数据库已使用数据空间大小已有获得方法
数据库索引空间大小
数据库未使用空间大小已有获得方法
============================
SQL语句都可以获得 无法确定是全局指标还是单数据库指标
数据库最大连接数
数据库工作线程数
数据库动态内存占用这都应该全局的
用户连接数不能直接count的,有重复
问一下数据库动态内存占用,是不是就是sys.dm_os_memory_clerks 视图里面的单页内存分配+多页内存分配啊?
估计是说的这个:
Buffer Cache Hit Ratio
这个越高越好.一般都是99%以上,一般性能问题都要看这个的 :)
--2005
SELECT(CAST(SUM(CASE LTRIM(RTRIM(counter_name))
WHEN 'Buffer cache hit ratio' THEN CAST(cntr_value AS INTEGER)
ELSE NULL END) AS FLOAT) /
CAST(SUM(CASE LTRIM(RTRIM(counter_name))
WHEN 'Buffer cache hit ratio base' THEN CAST(cntr_value AS INTEGER)
ELSE NULL END) AS FLOAT)) * 100 AS BufferCacheHitRatio
FROM sys.dm_os_performance_counters
WHERE LTRIM(RTRIM([object_name])) LIKE '%:Buffer Manager'
AND [counter_name] LIKE 'Buffer Cache Hit Ratio%'
SELECT @@serverName
数据缓冲区命中率
见31楼
可用缓存数
select sum(entries_count - entries_in_use_count) from sys.dm_os_memory_cache_counters 待验证
用户连接数
SELECT * FROM master..sysperfinfo where counter_name ='User Connections'
锁总数
select count(*) from sys.dm_tran_locks 待验证
进程锁总数
没有思路
用户锁数
没有思路
数据库最大连接数
SELECT @@MAX_CONNECTIONS
数据库工作线程数
没有思路
数据库动态内存占用
select sum(single_pages_kb)+sum(multi_pages_kb) from sys.dm_os_memory_clerks 待验证
绿色的已经确认没有问题了,待验证的几个因为我对相关的概念也不是很熟悉,请大侠指点--
因为oracle不太熟,所以不清楚它的算法是怎么样的。
虽然玩了一年多的Oracle,主要都是开发,
很少涉及性能优化方面的.....
--关于锁
--2005
SELECT L.request_session_id AS SPID,
DB_NAME(L.resource_database_id) AS DatabaseName,
O.Name AS LockedObjectName,
P.object_id AS LockedObjectId,
L.resource_type AS LockedResource,
L.request_mode AS LockType,
ST.text AS SqlStatementText,
ES.login_name AS LoginName,
ES.host_name AS HostName,
TST.is_user_transaction AS IsUserTransaction,
AT.name AS TransactionName
FROM sys.dm_tran_locks L
LEFT JOIN sys.partitions P ON P.hobt_id = L.resource_associated_entity_id
LEFT JOIN sys.objects O ON O.object_id = P.object_id
LEFT JOIN sys.dm_exec_sessions ES ON ES.session_id = L.request_session_id
LEFT JOIN sys.dm_tran_session_transactions TST ON ES.session_id = TST.session_id
LEFT JOIN sys.dm_tran_active_transactions AT ON TST.transaction_id = AT.transaction_id
LEFT JOIN sys.dm_exec_requests ER ON AT.transaction_id = ER.transaction_id
CROSS APPLY sys.dm_exec_sql_text(ER.sql_handle) AS ST
WHERE resource_database_id = db_id()
--这个?
select * from Master.dbo.sysprocesses
每个session 都算
还有相应的服务,如reporting的也算
SELECT @@MAX_CONNECTIONS 不对,应该是: Returns the maximum number of simultaneous user connections allowed on an instance of SQL Server. The number returned is not necessarily the number currently configured.
数据库工作线程数 select count(*) from sys.sysprocesses where dbid = your id, i.e., 5
collapse;table-layout:fixed;width:1443pt'>
<col width=235>
<col width=280>
<col width=242>
<col width=193>
<col width=159>
<col width=192>
<col width=110>
<col width=137>
<col width=148>
<col width=72 span=4 style='width:54pt'>
<tr><td height=19 width=235 style='height:14.25pt;width:176pt'>报告在\\ls</td><td width=219 style='width:164pt'></td><td width=242 style='width:182pt'></td><td width=193 style='width:145pt'></td><td width=159 style='width:119pt'></td><td width=192 style='width:144pt'></td><td width=110 style='width:83pt'></td><td width=137 style='width:103pt'></td><td width=148 style='width:111pt'></td><td width=72 style='width:54pt'></td><td width=72 style='width:54pt'></td><td width=72 style='width:54pt'></td><td width=72 style='width:54pt'></td>
</tr>
<tr><td>日期: 2008-7-23</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td>时间: 9:11:15</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td>值: 默认</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td>数据: 当前活动</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td>间隔: 1.00 秒</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td>计算机\\ls</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td>对象: .NET CLR Exceptions</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td>_Global_</td><td>sqlservr</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of Exceps Thrown</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of Exceps Thrown / sec</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of Filters / sec</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of Finallys / sec</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Throw To Catch Depth / sec</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td>对象: .NET CLR Interop</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td>_Global_</td><td>sqlservr</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of CCWs</td><td>2</td><td>2</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of marshalling</td><td>1338</td><td>1338</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of Stubs</td><td>287</td><td>287</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of TLB exports / sec</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of TLB imports / sec</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td>对象: .NET CLR Jit</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td>_Global_</td><td>sqlservr</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of IL Bytes Jitted</td><td>302643</td><td>302643</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of Methods Jitted</td><td>2541</td><td>2541</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>% Time in Jit</td><td>0.08</td><td>0.08</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>IL Bytes Jitted / sec</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Standard Jit Failures</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Total # of IL Bytes Jitted</td><td>302643</td><td>302643</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td>对象: .NET CLR Memory</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td>_Global_</td><td>sqlservr</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># Bytes in all Heaps</td><td>644876</td><td>644876</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># GC Handles</td><td>670</td><td>670</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># Gen 0 Collections</td><td>2</td><td>2</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># Gen 1 Collections</td><td>1</td><td>1</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># Gen 2 Collections</td><td>1</td><td>1</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># Induced GC</td><td>1</td><td>1</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of Pinned Objects</td><td>9</td><td>9</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># of Sink Blocks in use</td><td>63</td><td>63</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># Total committed Bytes</td><td>1986328</td><td>1986328</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td># Total reserved Bytes</td><td>50597656</td><td>50597656</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>% Time in GC</td><td p="3.0000000000000001E-3">0.003</td><td p="3.0000000000000001E-3">0.003</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Allocated Bytes/sec</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Finalization Survivors</td><td>39</td><td>39</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Gen 0 heap size</td><td p="6801280">6801280</td><td p="6801280">6801280</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Gen 0 Promoted Bytes/Sec</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Gen 1 heap size</td><td>608132</td><td>608132</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Gen 1 Promoted Bytes/Sec</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Gen 2 heap size</td><td>24</td><td>24</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Large Object Heap size</td><td>36720</td><td>36720</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Promoted Finalization-Memor<span style='display:none'>yfrom Gen 0</span></td><td>1068</td><td>1068</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Promoted Finalization-Memor<span style='display:none'>yfrom Gen 1</span></td><td>0</td><td>1116</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Promoted Memory from Gen 0</td><td>307792</td><td>307792</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Promoted Memory from Gen 1</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td height=19 colspan=2 style='height:14.25pt'>对象: .NET DataProvider for SqlServer</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td>crm50.dbo[runtime].2[1116]</td><td colspan=2>crmext.dbo[runtime].1[1116]</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>HardConnectsPerSecond</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>HardDisconnectsPerSecond</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>NumberOfActiveConnectionPoo<span style='display:none'>lGroups</span></td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>NumberOfActiveConnectionPoo<span style='display:none'>ls</span></td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>NumberOfActiveConnections</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>NumberOfFreeConnections</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>NumberOfInactiveConnectionP<span style='display:none'>oolGroups</span></td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>NumberOfInactiveConnectionP<span style='display:none'>ools</span></td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>NumberOfNonPooledConnection<span style='display:none'>s</span></td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>NumberOfPooledConnections</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>NumberOfReclaimedConnection<span style='display:none'>s</span></td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>NumberOfStasisConnections</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>SoftConnectsPerSecond</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>SoftDisconnectsPerSecond</td><td>0</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td>对象: Cache</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Async Copy Reads/sec</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Async Data Maps/sec</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
<tr><td></td><td>Async Fast Reads/sec</td><td>0</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
</tr>
Available Bytes
Available KBytes
Available MBytes
Cache Bytes
Cache Bytes Peak
Cache Faults/sec
Commit Limit
Committed Bytes
Demand Zero Faults/sec
Free System Page Table Entries
Page Faults/sec
Page Reads/sec
Page Writes/sec
Pages Input/sec
Pages Output/sec
Pages/sec
Pool Nonpaged Allocs
Pool Nonpaged Bytes
Pool Paged Allocs
Pool Paged Bytes
Pool Paged Resident Bytes
System Cache Resident Bytes
System Code Resident Bytes
System Code Total Bytes
System Driver Resident Bytes
System Driver Total Bytes
Transition Faults/sec
Transition Pages RePurposed/sec
Write Copies/sec
Current entries
Current KB
Direct hit ratio
Direct hits/sec
Evictions/sec
Inserts/sec
KB added/sec
Lookups/sec
Misses/sec
Total direct hits
Total evictions
Total inserts
Total lookups
Total misses
Current connections
Current user sessions
Failures/sec
Requests/sec
Successes/sec
Total failures
Total requests
Total successes
Cases/sec
Current models processing
Concurrent DM queries
Predictions/sec
Queries/sec
Rows/sec
Total Predictions
Total Queries
Total Rows
Current latch waits
Current lock waits
Current locks
Latch waits/sec
Lock denials/sec
Lock grants/sec
Lock requests/sec
Lock waits/sec
Total deadlocks detected
Unlock requests/sec
AggCacheKB
Aggregation Map Files
Cleaner Balance/sec
Cleaner Current Price
Cleaner Memory KB
Cleaner Memory nonshrinkable KB
Cleaner Memory shrinkable KB
Cleaner Memory shrunk KB/sec
Dimension Index (Hash) Files
Dimension Property Files
Dimension String Files
Fact Aggregation Files
Fact Data Files
Fact String Files
Filestore Clock Pages Examined/sec
Filestore Clock Pages HaveRef/sec
Filestore Clock Pages Valid/sec
Filestore IO Errors
Filestore IO Errors/sec
Filestore KB
Filestore KB Reads/sec
Filestore KB Write/sec
Filestore Memory Pinned KB
Filestore Page Faults/sec
Filestore Reads/sec
Filestore Writes/sec
In-memory Aggregation Map File KB
In-memory Aggregation Map File KB/sec
In-memory Dimension Index (Hash) File KB
In-memory Dimension Index (Hash) File KB/sec
In-memory Dimension Property File KB
In-memory Dimension Property File KB/sec
In-memory Dimension String File KB
In-memory Dimension String File KB/sec
In-memory Fact Aggregation File KB
In-memory Fact Aggregation File KB/sec
In-memory Fact Data File KB
In-memory Fact Data File KB/sec
In-memory Fact String File KB
In-memory Fact String File KB/sec
In-memory Map File KB
In-memory Map File KB/sec
In-memory Other File KB
In-memory Other File KB/sec
Map Files
Memory Limit High KB
Memory Limit Low KB
Memory Usage KB
Other Files
Page Pool 1 Alloc KB
Page Pool 1 Lookaside KB
Page Pool 64 Alloc KB
Page Pool 64 Lookaside KB
Page Pool 8 Alloc KB
Page Pool 8 Lookaside KB
Potential In-memory Aggregation Map File KB
Potential In-memory Dimension Index (Hash) File KB
Potential In-memory Dimension Property File KB
Potential In-memory Dimension String File KB
Potential In-memory Fact Aggregation File KB
Potential In-memory Fact Data File KB
Potential In-memory Fact String File KB
Potential In-memory Map File KB
Potential In-memory Other File KB
Quota Blocked
Quota KB
Notifications/sec
Proactive Caching Begin/sec
Proactive Caching Completion/sec
Processing Cancellations/sec
Current partitions
Memory size bytes
Memory size rows
Rows created/sec
Rows merged/sec
Temp file bytes written/sec
Temp file rows written/sec
Total partitions
Current partitions
Rows/sec
Total partitions
Total rows
Rows converted/sec
Rows read/sec
Rows written/sec
Total rows converted
Total rows read
Total rows written
Avg time/query
Bytes sent/sec
Current dimension queries
Current measure group queries
Data bytes/sec
Data reads/sec
Dimension queries/sec
Map bytes/sec
Map reads/sec
Measure group queries/sec
Network round trips/sec
Queries answered/sec
Queries from cache direct/sec
Queries from cache filtered/sec
Queries from file/sec
Rows sent/sec
Total bytes sent
Total dimension queries.
Total measure group queries
Total network round trips
Total queries answered
Total queries from cache direct
Total queries from cache filtered
Total queries from file
Total rows sent
Long parsing busy threads
Long parsing idle threads
Long parsing job queue length
Long parsing job rate
Processing pool busy threads
Processing pool idle threads
Processing pool job queue length
Processing pool job rate
Query pool busy threads
Query pool idle threads
Query pool job queue length
Query pool job rate
Short parsing busy threads
Short parsing idle threads
Short parsing job queue length
Short parsing job rate
AU cleanups/sec
By-reference Lob Create Count
By-reference Lob Use Count
Count Lob Readahead
Count Pull In Row
Count Push Off Row
Deferred dropped AUs
Deferred Dropped rowsets
Dropped rowset cleanups/sec
Dropped rowsets skipped/sec
Extent Deallocations/sec
Extents Allocated/sec
Failed AU cleanup batches/sec
Failed leaf page cookie
Failed tree page cookie
Forwarded Records/sec
FreeSpace Page Fetches/sec
FreeSpace Scans/sec
Full Scans/sec
Index Searches/sec
LobHandle Create Count
LobHandle Destroy Count
LobSS Provider Create Count
LobSS Provider Destroy Count
LobSS Provider Truncation Count
Mixed page allocations/sec
Page Deallocations/sec
Page Splits/sec
Pages Allocated/sec
Probe Scans/sec
Range Scans/sec
Scan Point Revalidations/sec
Skipped Ghosted Records/sec
Table Lock Escalations/sec
Used leaf page cookie
Used tree page cookie
Workfiles Created/sec
Worktables Created/sec
Worktables From Cache Ratio
Stored Procedures Invoked/sec
Task Limit Reached
Task Limit Reached/sec
Tasks Aborted/sec
Tasks Running
Tasks Started/sec
Broker Transaction Rollbacks
Dialog Timer Event Count
Enqueued Local Messages Total
Enqueued Local Messages/sec
Enqueued Messages Total
Enqueued Messages/sec
Enqueued Transport Msg Frag Tot
Enqueued Transport Msg Frags/sec
Enqueued Transport Msgs Total
Enqueued Transport Msgs/sec
Forwarded Messages Total
Forwarded Messages/sec
Forwarded Msg Byte Total
Forwarded Msg Bytes/sec
Forwarded Msg Discarded Total
Forwarded Msgs Discarded/sec
Forwarded Pending Msg Bytes
Forwarded Pending Msg Count
SQL RECEIVE Total
SQL RECEIVEs/sec
SQL SEND Total
SQL SENDs/sec
AWE lookup maps/sec
AWE stolen maps/sec
AWE unmap calls/sec
AWE unmap pages/sec
AWE write maps/sec
Buffer cache hit ratio
Checkpoint pages/sec
Database pages
Free list stalls/sec
Free pages
Lazy writes/sec
Page life expectancy
Page lookups/sec
Page reads/sec
Page writes/sec
Readahead pages/sec
Reserved pages
Stolen pages
Target pages
Total pages
CLR Execution
Connection Memory (KB)
Granted Workspace Memory (KB)
Lock Blocks
Lock Blocks Allocated
Lock Memory (KB)
Lock Owner Blocks
Lock Owner Blocks Allocated
Maximum Workspace Memory (KB)
Memory Grants Outstanding
Memory Grants Pending
Optimizer Memory (KB)
SQL Cache Memory (KB)
Target Server Memory (KB)
Total Server Memory (KB)
Errors/sec
Free Space in tempdb (KB)
Longest Transaction Running Time
NonSnapshot Version Transactions
Snapshot Transactions
Transactions
Update conflict ratio
Update Snapshot Transactions
Version Cleanup rate (KB/s)
Version Generation rate (KB/s)
Version Store Size (KB)
Version Store unit count
Version Store unit creation
Version Store unit truncation
Query
Lock waits
Log buffer waits
Log write waits
Memory grant queue waits
Network IO waits
Non-Page latch waits
Page IO latch waits
Page latch waits
Thread-safe memory objects waits
Transaction ownership waits
Wait for the worker
Workspace synchronization waits
Bytes Received/sec
Bytes Sent/sec
Bytes Total/sec
Current Bandwidth
Output Queue Length
Packets Outbound Discarded
Packets Outbound Errors
Packets Received Discarded
Packets Received Errors
Packets Received Non-Unicast/sec
Packets Received Unicast/sec
Packets Received Unknown
Packets Received/sec
Packets Sent Non-Unicast/sec
Packets Sent Unicast/sec
Packets Sent/sec
Packets/sec
% C1 Time
% C2 Time
% C3 Time
% DPC Time
% Idle Time
% Interrupt Time
% Privileged Time
% Processor Time
% User Time
C1 Transitions/sec
C2 Transitions/sec
C3 Transitions/sec
DPC Rate
DPCs Queued/sec
Interrupts/sec
Blocking Requests Rejected
Bytes Received/sec
Bytes Total/sec
Bytes Transmitted/sec
Context Blocks Queued/sec
Errors Access Permissions
Errors Granted Access
Errors Logon
Errors System
File Directory Searches
Files Open
Files Opened Total
Logon Total
Logon/sec
Pool Nonpaged Bytes
Pool Nonpaged Failures
Pool Nonpaged Peak
Pool Paged Bytes
Pool Paged Failures
Pool Paged Peak
Server Sessions
Sessions Errored Out
Sessions Forced Off
Sessions Logged Off
Sessions Timed Out
Work Item Shortages
Active Threads
Available Threads
Available Work Items
Borrowed Work Items
Bytes Received/sec
Bytes Sent/sec
Bytes Transferred/sec
Context Blocks Queued/sec
Current Clients
Queue Length
Read Bytes/sec
Read Operations/sec
Total Bytes/sec
Total Operations/sec
Work Item Shortages
Write Bytes/sec
Write Operations/sec