products:promonitor:6.8:troubleshooting:monitoring:db_connections
DB connection Issues
Activate driver logs
- You can activate logs from DB drivers in order to investigate specific database issues.
- Create the file
[PM_INSTALL_FOLDER]\workers\worker1\logging.properties - Set the logging properties within the file.
- Mind to remove/rename the file once investigation is over
- Example for MSSQL:
# Logging levels: OFF, SEVERE, WARNING, INFO, CONFIG, FINE, FINER, FINEST, ALL # Set the default logging level for all loggers # .level =ALL # Configure the file handler handlers = java.util.logging.FileHandler java.util.logging.FileHandler.level = ALL java.util.logging.FileHandler.pattern = mssql.log java.util.logging.FileHandler.append = true java.util.logging.FileHandler.formatter = java.util.logging.SimpleFormatter # Configure the MSSQL driver logger com.microsoft.sqlserver.jdbc.level = ALL com.microsoft.sqlserver.jdbc.formatter = java.util.logging.SimpleFormatter # Uncomment the following line if you want to log the SQL statements # com.microsoft.sqlserver.jdbc.level = FINEST # Uncomment the following line if you want to log parameters along with SQL statements # com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.level = FINEST # Uncomment the following line if you want to log results along with SQL statements # com.microsoft.sqlserver.jdbc.SQLServerResultSet.level = FINEST
products/promonitor/6.8/troubleshooting/monitoring/db_connections.txt · Last modified: by 127.0.0.1
