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
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/troubleshooting/monitoring/db_connections.txt · Last modified: 2024/05/01 18:35 (external edit)