An alarm and a database agent log displays errors like these permission denied errors:
YYYY-MM-DD HH:MM:SS.SSSECHO <DB_SQL_Server/5.5.8.559/DB_SQL_Server/DBSS-SERVERNAME-agent> ERROR [DB-agent-LowPriorityPool-29475] com.quest.qsi.fason.core.collection.processor.InstanceProcessor - Failed to run DBSSJdbcBufferManagerProcessor processor of DBSS_Buffer_Manager collection.
java.lang.RuntimeException: Failed to execute collection [DBSS_Buffer_Manager], reason=SELECT permission denied on object 'sysperfinfo', database 'master', owner 'dbo'.- Profile:MSSQLProfile{host='wsqlrib00001154', instance='DEFAULT_INSTANCE', username='', authType=WINDOWS_DEFAULT, port='0'useNTLMv2='true'} Query: "-- SQL Server 2000 /********************************************************************************************************************/ /* Functionality: This SQL returns a record set of all Buffer Manager related statistics metrics. */ /* Input Parameters: */ /******************************************...es' THEN ( CONVERT ( NUMERIC , cntr_value ) * 8 ) ELSE 0 END ) / 1024 As buffer_cache_reserved_mb , SUM ( CASE WHEN LOWER ( counter_name ) = 'stolen pages' THEN ( CONVERT ( NUMERIC , cntr_value ) * 8 ) ELSE 0 END ) / 1024 As buffer_cache_stolen_mb , SUM ( CASE WHEN LOWER ( count... expectancy' , 'page lookups/sec' , 'buffer cache hit ratio base' , 'buffer cache hit ratio' , 'checkpoint pages/sec' , 'lazy writes/sec' , 'readahead pages/sec' , 'page reads/sec' , 'page writes/sec' ) Group By counter_name ) As Z;"
at com.quest.qsi.fason.core.collection.processor.AbstractQueryProcessor.handleError(AbstractQueryProcessor.java:357)
at com.quest.qsi.fason.core.collection.processor.AbstractQueryProcessor.execute(AbstractQueryProcessor.java:250)
at com.quest.qsi.fason.
To verify the permissions problem:
Result will show as insufficient privileges
Click on the Grant Privileges link, providing a privileged user name and password.
The permissions script with provide needed access the agent user on that database.
To view the script, click on the Hyper Link below Grant Privileges link.
