SQL Server is a relational database management system developed by Microsoft. It is commonly used in business environments and offers a wide range of features for storing, querying and manipulating data. SQL Server supports the SQL language and is known for its scalability, reliability, and performance. It provides advanced features such as ACID (Atomicity, Consistency, Isolation, and Durability) transaction support, integration with Microsoft’s .NET development platform, business intelligence (BI) support, data replication, disaster recovery, and enhanced security. Additionally, SQL Server offers multiple editions to meet the specific needs of different organizations, from small businesses to large corporations. SQL Server can also be deployed on-premises or as a managed cloud service, providing flexibility in choosing hosting infrastructure.
How to monitor SQL Server on One Platform
1 – In the side menu, click on Services Hub
2 – In the Database category, click on the SQL Server card
3 – You will be directed to the SQL Server configuration page, fill in the fields
4 – If you want, you can configure automatic incident opening. In the Open automatic incident section, fill in the fields:
- Severity -> Choose between “SEV-1 – Critical”, “SEV-2 – High”, “SEV-3 – Moderate”, “SEV-4 – Low”, “SEV-5 – Informational” or “Not Classified”;
- Check Interval in seconds -> This is the interval at which checking will take place (this interval cannot be less than the number of failures x the Interval configured in the monitoring form;
- Failures to open automatic incident -> It is the number of failures necessary to open the automatic incident;
- Check Interval in seconds -> This is the interval in which checking will take place (this interval cannot be less than the number of hits x the Interval configured in the monitoring form;
- Hits to close automatic incident -> It is the number of hits needed to close the automatic incident;
- Responders -> These are the teams that will be notified if there are incidents in this monitoring, and you can add one or multiple teams;
If necessary, you can create a team by clicking + RESPONDER, you will be directed to the form
to create the team, then click on the button
for the new team to appear in the list
***Don’t forget to activate the Enable to set up automatic incidents opening toggle to save the automatic incident opening settings
5 – Click on CREATE MONITORING
