The configuration and logs refers to a crucial aspect of database administration and monitoring. Configuration and logs encompasses the configuration settings that determine how SQL server operates and the various logs that record database activities.

Service Logs

The service logs refers to the logs which are generated by the SQL server service itself. These logs are a critical component of database administration and monitoring, which provides valuable information about the operation and health of the SQL server instance. In service log window, you can see the following details which are listed below:

• Timestamp: This refers to a data element that records the date and time when a specific event or SQL query occurred within a database management system (DBMS). You can see the date and time in the following format DD/MM/YY and HH:MM:SS.
• Database: This refers to the specific component within the logs that provides information about events, activities and errors related to individual database hosted by the SQL server instance.
• Class: This refers to categorize and identify different types of messages or events that are logged within the service logs.
• Method: This refers to the information about the method or process used for generating a particular log entry.
• Service: This refers to the identification of a specific SQL server service responsible for generating a particular log entry.
• Execution Time: This refers to the amount of time taken by a specific operation to execute within the SQL server instance.

Note: In the service log window, you can perform the following operations which are listed below:

• Search: You can perform search operation in the table by providing the timestamp, database, class, method etc in the Search in table column icon.
• Download : On clicking this icon, it will download the Service Logs report in the CSV file format in your local.
• Toggle Columns : On clicking this icon, you will be able to show or hide a column from the Service Logs report window.
• Toggle Filter : On clicking this icon, you can apply search operation on columns in the Service Logs report window.

DB Query Logs

The DB query logs refers to a set of logs that captures information about the execution of database queries within the SQL Server instance. These logs are essential for monitoring and auditing database activities, troubleshooting performance issues and also ensuring the security and integrity of the database environment. In the DB query logs window, you can see the following details which are listed below:

• Timestamp: This refers to a data element that records the date and time when a specific event or SQL query occurred within a database management system (DBMS). You can see the date and time in the following format DD/MM/YY and HH:MM:SS.
• Database: This refers to the specific component within the logs that provides information about events, activities and errors related to an individual database hosted by the SQL server instance.
• Class: This refers to categorizing and identifying different types of messages or events that are logged within the service logs.
• Method: This refers to the information about the method or process used for generating a particular log entry.
• Query: This refers to the specific SQL statement that was executed within the database management system (DBMS) such as: Microsoft SQL Server (MSSQL).
• Execution Time: This refers to the amount of time taken by a specific operation to execute within the SQL server instance.

Note: In the DB query log window, you can perform the following operations which are listed below:

• Search: You can perform search operation in the table by providing the timestamp, database, class, method etc in the Search in table column icon.
• Download : On clicking this icon, it will download the Service Logs report in the CSV file format in your local.
• Toggle Columns : On clicking this icon, you will be able to show or hide a column from the Service Logs report window.
• Toggle Filter : On clicking this icon, you can apply search operation on columns in the Service Logs report window.

The query execution refers to the process of executing a specific SQL query within the database management system (DBMS). These logs capture different detailed information about how a query was processed by the database engine, including its execution plan, duration and resource usage. In query execution, there are following predefined function which you can apply while executing a query which are listed below:

• EXEC sp_WholsActive: This refers to the execution of a stored procedure named "sp_WholsActive" within an SQL server database. This statement initiates the execution of the stored procedure, which can perform various database operations based on its design and purpose.
• EXEC sp_who: This refers to the execution of a built-in stored procedure named "sp_who". This procedure is designed to query and display information about active sessions and processes within the SQL server instance.
• Custom Query: This refers to the execution of a user-defined SQL query, which is a specific SQL statement crafted by a database administrator, or a user to perform custom database operation.

Note: Once you have selected the query which you want to execute by clicking on their corresponding radio buttons, you have to click on the Execute button to execute the query. On executing the query, the corresponding output for the query will be displayed in the Query Output window.

Query Output

In the query output window, you can see the following details for an executed query which are listed below:

• Status This refers to the current status of the execution of a SQL query which provides information about the progress and outcome of the query which is being executed such as: BACKGROUND.
• DiskIO This refers to the measurement and monitoring of input/output (I/O) operations related to disk storage during the execution of SQL queries.
• Command This refers to the type of the SQL command or statement which is being executed as a part of query such as: LOG WRITER.
• LastBatch This refers to the date and time at which the last query batch was executed. This is displayed in the MM/YY and HH:MM:SS format.
• DBName This refers to the name of the database on which the query was executed.
• Login This refers to the username through which the database was logged in.
• BlkBy This refers to the identifier of the session that is currently blocking the execution of a particular SQL query.
• Program Name This refers to the descriptive identifier associated with the application or program that initiated a particular SQL query.
• SPID This refers to the unique session number for the SQL agent job.
• HostName This refers to the network host name form which a SQL query is initiated and sent to the SQL server for execution.
• REQUESTEDID This refers to the amount of CPU processing time consumed by a specific SQL query during its execution.
• CPUTime This refers to the amount of CPU processing time consumed by a specific SQL query during its execution.

Note In the query output window, you can perform the following operations which are listed below:

• Search: You can perform search operation in the table by providing the name, value, value in use etc in the Search in table column icon.
• Download : On clicking this icon, it will download the Query Output report in the CSV file format in your local.

Note In the configuration logs window, you can apply the analysis mode by clicking on the Enable Analysis Mode button.