Locked
Discussion interactions are currently paused.
SQL Transactions (No Data)
Hello,
We had an unexpected event in an environment of ours where it seems the hosts for the VM's was restarted which unexpectedly restarted the VM's. We have gotten VM's back online but now we are getting several alerts for SQL Transactions showing No Data. The SQL services are running and the SQL DB is working fine it seems. Any idea what else could cause this error or issue? A rebbot has been done at well to try and resolve the issue.
Josh Low
Posted 7 years ago·Last reply 7 years ago
3 comments
Mike Moniz
·7 years agoMight be a sign that the collector is unable to communicate with the SQL server software. I would attempt to talk with the SQL server (via some client software) from the collector server.
Type of SQL server? MSSQL? MySQL?
What is the name of the DataSource with No Data? Do any other related SQL DataSources work?
Josh Low
OP7 years agoYes, when I do Poll Now it spins for a while then say's it Pol Now Timeout. Poll Now does work for other DataSources.
Michael Rodrigues
·7 years ago@joshlowit1 have you tried running Poll Now? It should give you more information on why collection is failing.