SQL Server Backup Monitoring with PowerShell
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
Monitoring
Easily manage SQL Server licensing with SQL Monitor 10.1
SQL Monitor 10.1 now gives you a comprehensive overview of your SQL Server licensing, so you know which licenses are in use, and which versions are on which servers. This simplifies license auditing and lets you unearth misconfigurations that could potentially cost you money. The new version also integrates with Microsoft Teams and Splunk, and supports complex Active Directory environments.
2020-07-02
Checking for Database Events Using Extended Events and SQL Monitor
You need to make sure that nobody tampers with your production databases, or really any databases outside Development. Even if you weren't of a nervous disposition, you'd want to know if a database was stopped or removed. You'd also be intrigued by the sudden unrehearsed addition of a database to a production server.
2020-02-14
Monitoring your Servers and Databases with New Relic Infrastructure and SQL Monitor
New Relic Infrastructure is a capable server monitoring tool but adding Integrations provides only 'bare bones' monitoring for SQL Server. Grant Fritchey argues that to "instrument" a complex system such as SQL Server, effectively, you also need a tool that is built specifically for this purpose.
2020-01-15
What you need to consider for your monitoring strategy in 2020
Are you ready for growth in 2020? Whether that means wider business growth which you and your team will be expected to support, expansion of your SQL Server estate, or even your own professional development. Join Redgate in this free webinar on November 20th and be prepared for the coming year.
2019-11-01
Key findings from the State of SQL Server Monitoring
Microsoft MVP Grant Fritchey provides an insight into the key findings from the report; what is the biggest challenge facing database professionals this year? How are estates changing? And what technologies are being used across the industry? Read Grant’s blog to find out.
2019-07-16
The 2019 State of SQL Server Monitoring Report
Redgate's second annual State of SQL Server Monitoring survey provides new insights into how the world of SQL Server monitoring is adjusting and adapting to emerging challenges, such as compliance regulations and cloud technologies, while keeping on-top of the usual issues such as deployments, availability, and capacity.
2019-07-03 (first published: 2019-06-28)
An Alert Philosophy
Many of you reading this will be responsible in some way for managing a system. This might be a test/development system or a production one, but often you want to know how well the system is working. Or maybe you want to know if the system is working at all. Even developers care if their […]
2019-06-19
248 reads
Databases made for Ops, not 'Oops!'
Just as you write a unit test before writing the code, so you must devise the means to monitor a database, to ensure its smooth operation, before creating the database.
2019-06-01
221 reads
Monitoring your servers and databases with SCOM and SQL Monitor
SCOM is good at monitoring the status of your servers. SQL Monitor give you a detailed view of your SQL Server instances, and databases, right across your network, however they are hosted. By using tools appropriately, for the tasks they do well, you benefit from a simpler and more comprehensive overall strategy.
2019-05-22
Blogs
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Microsoft Purview data governance best practices
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
AI Insights for Database Monitoring: A DBA’s Perspective
By Arun Sirpal
Second in a series on Ai and databases. One Story, three signals – I...
Forums
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Understanding SQL Server PARTITION BY with Examples
Comments posted to this topic are about the item Understanding SQL Server PARTITION BY...
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers