Troubleshooting slow performance or hangs due to custom Indexes
Product(s):
APM Implementation and Performance Management
Version(s):
7
Environment:
N/A
Area:
N/A
Subarea:
N/A
Problem
APM Foundation's database contains several indexes out of the box. These…
what is the difference between oq.checkivaraindexes and oq.checksystemindexes?
CheckIvaraIndexes loops through oq.omsystem to retrieve all the DBDomains to call CheckSystemIndexes.
The oq.CheckSystemIndexes will be called for the following schema:
OQ
DistributorData
CustomerData
IFW
FND
MNT
MAT
PRO
IVTEST
IVSTAGE…
Performance - detect Database Index fragmentation
Product(s):
APM Implementation and Performance Management
Version(s):
All Versions
Environment:
SQL Server
Area:
Database Performance
Subarea:
N\A
Problem
How to detect and resolve Database…