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
Tony Maddonna, BMW’s SQL Server Enterprise Architect, writes about the challenges of database monitoring. Drawing on experiences throughout his career, this blog covers manual vs third party, proactive monitoring in dev and test, and managing expectations of the cloud. To learn more, and read his tips on how to build a business case for third-party tooling, check out his blog.
2020-11-27
In this article we continue our PowerShell monitoring series with scripts that check the current version and build for all SQL Server instances in your environment.
2020-11-26
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
1,860 reads
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
2020-09-29
6,136 reads
In this article we look at how to send Slack notifications when certain events occur in a SQL Server database.
2020-09-18
Nearly 1000 database professionals took part in this year's State of Database Monitoring survey. Providing insights into how they monitor their estates, the technologies they work with, what their biggest challenges are, and emerging trends for 2020. For the detailed analysis of the responses, download your free copy of the report.
2020-06-09
2020-06-01
Not only are SQL Monitor Groups probably the neatest and most maintainable way of ensuring that all your SQL Servers have the best possible configuration of alerts, but they represent a powerful way of categorizing your SQL Server estate. In this article, I'll show how to use the SQL Monitor PowerShell API to export these groups, save their settings onto a configuration management system, or compare groups of settings to see the differences between them.
2020-03-25
787 reads
New release: SQL Monitor 10
SQL Monitor 10 has landed! You can now integrate SQL Monitor alerts with your ticket management system, so chosen alerts are automatically raised as tickets. New suppression options give you granular control over what alerts are raised during specific times, such as maintenance windows. And, you can now annotate the server activity graph with specific events, so you can measure their impact on your servers.
Discover the new features
2020-03-23
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
By Steve Jones
This month is a great topic to me. I think growing and improving your...
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
Is there a trigger to notify when a new SQL Agent job is created/modified?
Hello I have a view based upon a number of tables I'm selecting...
In an Azure SQL Managed Instance there is no option to create what we...
In which editions can I use Full-Text and semantic search?
See possible answers