This SQL Optimizer for SAP ASE video discusses the SQL repository which stores the SQL that you've identified as critical to the performance of your database....
Identify Contention
The following query determines the miss ratio and the "immediate" miss ratio for redo log latches. Col MISS_RATIO format 999.99Col IMM_MISS_RATIO format 999.99
SELECT substr(ln.na...
If you are coming to this page by searching, then I am sure that you are in big trouble. I have come across this error and my SQL Server was not getting started. When I looked into ERRORLOG, I found b...
