随着Sybase被完全整合到SAP下，Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
目前，原Sybase所有产品（包括：Adaptive Server Enterprise、Sybase IQ、Replication Server、PowerDesigner等）的官方手册仍然可以从https://infocenter.sybase.com/help/index.jsp进行浏览或下载。暂不清楚该网站https://infocenter.sybase.com/help/index.jsp何时会被完全迁移到SAP Support上！
Sybase官方手册英文版有html和pdf两种格式，而中文版手册只有pdf一种格式。为了国内Sybase用户更方便、快捷地搜索Sybase常见产品的官方手册内容，特将中文版Sybase官方手册转为html格式！
Sybase产品官方手册中文版的html格式所有内容的版权归SAP公司所有！本博客站长是Sybase数据库的铁杆粉丝！
如有Sybase数据库技术问题需要咨询，请联系我！
以下官方手册为SAP IQ 16.0 SP03中文版：
sp_iqsysmon 过程示例
sp_iqsysmon 输出示例。 示例 1：
在 20 分钟后显示缓冲区分配（主存储和临时存储）的输出。
sp_iqsysmon '00:20:00', 'mbufalloc tbufalloc'
==============================
Buffer Allocator (Main)"
==============================
STATS-NAME VALUE
NActiveCommands 2
BufAllocMaxBufs 2275( 81.6% )
BufAllocAvailBufs 2115( 93.0% )
BufAllocReserved 160( 7.0% )
BufAllocAvailPF 750( 33.0% )
BufAllocSlots 100
BufAllocNPinUsers 0
BufAllocNPFUsers 2
BufAllocNPostedUsrs 0
BufAllocNUnpostUsrs 0
BufAllocPinQuota 0
BufAllocNPostEst 0
BufAllocNUnPostEst 0
BufAllocMutexLocks 0
BufAllocMutexWaits 0( 0.0% )
STATS-NAME VALUE
NActiveCommands 2
BufAllocMaxBufs 2275( 81.6% )
BufAllocAvailBufs 2115( 93.0% )
BufAllocReserved 160( 7.0% )
BufAllocAvailPF 750( 33.0% )
BufAllocSlots 100
BufAllocNPinUsers 0
BufAllocNPFUsers 2
BufAllocNPostedUsrs 0
BufAllocNUnpostUsrs 0
BufAllocPinQuota 0
BufAllocNPostEst 0
BufAllocNUnPostEst 0
BufAllocMutexLocks 0
BufAllocMutexWaits 0( 0.0% )
STATS-NAME TOTAL UNKNWN HASH CSORT ROW ROWCOL FP GARRAY LOB BTREE BM BV STORE TEST
NumClients 2 0 0 0 2
0 0 0 0 0 0 0 0 0
PinUserQuota 0 0 0 0 0
0 0 0 0 0 0 0 0 0
PrefetchUserQuota 160 0 0 0 160
0 0 0 0 0 0 0 0 0
PinUserRegisters 2 2 0 0 0
0 0 0 0 0 0 0 0 0
PfUserRegisters 4697 0 0 0 382
2621 377 182 0 2 0 0 0 0
|
1 |
3 |
6 |
10 |
||
|
1000 |
3333 |
6666 |
10000 |
|
1 |
3 |
6 |
10 |
||
|
1000 |
3333 |
6666 |
10000 |
ClientCountOfPinners 0
33 66 100 333 666
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Hash 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Sort 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Row 0 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
RowColumn |
0 |
0 |
0 |
0 |
0 |
||||||||
|
0 FP 0 |
0
0 |
0
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
|
Garray 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
LOB 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
BTree 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
BM 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
BV 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Store 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Test 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
DBCC 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Run 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
QCPRun 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
TextDoc 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
VDO 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Load 0 |
0 |
0 |
0 |
Pass |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
STATS-NAME (cont'd) |
DBCC |
BLKMAP |
IQUTIL |
|||
|
NumClients |
0 |
0 |
0 |
0 |
0 |
|
|
0 0 0 |
0 |
0 |
||||
|
PinUserQuota |
0 |
0 |
0 |
0 |
0 |
|
|
0 0 0 |
0 |
0 |
||||
|
PrefetchUserQuota |
0 |
0 |
0 |
0 |
0 |
|
|
0 0 0 |
0 |
0 |
||||
|
PinUserRegisters |
0 |
0 |
0 |
0 |
0 |
|
|
0 0 0 |
0 |
0 |
||||
PfUserRegisters 0 0 0 0 0
0 0 0 1133 0
|
ClientCountOfPinners |
33333 |
66666 |
100000 |
4294967295 |
|||
|
Unknown |
0 |
0 |
0 |
0 |
|||
|
Hash |
0 |
0 |
0 |
0 |
|||
|
Sort |
0 |
0 |
0 |
0 |
|||
|
Row |
0 |
0 |
0 |
0 |
|||
|
RowColumn |
0 |
0 |
0 |
0 |
|||
|
FP |
0 |
0 |
0 |
0 |
|||
|
Garray |
0 |
0 |
0 |
0 |
|||
|
LOB |
0 |
0 |
0 |
0 |
|||
|
BTree |
0 |
0 |
0 |
0 |
|||
|
BM |
0 |
0 |
0 |
0 |
|||
|
BV |
0 |
0 |
0 |
0 |
|||
|
Store |
0 |
0 |
0 |
0 |
|||
|
Test |
0 |
0 |
0 |
0 |
|||
|
DBCC |
0 |
0 |
0 |
0 |
|||
|
Unknown |
0 |
0 |
0 |
0 |
|||
|
Unknown |
0 |
0 |
0 |
0 |
|||
|
Run |
0 |
0 |
0 |
0 |
|||
|
QCPRun |
0 |
0 |
0 |
0 |
|||
|
TextDoc |
0 |
0 |
0 |
0 |
|||
|
Unknown |
0 |
0 |
0 |
0 |
|||
|
Unknown |
0 |
0 |
0 |
0 |
|||
|
VDO |
0 |
0 |
0 |
0 |
|||
|
Load |
0 |
0 |
0 |
0 0 |
0 |
==============================
Buffer Allocator (Temporary)
==============================
STATS-NAME VALUE
NActiveCommands 2
BufAllocMaxBufs 2275( 81.6% )
BufAllocAvailBufs 2263( 99.5% )
BufAllocReserved 12( 0.5% )
BufAllocAvailPF 908( 39.9% )
BufAllocSlots 100
BufAllocNPinUsers 2
BufAllocNPFUsers 2
BufAllocNPostedUsrs 0
BufAllocNUnpostUsrs 0
BufAllocPinQuota 175
BufAllocNPostEst 2
BufAllocNUnPostEst 2
BufAllocMutexLocks 0
BufAllocMutexWaits 0( 0.0% )
STATS-NAME TOTAL UNKNWN HASH CSORT ROW ROWCOL FP GARRAY LOB BTREE BM BV STORE TEST
NumClients 4 0 0 4 0
0 0 0 0 0 0 0 0 0
PinUserQuota 10 0 0 10 0
0 0 0 0 0 0 0 0 0
PrefetchUserQuota 2 0 0 2 0
0 0 0 0 0 0 0 0 0
PinUserRegisters 668 0 300 247
0 0 0 0 0 0 0 0 0 0
PfUserRegisters 675 0 0 295 0
0 0 0 0 0 0 0 1 0
ClientCountOfPinners 0 1 3 6 10
|
33 Unknown 0 |
66
0 |
100
0 |
333
0 |
0 |
666
0 |
0 |
1000
0 |
0 |
3333 6666 1000 0 0 0 0 0 |
||||
|
Hash 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 0 0 0 0 |
||||
|
Sort 0 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
1 |
0 1 0 0 0 |
||||
|
Row 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 0 0 0 0 |
||||
|
RowColumn |
0 |
0 |
0 |
0 |
0 |
||||||||
|
0 FP 0 |
0
0 |
0
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
|
Garray 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
LOB 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
BTree 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
BM 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
BV 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Store 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Test 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
DBCC 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Run 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
QCPRun 0 |
0 |
0 |
0 |
` |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
TextDoc 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
VDO 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Load 0 |
0 |
0 |
0 |
Pass |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
33 Unknown 0 |
66
0 |
100
0 |
333
0 |
0 |
666
0 |
0 |
1000
0 |
0 |
3333 6666 1000 0 0 0 0 0 |
||||
|
Hash 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 0 0 0 0 |
||||
|
Sort 0 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
1 |
0 1 0 0 0 |
||||
|
Row 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 0 0 0 0 |
||||
|
RowColumn |
0 |
0 |
0 |
0 |
0 |
||||||||
|
0 FP 0 |
0
0 |
0
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
0 |
0
0 |
|
Garray 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
LOB 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
BTree 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
BM 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
BV 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Store 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Test 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
DBCC 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Run 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
QCPRun 0 |
0 |
0 |
0 |
` |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
TextDoc 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Unknown 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
VDO 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Load 0 |
0 |
0 |
0 |
Pass |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0
|
STATS-NAME (cont'd) NumClients |
DBCC 0 |
BLKMAP 0 |
IQUTIL 0 |
0 |
0 |
||
|
0 0 0 |
0 |
0 |
|||||
|
PinUserQuota |
0 |
0 |
0 |
0 |
0 |
||
|
0 0 0 |
0 |
0 |
|||||
|
PrefetchUserQuota 0 0 0 PinUserRegisters |
0 |
0
0 |
0 |
0
0 |
0
0 |
0
110 |
0
2 |
|
0 0 0 PfUserRegisters |
0 |
0 |
9 |
0 |
0 |
378 |
0 |
|
0 0 1 |
0 |
0 |
|||||
|
ClientCountOfPinners |
33333 |
66666 |
100000 |
4294967295 |
|
Unknown |
0 |
0 |
0 |
0 |
|
Hash |
0 |
0 |
0 |
0 |
|
Sort |
0 |
0 |
0 |
0 |
|
Row |
0 |
0 |
0 |
0 |
|
RowColumn |
0 |
0 |
0 |
0 |
|
FP |
0 |
0 |
0 |
0 |
|
Garray |
0 |
0 |
0 |
0 |
|
LOB |
0 |
0 |
0 |
0 |
|
BTree |
0 |
0 |
0 |
0 |
|
BM |
0 |
0 |
0 |
0 |
|
BV |
0 |
0 |
0 |
0 |
|
Store |
0 |
0 |
0 |
0 |
|
Test |
0 |
0 |
0 |
0 |
|
DBCC |
0 |
0 |
0 |
0 |
|
Unknown |
0 |
0 |
0 |
0 |
|
Unknown |
0 |
0 |
0 |
0 |
|
Run |
0 |
0 |
0 |
0 |
|
QCPRun |
0 |
0 |
0 |
0 |
|
TextDoc |
0 |
0 |
0 |
0 |
|
Unknown |
0 |
0 |
0 |
0 |
|
Unknown |
0 |
0 |
0 |
0 |
|
VDO |
0 |
0 |
0 |
0 |
|
Load |
0 |
0 |
0 |
0 0 |
|
0 |
示例 2：
在 20 分钟后显示缓冲区管理器（主存储和临时存储）的输出。
sp_iqsysmon '00:20:00', 'mbufman tbufman'
==============================
Buffer Manager (Main)
==============================
|
STATS-NAME |
TOTAL |
NONE TXTPOS TXTDOC CMPACT |
|
|
BTREEV BTREEF |
BV |
VDO DBEXT |
DBID SORT STORE GARRAY |
|
Finds |
80137 0 |
0 0 0 9046 |
|
|
3307 0 |
20829 |
0 0 |
0 0 275 |
|
Hits |
80090 0 |
0 0 0 9015 |
|
|
3291 0 |
20829 |
0 0 |
0 0 275 |
|
Hit% |
99.9 0 |
0 0 0 99.7 |
99.5 0 100 0 0 0 0 100
FalseMiss 26469 0 0 0 0
63 40 0 1097 0 0 0 0 0
UnOwnRR 48 0 0 0 0 31
16 0 1 0 0 0 0 0
Cloned 0 0 0 0 0
0 0 0 0 0 0 0 0 0
Creates 1557 0 0 0 0 60
179 0 256 0 0 0 0 58
Destroys 546 0 0 0 0
12 21 0 6 0 0 0 0 29
Dirties 7554 0 0 0 0 1578
585 0 0 0 0 0 0 0
RealDirties 2254 0 0 0 0
117 180 0 542 0 0 0 0 58
PrefetchReqs 80 0 0 0 0
0 0 0 74 0 0 0 0 0
PrefetchNotInMem 1 0 0 0 0
0 0 0 1 0 0 0 0 0
PrefetchInMem 1466 0 0 0 0
0 0 0 1466 0 0 0 0 0
Reads 48 0 0 0 0 31
16 0 1 0 0 0 0 0
PReadBlks 114 0 0 0 0
80 32 0 2 0 0 0 0 0
PReadKB 0 0 0 0 0
0 0 0 0 0 0 0 0 0
ReReads 0 0 0 0 0
0 0 0 0 0 0 0 0 0
Writes 2002 0 0 0 0 104
163 0 538 0 0 0 0 29
PWriteBlks 6506 0 0 0 0 210
326 0 1115 0 0 0 0 58
PWriteKB 0 0 0 0 0
0 0 0 0 0 0 0 0 0
GrabbedDirty 0 0 0 0 0
0 0 0 0 0 0 0 0 0
ReadRemoteRpc 0 0 0 0 0
0 0 0 0 0 0 0 0 0
ReadRemotePhyIO 0 0 0 0 0
0 0 0 0 0 0 0 0 0
STATS-NAME (cont'd) BARRAY BLKMAP HASH CKPT BM TEST CMID RIDCA LOB LVCRID FILE RIDMAP RVLOG Finds 2681 8329 0 0 35670
0 0 0 0 0 0 0 0
Hits 2681 8329 0 0 35670
0 0 0 0 0 0 0 0
Hit% 100 100 0 0 100
0 0 0 0 0 0 0 0
FalseMiss 84 8329 0 0 16856
0 0 0 0 0 0 0 0
UnOwnRR 0 0 0 0 0
0 0 0 0 0 0 0 0
Cloned 0 0 0 0 0
0 0 0 0 0 0 0 0
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
Creates 0 0 Destroys 0 0 Dirties 0 0 RealDirties 0 0 PrefetchReqs 0 0 PrefetchNotInMem 0 0 PrefetchInMem 0 0 Reads 0 0 PReadBlks 0 0 PReadKB 0 0 ReReads 0 0 Writes 0 0 |
108 |
358 |
0 |
0 |
538 |
|||||||
|
0 |
0 |
0 |
0 |
|||||||||
|
0 |
126 |
0 |
0 |
59 |
||||||||
|
0 |
0 |
0 |
0 |
|||||||||
|
512 |
235 |
0 |
0 |
4644 |
||||||||
|
0 |
0 |
0 |
0 |
|||||||||
|
128 |
593 |
0 |
0 |
636 |
||||||||
|
0 |
0 |
0 |
0 |
|||||||||
|
6 |
0 |
0 |
0 |
0 |
||||||||
|
0 |
0 |
0 |
0 |
|||||||||
|
0 |
0 |
0 |
0 |
0 |
||||||||
|
0 |
0 |
0 |
0 |
|||||||||
|
0 |
0 |
0 |
0 |
0 |
||||||||
|
0 |
0 |
0 |
0 |
|||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 |
0 |
0 |
||||||||||
|
0 |
0 |
0 |
0 |
0 |
||||||||
|
0 |
0 |
0 |
0 |
|||||||||
|
0 |
0 |
0 |
0 |
0 |
||||||||
|
0 |
0 |
0 |
0 |
|||||||||
|
0 |
0 |
0 |
0 |
0 |
||||||||
|
0 |
0 |
0 |
0 |
|||||||||
|
128 |
466 |
0 |
0 |
574 |
||||||||
|
0 |
0 |
0 |
0 |
|||||||||
|
PWriteBlks |
239 |
3728 |
0 |
0 |
830 |
|||||||
|
0 0 |
0 |
0 |
0 |
0 |
0 |
0 |
||||||
|
PWriteKB |
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 0 |
0 |
0 |
0 |
0 |
0 |
0 |
||||||
|
GrabbedDirty |
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 0 |
0 |
0 |
0 |
0 |
0 |
0 |
||||||
|
ReadRemoteRpc |
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 0 |
0 |
0 |
0 |
0 |
0 |
0 |
||||||
|
ReadRemotePhyIO |
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 0 |
0 |
0 |
0 |
0 |
0 |
0 |
||||||
|
STATS-NAME BusyWaits |
VALUE 98 |
|||||||||||
|
LRUNumLocks |
401784 |
|||||||||||
|
LRUNumSpinsWoTO |
0 |
0% |
||||||||||
|
LRUNumSpinLoops |
4315 |
|||||||||||
|
LRUNumTimeOuts |
4315 |
-1.10% |
||||||||||
|
BmapHTNumLocks |
0 |
|||||||||||
|
BmapHTNumWaits |
0 |
0% |
||||||||||
|
CacheTeamTimesWoken |
182 |
|||||||||||
|
CacheTeamNumAsleep |
10 |
|||||||||||
|
BmapHTMaxEntries |
4096 |
|||||||||||
|
BmapHTNEntries |
27 |
|||||||||||
|
BmapHTNInserts |
31954 |
|||||||||||
|
BmapHTNCollisn |
203 |
|||||||||||
|
BmapHTNFinds |
51419 |
|||||||||||
|
BmapHTNHits |
19576 |
|||||||||||
|
BmapHTNHits1 |
19550 |
|||||||||||
|
BmapHTNHits2 |
26 |
|||||||||||
|
BmapHTNClears |
31933 |
|||||||||||
|
BmapHTNLChain |
1 |
|||||||||||
|
BmapHTNRehash |
0 |
|||||||||||
|
BlockmapMutexsNLocks |
0 |
|
|
BlockmapMutexsNWaits |
0 |
|
|
BlockmapUID |
3659 |
|
|
BlockmapUIDnallocs |
3652 |
|
|
BlockmapRegEver |
31851 |
|
|
BlockmapRegisters |
31844 |
|
|
BufHTNBuckets |
4608 |
|
|
BufHTNEntries |
1208 |
|
|
BufHTNw2orMore |
158 |
|
|
BufHTMaxBucketSize |
19 |
|
|
BufHTNFoiledOps |
0 |
|
|
IONumLocks |
0 |
|
|
IONumWaits |
0 |
0% |
==============================
Buffer Manager (Temporary)
==============================
|
STATS-NAME BTREEV BTREEF |
BV |
TOTAL VDO DBEXT |
NONE TXTPOS TXTDOC CMPACT DBID SORT STORE GARRAY |
||||||||||||||||
|
Finds |
31656 |
0 |
0 |
0 0 |
|||||||||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
1022 |
0 |
0 |
|||||||||||
|
Hits |
31655 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
1022 |
0 |
0 |
|||||||||||
|
Hit% |
100 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
100 |
0 |
0 |
|||||||||||
|
FalseMiss |
23898 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||||||||
|
UnOwnRR |
0 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||||||||
|
Cloned |
0 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||||||||
|
Creates |
5682 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
1048 |
716 |
0 |
|||||||||||
|
Destroys |
5670 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
821 |
17 |
0 |
|||||||||||
|
Dirties |
6702 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
379 |
0 |
0 |
|||||||||||
|
RealDirties |
5692 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
1048 |
716 |
0 |
|||||||||||
|
PrefetchReqs |
1 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||||||||
|
PrefetchNotInMem |
1 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
||||||||||||
|
PrefetchInMem |
446 |
0 |
0 |
0 |
0 |
||||||||||||||
|
0 0 |
0 |
0 |
0 |
0 |
446 |
0 |
0 |
||||||||||||
|
Reads |
2 |
0 |
0 |
0 |
0 |
0 |
|||||||||||||
|
0 0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||||||||||
|
PReadBlks 0 0 |
0 |
0 |
4096 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||||
|
PReadKB 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
||||||
|
ReReads 0 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
||||||
|
Writes 0 |
0 |
0 |
0 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
||||||
|
80 |
0 |
0 |
0 |
0 |
|||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||
|
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||
|
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||
|
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||
|
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||
|
80 |
0 |
0 |
0 |
0 |
|||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||
|
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||
|
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||
|
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||
|
0 |
0 |
0 |
0 |
0 |
|||||||
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||||
PWriteBlks 0 0
PWriteKB
0 0
GrabbedDirty 0 0
ReadRemoteRpc 0 0
ReadRemotePhyIO 0 0
|
0 |
|||||||
|
0 |
|||||||
STATS-NAME (cont'd) BARRAY BLKMAP HASH CKPT BM TEST CMID RIDCA LOB LVCRID FILE RIDMAP RVLOG Finds 0 8569 124 0 21939
|
0 Hits 0 |
0
0 |
0
0 |
0
0 |
0 |
0
0 |
8569 |
2
1 |
124 |
0
0 |
0 0 21939 0 |
||
|
Hit% 0 |
0 |
0 |
0 |
0 |
0 |
100 |
50 |
100 |
0 |
0 100 0 |
||
|
FalseMiss |
0 |
8569 |
0 |
0 |
15328 |
|||||||
|
0 UnOwnRR 0 |
0
0 |
0
0 |
0
0 |
0 |
0
0 |
0 |
1
0 |
0 |
0
0 |
0 0 0 0 |
||
|
Cloned 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 0 0 |
||
|
Creates 0 |
0 |
0 |
0 |
0 |
0 |
1440 |
777 0 1041 0 660 0 |
|||||
|
Destroys 0 |
0 |
0 |
0 |
0 |
0 |
1434 |
777 0 123 0 660 0 |
|||||
|
Dirties 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 0 6323 0 0 0 |
|||||
|
RealDirt |
ies |
0 |
1440 |
777 0 1051 |
||||||||
|
0 0 0 PrefetchReqs 0 0 0 |
0
0 |
0 |
0
0 |
0 660 0 0 0 0 0 1 0 0 |
||||||||
|
PrefetchNotInMem 0 0 0 |
0 |
0 |
0 |
0 0 0 0 1 0 0 |
||||||||
|
PrefetchInMem 0 0 0 |
0 |
0 |
0 |
0 0 0 0 0 0 0 |
||||||||
|
Reads 0 0 0 |
0 |
0 |
2 |
0 0 0 0 0 0 |
||||||||
|
PReadBlks 0 0 0 |
0 |
0 |
0 |
0 0 0 0 4096 0 0 |
||||||||
|
PReadKB 0 0 0 |
0 |
0 |
0 |
0 0 0 0 0 0 0 |
||||||||
|
ReReads 0 0 0 |
0 |
0 |
0 |
0 0 0 0 2 0 0 |
||||||||
|
Writes 0 0 0 |
0 |
0 |
0 |
0 0 0 10 0 0 0 |
||||||||
|
PWriteBlks 0 0 0 |
0 |
0 |
0 |
0 0 0 80 0 0 0 |
||||||||
|
PWriteKB 0 0 0 |
0 |
0 |
0 |
0 0 0 0 0 0 0 |
||||||||
|
GrabbedDirty 0 0 0 |
0 |
0 |
0 |
0 0 0 0 0 0 0 |
||||||||
|
ReadRemoteRpc |
0 |
0 0 0 0 |
||||||||||
|
0 0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||
|
ReadRemotePhyIO |
0 |
0 |
0 |
0 |
0 |
||||
|
0 0 |
0 |
0 |
0 |
0 |
0 |
0 |
|||
|
STATS-NAME BusyWaits |
VALUE 0 |
||||||||
|
LRUNumLocks |
136253 |
||||||||
|
LRUNumSpinsWoTO |
0 |
0% |
|||||||
|
LRUNumSpinLoops |
2780 |
||||||||
|
LRUNumTimeOuts |
2780 |
-0.02% |
|||||||
|
BmapHTNumLocks |
0 |
||||||||
|
BmapHTNumWaits |
0 |
0% |
|||||||
|
CacheTeamTimesWoken |
1 |
||||||||
|
CacheTeamNumAsleep |
10 |
||||||||
|
BmapHTMaxEntries |
4096 |
||||||||
|
BmapHTNEntries |
17 |
||||||||
|
BmapHTNInserts |
2334 |
||||||||
|
BmapHTNCollisn |
0 |
||||||||
|
BmapHTNFinds |
183 |
||||||||
|
BmapHTNHits |
0 |
||||||||
|
BmapHTNHits1 |
0 |
||||||||
|
BmapHTNHits2 |
0 |
||||||||
|
BmapHTNClears |
2327 |
||||||||
|
BmapHTNLChain |
0 |
||||||||
|
BmapHTNRehash |
0 |
||||||||
|
BlockmapMutexsNLocks |
0 |
||||||||
|
BlockmapMutexsNWaits |
0 |
||||||||
|
BlockmapUID |
2380 |
||||||||
|
BlockmapUIDnallocs |
2335 |
||||||||
|
BlockmapRegEver |
2344 |
||||||||
|
BlockmapRegisters |
2334 |
||||||||
|
BufHTNBuckets |
4608 |
||||||||
|
BufHTNEntries |
24 |
||||||||
|
BufHTNw2orMore |
0 |
||||||||
|
BufHTMaxBucketSize |
3 |
||||||||
|
BufHTNFoiledOps |
0 |
||||||||
|
IONumLocks |
0 |
||||||||
|
IONumWaits |
0 |
0% |
|||||||
示例 3：
在 20 分钟后显示缓冲池（主存储和临时存储）的输出。
sp_iqsysmon '00:20:00', 'mbufpool tbufpool'
==============================
Buffer Pool (Main)
==============================
|
STATS-NAME |
TOTAL |
NONE TXTPOS TXTDOC CMPACT |
|
|
BTREEV BTREEF |
BV |
VDO DBEXT |
DBID SORT STORE GARRAY |
|
MovedToMRU |
68731 0 |
0 0 0 9094 |
|
|
2767 0 |
21083 |
0 0 |
0 0 303 |
|
MovedToWash |
0 |
0 0 0 0 |
|
|
0 0 |
0 |
0 0 |
0 0 0 0 |
|
RemovedFromLRU |
67564 |
0 0 0 0 |
9020 2597 0 20830 0 0 0 0 274
RemovedFromWash 11457 0 0 0 0
1559 356 0 2189 0 0 0 0 68
RemovedInScanMode 0 0 0 0 0
0 0 0 0 0 0 0 0 0
MovedToPSList 0 0 0 0 0
0 0 0 0 0 0 0 0 0
RemovedFromPSList 0 0 0 0 0
0 0 0 0 0 0 0 0 0
STATS-NAME (cont'd) BARRAY BLKMAP HASH CKPT BM TEST CMID RIDCA LOB LVCRID FILE RIDMAP RVLOG
|
MovedToMRU 0 0 0 |
0 |
2169 |
0 |
8561 |
0 |
0 |
0 |
0 24754 0 |
||
|
MovedToWash 0 0 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 0 0 |
||
|
RemovedFromLRU 0 0 0 |
0 |
2065 |
0 |
8330 |
0 |
0 |
0 |
0 24448 0 |
||
|
RemovedFromWash 0 0 0 |
0 |
233 |
0 |
1437 |
0 |
0 |
0 |
0 5615 0 |
||
|
RemovedInScanMode 0 0 0 MovedToPSList 0 0 0 |
0
0 |
0
0 |
0
0 |
0
0 |
0
0 |
0
0 |
0
0 |
0
0 |
0
0 |
0
0 |
|
RemovedFromPSList 0 0 0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
STATS-NAME VALUE
Pages 2787
InUse 1208 ( 43.3% )
Dirty 11 ( 0.4% )
Pinned 19 ( 0.7% )
Flushes 0
FlushedBufferCount 0
GetPageFrame 1605
GetPageFrameFailure 0
GotEmptyFrame 1605
Washed 0
TimesSweepersWoken 0
PriorityWashed 0
NPrioritySweepersWoken 0
washTeamSize 10
WashMaxSize 455 ( 16.3% )
washNBuffers 455 ( 16.3% )
washNDirtyBuffers 0 ( 0.0% )
washSignalThreshold 46 ( 1.7% )
washNActiveSweepers 0
NPriorityWashBuffers 0
NActivePrioritySweepers 0
washIntensity 0
FlushAndEmpties 0
EmptiedBufferCount 0
EmptiedSkippedCount 0
EmptiedWriteCount 0
EmptiedErrorCount 0
nAffinityTotal 0 ( 0.0% )
|
nAffinityArea |
0 ( 0.0% ) |
|
============================== Buffer Pool (Temporary) ============================== |
STATS-NAME TOTAL NONE TXTPOS TXTDOC CMPACT BTREEV BTREEF BV VDO DBEXT DBID SORT STORE GARRAY MovedToMRU 30514 0 0 0 0
0 0 0 0 0 0 1218 696 0
MovedToWash 258 0 0 0 0
0 0 0 0 0 0 0 256 0
RemovedFromLRU 30506 0 0 0 0
0 0 0 0 0 0 1218 694 0
RemovedFromWash 30503 0 0 0 0
0 0 0 0 0 0 1218 694 0
RemovedInScanMode 0 0 0 0 0
0 0 0 0 0 0 0 0 0
MovedToPSList 0 0 0 0 0
0 0 0 0 0 0 0 0 0
|
0 |
0 |
0 |
0 |
|
BARRAY |
BLKMAP |
HASH |
|
0 |
0 |
0 |
0 |
|
BARRAY |
BLKMAP |
HASH |
RemovedFromPSList 0 0 0 0 0
0 0 0 0 0
STATS-NAME (cont'd)
CKPT BM
|
0 8575 0 0 |
124 |
0 |
|||||
|
3 |
0 |
||||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
2 |
0 |
||||
|
0 |
8569 |
124 |
0 |
||||
|
0 |
0 |
3 |
0 |
||||
|
0 |
8569 |
124 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 8575 0 0 |
124 |
0 |
|||||
|
3 |
0 |
||||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
2 |
0 |
||||
|
0 |
8569 |
124 |
0 |
||||
|
0 |
0 |
3 |
0 |
||||
|
0 |
8569 |
124 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
|
0 |
0 |
0 |
0 |
||||
TEST CMID RIDCA LOB LVCRID FILE RIDMAP RVLOG
MovedToMRU
0 0 0
MovedToWash
0 0 0
RemovedFromLRU
0 0 0
RemovedFromWash
0 0 0
RemovedInScanMode 0 0 0
MovedToPSList
0 0 0
RemovedFromPSList 0 0 0
19898
0
0
0
19898
0
19898
0
0
0
0
0
0
0
STATS-NAME VALUE
Pages 2787
InUse 24 ( 0.9% )
Dirty 17 ( 0.6% )
Pinned 4 ( 0.1% )
Flushes 0
FlushedBufferCount 0
GetPageFrame 5684
GetPageFrameFailure 0
GotEmptyFrame 5684
Washed 0
TimesSweepersWoken 0
PriorityWashed 0
NPrioritySweepersWoken 0
washTeamSize 10
WashMaxSize 455 ( 16.3% )
washNBuffers 20 ( 0.7% )
washNDirtyBuffers 13 ( 0.5% )
washSignalThreshold 46 ( 1.7% )
washNActiveSweepers 0
NPriorityWashBuffers 0
NActivePrioritySweepers 0
washIntensity 0
FlushAndEmpties 0
EmptiedBufferCount 0
EmptiedSkippedCount 0
EmptiedWriteCount 0
EmptiedErrorCount 0
nAffinityTotal 0 ( 0.0% )
nAffinityArea 0 ( 0.0% )
示例 4：
在 20 分钟后显示预取管理器（主存储和临时存储）的输出。
sp_iqsysmon '00:20:00', 'mprefetch tprefetch'
==============================
Prefetch Manager (Main)
==============================
|
STATS-NAME |
VALUE |
|||
|
PFMgrNThreads |
10 |
|||
|
PFMgrNSubmitted |
81 |
|||
|
PFMgrNDropped |
0 |
|||
|
PFMgrNValid |
0 |
|||
|
PFMgrNRead |
1 |
|||
|
PFMgrNReading |
0 |
|||
|
PFMgrCondVar |
Locks 0 |
Lock-Waits 0 ( 0.0% ) |
Signals 0 |
|
|
Broadcasts 2 Waits 2 |
||||
==============================
Prefetch Manager (Temporary)
==============================
|
STATS-NAME |
VALUE |
|||
|
PFMgrNThreads |
10 |
|||
|
PFMgrNSubmitted |
1 |
|||
|
PFMgrNDropped |
0 |
|||
|
PFMgrNValid |
0 |
|||
|
PFMgrNRead |
1 |
|||
|
PFMgrNReading |
0 |
|||
|
PFMgrCondVar |
Locks 0 |
Lock-Waits 0 ( 0.0% ) |
Signals 0 |
|
|
Broadcasts 2 Waits 2 |
||||
示例 5：
在 20 分钟后显示 IQ 存储库空闲列表（主存储和临时存储）的输出。
sp_iqsysmon '00:20:00', 'mfreelist tfreelist'
==============================
IQ Store (Main) Free List
==============================
STATS-NAME VALUE
FLBitCount 74036
FLIsOutOfSpace NO
FLMutexLocks 0
FLMutexWaits 0 ( 0.0% )
==============================
IQ Store (Temporary) Free List
==============================
STATS-NAME VALUE
FLBitCount 4784
FLIsOutOfSpace NO
FLMutexLocks 0
FLMutexWaits 0 ( 0.0% )
示例 6：
在 20 分钟后显示内存管理器、线程管理器、CPU 利用率以及事务管理器的输出。
sp_iqsysmon '00:20:00', 'memory threads cpu txn'
==============================
Memory Manager
==============================
STATS-NAME VALUE
MemAllocated 67599536 ( 66015 KB )
MemAllocatedMax 160044816 ( 156293 KB )
MemAllocatedEver 1009672456 ( 986008 KB )
MemNAllocated 77309
MemNAllocatedEver 914028
MemNTimesLocked 0
MemNTimesWaited 0 ( 0.0 %)
|
============================== Thread Manager ============================== |
|||
|
STATS-NAME ThrNumOfCpus |
VALUE 4 |
||
|
ThreadLimit |
99 |
||
|
ThrNumThreads |
98 |
( 99.0 |
%) |
|
ThrReserved |
15 |
( 15.2 |
%) |
|
ThrNumFree |
55 |
( 55.6 |
%) |
|
NumThrUsed |
44 |
( 44.4 |
%) |
|
UsedPerActiveCmd |
22 |
||
|
ThrNTeamsInUse |
5 |
||
|
ThrMaxTeams |
7 |
||
|
NumTeamsAlloc |
238 |
||
|
TeamThrAlloc |
421 |
||
|
SingleThrAlloc |
492 |
||
|
ThrMutexLocks |
0 |
||
|
ThrMutexWaits |
0 |
( 0.0 |
%) |
|
============================== CPU time statistics ============================== |
|||
|
STATS-NAME Elapsed Seconds |
VALUE 59.65 |
( 25.0 |
%) |
|
CPU User Seconds |
37.79 |
( 15.8 |
%) |
|
CPU Sys Seconds |
1.89 |
( 0.8 |
%) |
|
CPU Total Seconds |
39.68 |
( 16.6 |
%) |
|
============================== Transaction Manager ============================== |
|||
|
STATS-NAME TxnMgrNPending |
VALUE 0 |
||
|
TxnMgrNBlocked |
2 |
||
|
TxnMgrNWaiting |
0 |
||
TxnMgrPCcondvar Locks 0 Lock-Wait 0 ( 0.0 %)
Signals 0 Broadcasts 2 Waits 2
TxnMgrTxnIDseq 407
TxnMgrtxncblock Locks 0 Lock-Wait 0 ( 0.0 %)
TxnMgrVersionID 0
TxnMgrOAVI 0
TxnMgrVersionLock Locks 0 Lock-Wait 0 ( 0.0 %)
Signals 0 Broadcasts 0 Waits 0
示例 7：
在 20 分钟后显示服务器上下文和目录统计信息的输出。
sp_iqsysmon '00:20:00', 'context catalog'
==============================
Context Server statistics
==============================
|
STATS-NAME |
VALUE |
|
|
StCntxNumConns |
1 |
|
|
StCntxNResource |
16 |
|
|
StCntxNOrigResource |
18 |
|
|
StCntxNWaiting |
0 |
|
|
StCntxNWaited |
0 |
|
|
StCntxNAdmitted |
1116 |
|
|
StCntxLock |
Locks 0 Lock-Waits |
0 ( 0.0 %) |
|
StCntxCondVar |
Locks 0 Lock-Waits |
0 ( 0.0 %) |
==============================
Catalog, DB Log, and Repository statistics
==============================
STATS-NAME VALUE
CatalogLock RdLocks 0 RdWaits 0 ( 0.0 %) RdTryFails
0 WrLocks 30037 WrWaits 0 ( 0.0 %) WrTryFail 0 DbLogMLock Locks 0 Lock-Waits 0 ( 0.0 %)
DbLogSLock Locks 0 Lock-Waits 0 ( 0.0 %)
RepositoryNList 0
RepositoryLock Locks 1 SpinsWoTO 0 ( 0.0 %) Spins
0 TimeOuts 0 ( 0.0 %)
示例 8：
在 20 分钟后显示 IQ RLV 内存存储库和大容量内存分配器 (LMA) 统计信息的输出。
sp_iqsysmon '00:20:00', 'rlv lma'
==============================
IQ In-Memory Store
==============================
STATS-NAME VALUE
RLV Memory Limit 2048 MB
RLV Memory Used 0 MB
RLV Chunks Used 0
==============================
Large Memory Allocator
==============================
STATS-NAME VALUE
Large Memory Space 2048 MB Large Memory Max Fle 512 MB Large Memory Num Fle 0
Large Memory Flexibl 0.5
Large Memory Flexibl 0 MB
Large Memory Inflexi 0.9
Large Memory Inflexi 0 MB
Large Memory Anti-St 0.5
Large Memory Num Con 0
Sybase SQL Anywhere数据库恢复工具ReadASADB：
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。
Sybase SQL Anywhere数据库恢复工具ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具
- 适用于所有的SQL Anywhere版本 包括：5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x,16.x,17.x
- 适用于所有的UltraLite版本
- 能够恢复出来表结构和数据
- 能够恢复自定义数据类型
- 能够恢复存储过程等对象的语法
- 能够导出到目标数据库
- 能够导出到SQL文件并生成导入脚本
- 支持多种字符集，包括：cp850、cp936、gb18030、utf8等
- 能够恢复未加密或者简单加密类型的数据
- 简单易用
- 限制：不支持AES加密的数据文件
SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍
Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景
各种误操作：
- 误截断表(truncate table)
- 误删除表(drop table)
- 错误的where条件误删数据
- 误删除db或log文件
- 误删除表中的字段
Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景：
1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况；
2.误操作，包括truncate table,drop table,不正确的where条件导致的误删除等；
Sybase SQL Anywhere无法打开时，比较常见的错误是：Assertion failed。
如：
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back
Sybase ASE数据库恢复工具READSYBDEVICE：
一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具！能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。
Sybase ASE数据库恢复工具READSYBDEVICE的主要功能：
- 被勒索病毒加密数据文件及备份文件情况下的恢复；
- 系统崩溃只剩下数据文件的情况下的恢复，甚至数据库文件不存在而只有损坏的备份文件情况下的恢复；
- 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复；
- delete数据恢复、误update数据恢复、误删除表(drop）恢复、误truncate表恢复 等；
- 各种Sybase内部系统表损坏、索引错误的修复；
- master数据库损坏而无法正常运行情况下的恢复；
- Sybase数据库被标记为可疑，不可用等情况的恢复；
- Sybase数据库中数据文件内部出现坏块情况下的恢复；
- Sybase数据库无数据文件但有日志文件的情况下的恢复；
- Sybase数据库只有数据文件无任何日志文件的情况下的恢复；
- Sybase数据文件被误删除情况下的碎片提取恢复；
- 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复；
- 数据库sysobjects等系统表损坏无法正常应用情况下的恢复；
- Sybase数据库还原数据库出现失败情况下的恢复；
- Sybase数据库只剩下损坏的备份文件情况下的恢复。
Sybase ASE数据库恢复工具READSYBDEVICE支持的版本：
Sybase ASE 11.0.x，11.5.x，11.9.x，12.0.x，12.5.x，15.0.x，15.5.x，15.7.x，16.0.xSQL Server数据库恢复工具SQLRescue：
一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具！能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。
SQL Server数据库恢复工具SQLRescue的主要功能：
- 系统崩溃只剩下数据文件的情况下的恢复，即无日志文件或者日志文件损坏情况下的恢复；
- 断电导致数据库文件损坏情况下的恢复；
- 硬盘坏道造成数据库损坏情况下的恢复；
- 数据文件内部存在坏页情况下的恢复；
- 企业管理器误删除数据表记录，管理软件误删除数据表记录的恢复；
- 并闩锁错误、格式化、误删除后导致软件不能使用的情况；
- 无法读取并闩锁页sysindexes失败情况下的修复；
- 数据文件被误删除情况下的碎片提取恢复；
- 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回；
- master数据库损坏而无法正常运行情况下的恢复；
- 数据文件无法附加情况下的数据恢复；
- 数据库被标记为可疑，质疑，不可用等情况的恢复；
- 数据库sysobjects等系统表损坏情况下的恢复；
- 数据被误(drop、delete、truncate）删除表数据的恢复,误update后的数据恢复等；
- 还原时报一致性错误，错误823等情况下的数据恢复，各种错误提示的数据库文件修复；
- 数据库被误格式化等情况下的数据库恢复；
- 日志收缩造成数据库损坏情况下的恢复；
- 仅剩损坏的备份文件情况下的恢复。
SQL Server数据库恢复工具SQLRescue技术特点：
只要SQL Server数据库的数据文件存在，我们就有办法帮您从数据文件中找回重要数据。- 从数据文件中直接恢复数据
- 不能附加时直接恢复数据并生成新的数据库
- 系统表损坏的数据库修复
- 快速修复SQL 823错误、连接中断错误
SQL Server数据库恢复工具SQLRescue支持的版本：
Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。+-------------------------------------华丽的分割线-------------------------------------------------------------------------
提供Sybase ASE及Sybase SQL Anywhere数据库修复服务，电话: 13811580958(微信)，QQ: 289965371！We have many years of experience in recovering data from damanged Sybase devices. Contact us by Phone: +86 13811580958 Wechat: 13811580958 Email: 289965371@qq.com
京ICP备2020043699号-2
Powered by WordPress | SiteMap | Baidu Knows | Google Knows | About
