Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Security
  5. Connection Management
  6. JDBC Client Configuration
  7. ODBC Client Configuration
  8. Access Control
  9. Logs
  10. High Availability
  11. Server Control
  12. Performance Tuning
  13. Troubleshooting
  14. Appendix A: Database Keywords

Administrator Guide

Administrator Guide

Log Performance

Log Performance

Log files use server resources to record service information and events. The tracing level determines the amount of information that the log stores.
Logs consume system resources and can slow down performance. To improve log performance, you can change the tracing level to reduce the amount of information that the log stores. By default, each log uses the information tracing level. The information tracing level is a high impact tracing level and uses the most server resources.
If you change the tracing level, it does not affect the tracing level for SQL Server.
The following table describes the different tracing levels:
Tracing Level
Description
Information
The default log level. Logs all information messages and provides comprehensive information about the Dynamic Data Masking service. The information that the log provides is useful if you encounter an issue with Dynamic Data Masking operations. You can refer to the logs to troubleshoot the problem.
Performance impact is high.
Warn
Logs warning messages from the Dynamic Data Masking service.
Performance impact is moderate.
Error
Logs error messages and instances when a user connection is force closed.
Performance impact is low.

0 COMMENTS

We’d like to hear from you!