There are many reasons you should monitor your databases, including avoiding performance problems or running out of disk space. Ideally, you want a scalable monitoring solution where you can monitor all your SQL databases in one single place. This article will describe two options that are available: Azure SQL Analytics and Azure SQL Insights. Both […]
2022-03-18
10,088 reads
We need to transition our team from single instance management and monitoring to managing the overall environment and addressing our most pressing needs to support the organization. How can we move from managing the trees to managing the forest in an efficient and automated manner with a small team?
2022-02-07
I ran into this quote on the Microsoft Learn site, which I thought was a great way to think about how to administer a system: "Without a baseline, every issue encountered could be considered normal and therefore not require any additional intervention." When I've had users file tickets or complain about things not working well, […]
2022-01-24
127 reads
In this article we cover which performance monitor counters to use to baseline and troubleshoot SQL Server network issues that may be causing performance issues.
2021-11-01
Check out this SQL Server function that can return memory usage information for a SQL Server instance such as the amount of memory SQL Server is using and available memory on the machine.
2021-05-03
A recent hack through a network monitoring system is scary, but Steve thinks that we ought to not require these systems to have privileged access.
2021-01-06
174 reads
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
A recent issue with malware and SQL Servers has Steve wondering if you would detect a new, and unapproved, login added to an instance.
2020-10-05
216 reads
In this article we look at how to send Slack notifications when certain events occur in a SQL Server database.
2020-09-18
In this part of the series we look at how to use the PowerShell monitoring scripts to collect backup information from your monitored instances.
2020-07-24
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
Comments posted to this topic are about the item How Well Does the MSSQL...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers