Back to top icon

Monitoring Microsoft SQL Server with New Relic Infrastructure

Microsoft SQL (MS SQL) Server is a relational database management system. As a database server, the primary function is to store and retrieve data as requested by other software applications—which may run on the same server, on another server across the network, or in the cloud.

Our on-host integration collects and sends inventory and metrics from your MS SQL Server environment to New Relic Infrastructure. Database- and instance-level metrics are collected and you can see the health of your environment at-a-glance—making it easier to find the source of any problems that arise.

What you can monitor with our Microsoft SQL Server integration

Database metrics

Track the size of your page file, how many times the transaction log has expanded, the size of the buffer pool, and the stall wait time.


.

 

 

Instance metrics

Get detailed metrics from your database instances, like the number of processes and buffer cache hit ratio.

Wait metrics

For each wait type, see how long you're waiting and the number of waits per second.

You need to know what’s happening in your Microsoft SQL Server

Databases like MS SQL Server can become huge in size and thousands of queries can be performed per second. It's important to track and understand your disk performance, memory consumption, and query performance, so you can make sure your customers are served with the best possible user experience.

See your MS SQL Server metrics in pre-built dashboards

Visualize all your data, easily filter to a specific host, and correlate with other performance metrics.

Default Mssql dashboards

Track all MS SQL Server configuration changes

Understand configuration differences across your stack and quantify how configuration changes impact performance.

Kafka Alert Example

Know immediately when your performance is degrading

You can set up and receive alerts for any of the metrics captured—for example, when the number of database connections goes up—and stay on top of your MS SQL Server performance.

 

General Alert Example

Ready to get started?

Install the integration now and get a clear picture of your MS SQL Server performance.

Activate the Microsoft SQL Server integration Request demo