> ## Documentation Index > Fetch the complete documentation index at: https://docs.germainux.com/llms.txt > Use this file to discover all available pages before exploring further. # Deploying GermainUX Monitoring for Microsoft SQL Server: Setup, Permissions, and Configuration Steps > Deploy GermainUX monitoring for Microsoft SQL Server to monitor database availability, performance, queries, connections, storage, and errors. Components [`Engine`](https://docs.germainux.com/main/germain-ux-engine) [`JS Profiler`](https://docs.germainux.com/main/germain-ux-js-profiler) [`RPA Bot Recorder`](https://docs.germainux.com/main/germain-ux-rpa-bot-recorder) [`RUM JS`](https://docs.germainux.com/main/germain-ux-rum-js) Availability 2017.1 or later > **[Create a SQL Server Monitoring Account](#1-create-a-sql-server-monitoring-account)** > > Database account permissions > **[Add the Database Credentials](#3-add-the-database-credentials)** > > Store credentials in Workspace > **[Configure the Monitoring Node & Engine](#6-configure-the-monitoring-node-&-engine)** > > Assign node and engine > **[Validate the Deployment](#8-validate-the-deployment)** > > Verify monitor in State **Deploy Monitoring for Microsoft SQL Server** Deploy GermainUX monitoring for Microsoft SQL Server to monitor database availability, performance, queries, connections, storage, errors, and application-specific database conditions. > [!NOTE] > > SQL Server monitoring is executed by the **GermainUX Engine** using a database connection to the monitored SQL Server instance. ## 1. Create a SQL Server Monitoring Account Create or select a SQL Server database account for GermainUX monitoring. ![Deploying GermainUX Monitoring for Microsoft SQL Server: Setup, Permissions, and Configuration Steps: 1. Create a SQL Server Monitoring Acco](https://mintcdn.com/germain-ux/hPK2RwO7wyn44bNw/images/main/deploying-germainux-monitoring-for-microsoft-sql-server-setup-permissions-and-configuration-steps/image2023-2-21_12-0-13.png?fit=max\&auto=format\&n=hPK2RwO7wyn44bNw\&q=85\&s=ec2b77fe24ebe98dbf8335090fba6277) For basic monitoring of a SQL Server instance, GermainUX can use a regular database account with the appropriate connection permissions. More comprehensive monitoring requires additional permissions to query SQL Server system views and performance information. ## 2. Grant SQL Server Monitoring Permissions Grant the GermainUX monitoring account access to the SQL Server information required for monitoring. The standard SQL Server monitoring configuration uses: | Table / View | Permission | | - | - | | `sys.dm_os_performance_counters` | SELECT | | `sys.dm_exec_sessions` | SELECT | The monitoring account also requires: `VIEW SERVER STATE` Example: USE master; GRANT SELECT ON sys.dm\_os\_performance\_counters TO \[germain-user]; GRANT SELECT ON sys.dm\_exec\_sessions TO \[germain-user]; GRANT VIEW SERVER STATE TO \[germain-user]; These permissions provide access to SQL Server system information used by GermainUX monitoring. Additional permissions can be granted when GermainUX needs to monitor other SQL Server system views, tables, or application data. Apply the minimum permissions appropriate for the monitoring requirements of your environment. ## 3. Add the Database Credentials In Germain Workspace, configure the credentials used to connect to SQL Server. Navigate to: **Left Menu → Settings -> Data Sources → Credentials** ![Deploying GermainUX Monitoring for Microsoft SQL Server: Setup, Permissions, and Configuration Steps: 3. Add the Database Credentials](https://mintcdn.com/germain-ux/hPK2RwO7wyn44bNw/images/main/deploying-germainux-monitoring-for-microsoft-sql-server-setup-permissions-and-configuration-steps/image-20230221-140419.png?fit=max\&auto=format\&n=hPK2RwO7wyn44bNw\&q=85\&s=6a34033d1a3825c6fad5bddbafb57361) Add the SQL Server monitoring credentials. These credentials will be referenced by the database data source used by the GermainUX Engine. ![Deploying GermainUX Monitoring for Microsoft SQL Server: Setup, Permissions, and Configuration Steps: 3. Add the Database Credentials, image](https://mintcdn.com/germain-ux/hPK2RwO7wyn44bNw/images/main/deploying-germainux-monitoring-for-microsoft-sql-server-setup-permissions-and-configuration-steps/image-20260907-182536.png?fit=max\&auto=format\&n=hPK2RwO7wyn44bNw\&q=85\&s=d33c9829690f0e13e175e4a875c5cc7c) ## 4. Add SQL Server as a Data Source Navigate to: Germain Workspace Left Menu Data Sources Database Add New Configuration Configure the connection to the SQL Server instance. Enter the database connection information required for your environment and associate the appropriate credentials. ## 5. Validate Database Connectivity Verify that the GermainUX Engine can connect to the SQL Server instance using the configured data source and credentials. Confirm that the monitoring account can access the SQL Server system views required for the monitoring capabilities you intend to enable. Resolve connectivity, authentication, or permission issues before configuring individual monitors. ## 6. Configure the Monitoring Node & Engine SQL Server monitoring runs from a GermainUX Engine. When deploying a monitor, select: **Monitoring Node** \ The GermainUX Node from which the Engine operates. **Engine** \ The GermainUX Engine that will execute the SQL Server monitor. Ensure that the selected Engine has network connectivity to the SQL Server instance. ## 7. Configure the Monitoring Schedule Define how frequently the SQL Server monitor should execute. Choose a monitoring frequency appropriate for: * The SQL Server metric or condition being monitored * Operational requirements * Required detection speed * Database workload * Query cost Higher-frequency monitoring should be used selectively for conditions requiring rapid detection. ## 8. Validate the Deployment After deployment, verify that SQL Server monitoring is operational. Confirm that: * GermainUX can connect to SQL Server * Credentials are valid * Required permissions are available * The selected Engine can execute the monitor * Monitoring executes according to schedule * SQL Server telemetry is received by GermainUX Verify the deployed monitor in **Germain State**. ## Next Steps Once the SQL Server connection and Engine monitoring are operational, configure the database metrics and conditions relevant to your environment. For example: * Query performance * SQL Server performance counters * Database connections * Storage utilization * Backup status * Errors > **Show all 9** > > * Custom SQL queries > * Application-specific database KPIs > * SLAs and alerts See **Configure Monitoring for Microsoft SQL Server** for instructions. ## Get More Information The database permissions required by GermainUX depend on the SQL Server information and application data you choose to monitor. Additional tables, views, and custom SQL queries can be monitored when the appropriate permissions are granted to the GermainUX monitoring account. Please contact us [for any help.](https://docs.germainux.com/main/support.md) ## Get Help > **[Contact GermainUX Support](https://docs.germainux.com/main/support.md)** > > The Germain Team can help you set this up. > **Can't find what you need?** > > Search all GermainUX docs with **Ctrl + K**, or use the feedback buttons at the bottom of this page to tell us what is missing. The content of this document is proprietary to GERMAIN SOFTWARE. This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.