SQL Server – ElvenWorks

SQL Server is a relational database management system developed by Microsoft. It is commonly used in enterprise environments and offers a wide range of features for data storage, querying, and manipulation. SQL Server supports the SQL language and is known for its scalability, reliability, and performance. It provides advanced features such as support for ACID transactions (Atomicity, Consistency, Isolation, and Durability), integration with Microsoft's .NET development platform, business intelligence (BI) support, data replication, disaster recovery, and enhanced security.

Furthermore, SQL Server offers various editions to cater to the specific needs of different organizations, from small businesses to large corporations. It can be deployed either on-premises or as a managed service in the cloud, providing flexibility in choosing the hosting infrastructure.

How to Monitor A SQL Server on the One Platform

To set up monitoring for SQL Server on the platform, follow these steps:

Go to the product application where you want to add SQL Server as a dependency in the platform.
Click on the "Products" menu and select the desired product card.
Then, click on the name of the specific application where you want to configure SQL Server monitoring.
Look for the section called "External Dependencies," usually located just below the latency graph of the application.
To add an already registered dependency, type the name of the dependency in the search field and select it when it appears in the list.
If SQL Server is not yet registered as a dependency, click on the green button with a plus (+) symbol to add a new dependency.

Click "Add" and a modal will appear allowing you to name the database and select the Environment. In the "Check type" field, choose the option "DB," and in the "Method" field, select "SQL Server." After selecting the method, a field for the Healthcheck URL will appear.

Below is an example of string for SQL Server:

ex: sqlserver://USER:PASSWORD@HOST?database=DB

For questions, inquiries, or technical support, please contact us through the chat on the ElvenWorks platform or on our website.