SYBASE - SAP IQ Performance Tuning

Monitor last time any object was accessed in SAP SYBASE IQ There is a way to find out the last time an object (table/view/st proc) was accessed by an application in IQ. You enable it, then can run reports against the data over time on things like table and index use, tables and indexes not used, etc.   sp_iqworkmon Procedure   It Controls collection of workload monitor usage information, and reports monitoring collection status. sp_iqworkmon collects information for all SQL statements.   Note: Usage is collected only for SQL statements containing a FROM clause; for example, SELECT , UPDATE , and DELETE .   See also * sp_iqcolumnuse * sp_iqindexadvice * sp_iqindexuse * sp_iqtableuse * sp_iqunusedcolumn * sp_iqunusedindex * sp_iqunusedtable

SAP SYBASE IQ Diagnostics and Hang Analysis   IQ Diagnostics and Analysis for Hung Server   1)       Symptoms Some of the symptoms, that could lead you (or users) to think that IQ server is hung are : - No new connections can be made to the server either from the same host machine or different host machine over TCP/IP network. - No tasks seems to be working and there is no new messages seen in the IQ server log (.iqmsg file), if no existing connections doing work. - The messages appear to be sparse in .iqmsg file, no task how-ever simple, does appear to get completed in a timely manner. - Catalog .db and .log time not getting updated on any IQ nodes. - Hardware bottleneck – IO stuck   2)       IQ Diagnostics checklist Collect and analyzethe following diagnostic information for all IQ problems and/or symptoms - Know clear problem description and/or exact error message. - Has a...