monitoring

SQL Monitor v11.1 now supports Azure SQL Managed Instances

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Migration to the cloud and PaaS solutions has accelerated in the past years, and many organizations now manage hybrid estates. To reflect this, the latest release of SQL Monitor adds Azure SQL Managed Instances to its list of supported cloud platforms. This article explains how to monitor performance and activity for Azure SQL Managed Instances using SQL Monitor, with advice on monitoring hybrid estates and migrating from on-prem to Azure SQL Managed Instance.

2021-04-15

Why is my SQL Server Query Suddenly Slow?

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

A SQL Server query is suddenly running slowly, for no obvious reason. Grant Fritchey shares a 5-point plan to help you track down the cause and fix the problem.

2021-03-26

Win a Pluralsight subscription with Redgate’s competition

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Redgate is giving you the chance to win a three-month subscription to the technical skills platform Pluralsight and Redgate goodies with their latest competition. To enter, visit the Redgate Forums and answer the question ‘What’s your favorite SQL Monitor feature and why?’

2021-03-02 (first published: 2021-02-16)

Finding Inactive SQL Server Databases

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Phil Factor demonstrates how to use Extended Events to detect acquisition of Intent locks, and so determine which databases are active or apparently 'dormant', and then on which tables data has been modified recently, or which views and stored procedures have been run.

2021-01-28

Is Tempdb Causing a Bottleneck?

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

One of your SQL Server instance shows a major dip in performance or throughput, affecting all the user databases. You notice that the slow interludes coincide, as if orchestrated. On investigation, it appears that several transactions running over that period were using a lot of space in tempdb. However, which of them, if any, are causing the tempdb bottleneck, and why?

2021-01-26

Ten Reasons your SQL Server Monitoring will Scale

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

This article explains ten ways that SQL Monitor tackles the problem of scaling out the coverage of a single, lightweight monitoring system, and so allows your teams to maintain the health and performance of larger collections of databases and higher numbers of monitored SQL servers.

2021-01-19

Optimize SQL Server estate monitoring with Redgate's SQL Monitor

• by Additional Articles

• MSSQLTips.com

• Database Administration

• Article

How can we balance our need to monitor SQL Server performance and operational processes across hundreds of SQL Servers, but also save time by focusing on the highest priority issues?

2021-01-13

Monitoring Amazon RDS SQL Servers to Optimize Performance and Manage Costs

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Israel Valverde explains the triple benefits of extending SQL Monitor to cover your SQL Server instances running on Amazon RDS, in terms of SQL Server performance optimization, controlling AWS-hosting costs, and in having a single, unified view of the health of all your SQL Servers, regardless of where they are hosted.

2020-12-28

Tackling the challenges of hybrid, cloud, and on-premises SQL Server estates

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

As more organizations are managing at least some part of their data in the cloud, estate monitoring can become more complex with a mix of on-prem and cloud-based instances. Grant Fritchey discusses why businesses might move to the cloud, why they might stay on-prem, and when a hybrid approach might be best.

2020-12-21

Optimize SQL Server estate monitoring with Redgate's SQL Monitor

• by Additional Articles

• MSSQLTips.com

• Database Administration

• Article

How can we balance our need to monitor SQL Server performance and operational processes across hundreds of SQL Servers, but also save time by focusing on the highest priority issues?

2020-12-04