Activity overview
Latest activity by FrankSchneider
No - we still had this issue.
Without sysadmin - role the Monitoring doesnt work.
Hope that Red-Gate can help with an solution. / comments
No - we still had this issue.
Without sysadmin - role the Monitoring doesnt work.
Hope that Red-Gate can help with an solution.
Hi Adam
thanks for your answer.
Unfortunately i am not able to figure out which are the specific flags : sysadmin role required for Integrity check overdue alerts and to allow SQL Monitor to turn on the deadlock trace flag (this flag is required for Deadlock alerts to be raised; you can turn on the flag manually if you don't want to enable sysadmin permissions).
We are monitoring a 2 node AlwaysOn Cluster with 4 Instances.
In every Instance the following Commands were executed :
GRANT VIEW ANY DEFINITION TO [xxxxxyyyyyyyyyyyyyy]
GRANT VIEW SERVER STATE TO [xxxxxyyyyyyyyyyyyyy]
GRANT VIEW DATABASE STATE TO [xxxxxyyyyyyyyyyyyyy]
But i still got the error (after removing the sysadmin role from the monitoring account) :
IntegrityCheckSampler Incorrect credentials or insufficient permissions SqlException User 'xxxxxyyyyyyyyyyyyyy' does not have permission to run DBCC DBINFO.
Could you please explain how to disable the IntegrityCheckSampler ?
SQLMonitor - Version below Version 6 was running fine over the last 2 years without the sysadmin - role.
regards, Frank / comments
Hi Adam
thanks for your answer.
Unfortunately i am not able to figure out which are the specific flags :sysadmin role required for Integrity check overdue alerts and to allow SQL Monitor to turn on...
new Permissions needed for monitoring
Today i have upgraded SQLMonitor to Version 6.
The installation was successful and without any issues.
Afterwards i try to resume monitored which was suspended before installation.
Unfortunately i ...
Hi Alex
not my preferred opinion but thanks for the hint.
Handling with CSV Export / Import is time consuming manual work and thats not what im looking for.
regards, Frank / comments
Hi Alex
not my preferred opinion but thanks for the hint.
Handling with CSV Export / Import is time consuming manual work and thats not what im looking for.
regards, Frank
The idea was to query the SQL Monitor Database where the values are still persisted ;-). / comments
The idea was to query the SQL Monitor Database where the values are still persisted ;-).
How to query highest Log Send Queue Values
In our Production environment sometimes SQL Monitor trigger the Error - Replication is falling behind.
To find out the cause of lagging it would be helpful to query the database for the Log Send Qu...