SQL Error

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
gsmith
Posts: 1253
Joined: Tue Mar 02, 2021 11:15 am

Re: SQL Error

Post by gsmith »

hi


I'd like to verify which table is being used for the system performance issue so please do the following:

login to mssql as user hpmon and password Password@789
then run:

Code: Select all

select count(*) from sys.sysperfinfo;
select count(*) from sys.dm_os_performance_counters
Thanks
sneha.irali
Posts: 141
Joined: Fri Jan 15, 2021 3:56 am

Re: SQL Error

Post by sneha.irali »

I think u can close the thread, cz there was a permission issue on the ID that was given to us for connectivity.
gsmith
Posts: 1253
Joined: Tue Mar 02, 2021 11:15 am

Re: SQL Error

Post by gsmith »

Ok.

Thank you
Locked