someone know what permissions are really necessary for SQL server monitoring?
I made all configurations that are listed on oficial doc but I get a error message to collect some informations that seems to be a permission problem.
I tryed to use a user with sysadmin and its worked, but I can´t use sysadmin,
So I need to give just the permission that is really necessary.
This is the error message:
Nov 21 17:05:15:464  sqlserver: Profile: ipbtbdbman01\default/fg_freeSpace_with_avail_disk/Run Query - DB Provider: Code=0x80040e14 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named '#temptab' in the database.