You are hereSQL2000 / SQL2000
SQL2000
6.2: The Sql_Processes task or the Sql_Locks task from SQL2000 application is failing
The Sql_Processes task or the Sql_Locks task from SQL2000 application is failing in v6.2:
You got an email alerting you that either or both of these tasks are failing.
To fix this issue, please do the following :
kb87: SQLServer Cache reports show greater than expected cache hit %
SQLServer Cache reports display the Buffer Manager:cache hit percentage, rather than the Cache Manager:cache hit percentage.
The values in the report correspond to the "Buffer cache hit ratio" counter of the BufferManager object for the SQLServer instance in Performance Monitor.
kb37: Avoiding low free memory alerts if SQL Server is configured to use all memory
If you have SQL Server configured to use all available server memory and do not want Longitude to alert you about low free memory, you can set the MemFreePctMin rule property to zero (0) for the SQLServer, SQL2005, and Windows applications. This can be configured at the computer level using a specific value for the rule properties.
