DQS Log

Question

From which table i can recollect the logged information ?

Also at what level of granularity the log is maintained  ?

Answer 1

Hi Deepak,

DQS has a robust logging mechanism. DQS logs can broadly be divided into two parts:

• Installation log: The DQS_install.log file contains information about the actions performed on running the DQSInstaller.exe file. The file is typically created in the C:\Program Files\Microsoft SQL Server\MSSQL11.<instance_name>\MSSQL\Log folder.
• Operational log: Separate log files are generated to log the activities performed on Data Quality Server, Data Quality Client, and the DQS Cleansing component in SSIS. For detailed information, see Manage DQS Log Files on MSDN.

Further, you can use Data Quality Client to configure the log severity setting for Data Quality Server features and modules. Additionally, you can also configure some other (advanced) settings for the DQS log files by manually changing the DQS log configuration settings in the DQS_MAIN database and an XML file on the Data Quality Client computer. For detailed information, see Configure Severity Levels for DQS Log Files and Configure Advanced Settings for DQS Log Files.

Hope you find it useful.

Thanks,
Vivek
(SQL Server Documentation | Twitter: @vivek_msft)