monitoring

Article

The 2021 State of Database Monitoring survey is now open, and we want to know how you’re currently tackling your server, instance, and database monitoring. By taking part, you’ll contribute to the sole industry-wide report on database monitoring, and provide insights into how SQL Server professionals manage their estates and what challenges they face. Plus, you’ll receive an advanced copy of the report and entry to a prize draw to win a $500 Amazon voucher.

2021-04-19

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

monitoring

Tell us about how you monitor your databases

SQL Monitor v11.1 now supports Azure SQL Managed Instances

Why is my SQL Server Query Suddenly Slow?

Win a Pluralsight subscription with Redgate’s competition

Finding Inactive SQL Server Databases

Is Tempdb Causing a Bottleneck?

Ten Reasons your SQL Server Monitoring will Scale

Optimize SQL Server estate monitoring with Redgate's SQL Monitor

Monitoring Amazon RDS SQL Servers to Optimize Performance and Manage Costs

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

Blogs

Use a slicer to filter a visual based upon a measure in Power BI

Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger

Microsoft Fabric shortcuts

Forums

Truncate tables where Referential Integrity exists

Blocking question

can I monitor auto stats updates through extended events?

Question of the Day

Post Restore Tasks for the Resource Database