What is a Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It's a full-featured, enterprise-grade database system that uses Structured Query Language (SQL) to interact with data. SQL Server is used for a wide range of applications, from small single-user applications to large internet-facing applications with numerous concurrent users.
MS SQL Server provides a rich set of tools for database management, including SQL Server Management Studio, a powerful graphical user interface for managing databases, writing queries, configuring security settings and more. It also includes SQL Server Integration Services (SSIS) for data integration and transformation, SQL Server Analysis Services (SSAS) for data mining and analysis and SQL Server Reporting Services (SSRS) for report generation.
SQL Server supports a wide range of data types, including primitive types as well as complex types such as spatial and XML data. It also supports full-text search, which allows users to run full-text queries against character-based data in SQL Server tables.
How to monitor Microsoft SQL Server?
ServicePilot makes it easy to monitor a Microsoft SQL Server database requiring only a DB account with read privileges. Simply add a resource from the ServicePilot database-sql-server package to your monitoring environment.
The statistics gathered in this way provide a Microsoft SQL Server Instance system performance monitoring (Logins, logouts, MARS Deadlocks...) as well as SQL Server Databases performance indicators (Active transactions, data files size, log cache hit ratio...).
How to install a sql-server resource?
- Use your ServicePilot OnPremise installation or a SaaS account.
- Add a new sql-server resource via the web interface (
/prmresources) or via API (
/prmpackagespage), the default ServicePilot agent or another agent will be provisioned automatically.
Details of the sql-server package are located in the
/prmpackagespage of the software.
ServicePilot enables you to deliver IT services faster and more securely with automated discovery and advanced monitoring features.
By correlating the technology SQL SERVER with APM and infrastructure monitoring, ServicePilot is able to provide a more comprehensive view of an organization's IT environment.
This allows IT teams to quickly identify and diagnose issues that may be impacting application performance, and take corrective action before end-users are affected.