Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Multiple Monitoring Tools

Part of my Redgate work is with customers who need to monitor their database servers. With estates growing quickly, both in scale and types of database platforms used, keeping an eye on everything can be challenging. Add in the lack of staff growing as quickly are the number of servers, and I find many companies seeking out monitoring tools to better help them manage the entire estate..

When someone evaluates a tool, one of the first questions from many people is about load. They are concerned about the load a tool puts on the system, which is always some amount. Most say they use less than 2% of total resources, some might hedge at 5%. Hopefully, there's no more impact than 5%, though that might seem to high, especially if you have a busy database server already.

I've seen several customers who have multiple monitoring systems. Often this is because each tool does something well, but lacks a feature or capability that another provides. Each of the tools needs its own data, which can result in more performance impact.

Is it worth the overhead? If you had a second tool that provided more capabilities, would you ditch one of your tools? I know I work for a vendor that produces a monitoring tool (Redgate Monitor), but I'm genuinely interested in how many of you view the world.

We often make trade-offs, but sometimes we aren't willing to change. Perhaps you have a tool that works very well doing a certain task, and you don't want to stop using it. I know I've been in that situation, and unless another tool adds that thing, or more things I desire, I'd likely continue to use two tools to accomplish all the things I need done.

Specialized tools have a place, and it can be worth the hassle of using them when a more general tool just doesn't get all the work done.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
  Featured Contents
SQLServerCentral Article

How to Choose the Right Tool for MS SQL to PostgreSQL Migration

intellicon from SQLServerCentral

Learn about a few different options for migrating from Microsoft SQL Server to PostgreSQL.

External Article

SQL Server 2022 on Ubuntu 24.04 step by step

Additional Articles from SimpleTalk

Microsoft does not yet support this edition of Ubuntu, but there are some workarounds to make it work. This should not be used for production usage and this blog is for educational/testing purposes only.

Blog Post

From the SQL Server Central Blogs - Cyber Scams and Operation Shamrock

K. Brian Kelley from Databases – Infrastructure – Security

Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East conference on cyber scams. How bad is it? Well, according to the Internet Crime Complaint...

Blog Post

From the SQL Server Central Blogs - Easily query your GitHub Contribution activity

Will Assaf from SQL Tact

For a variety of reasons, including your Microsoft MVP activity reports, you might want to summarize your GitHub activity across multiple repos. For contributors to Microsoft open-source docs on GitHub,...

Introduction to PostgreSQL for the data professional

Introduction to PostgreSQL for the data professional

Site Owners from SQLServerCentral

Adoption and use of PostgreSQL is growing all the time. From mom-and-pop shops to large enterprises, more data is being managed by PostgreSQL. In turn, this means that more data professionals need to learn PostgreSQL even when they have experience with other databases. While the documentation around PostgreSQL is detailed and technically rich, finding a simple, clear path to learning what it is, what it does, and how to use it can be challenging. This book seeks to help with that challenge.

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Adding Defaults

I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GO 
What happens when I run these two batches?

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

What is Between?

I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10.

If I run this code, how many rows are returned?

SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7; 

Answer: 4 rows (ids 4, 5, 6, 7)

Explanation: BETWEEN is an inclusive operator, which translates to >= to the lower value and <= to the upper one. Ref: BETWEEN - https://learn.microsoft.com/en-us/sql/t-sql/language-elements/between-transact-sql?view=sql-server-ver17

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2017 - Administration
Modifying the fetch size for Linked Server - Hi, Problem: Pulling several million row table from Oracle DB into SQL server via a Linked Server takes too long: 28M rows and 2GB of data from Oracle to SQL server took 17 hours. (However we are able to scp via OS much faster: we get 3.5MB/s to 8.5MB/s; we transfer 3Gb file in about […]
Alias of a SQL Server - Was hoping to get some help on setting up our SQL Server with an alias.  Currently, we run reports off it and then output the files on a folder structure on the server.  For instance, we run SQL Job "Create Employee Retention Report", and it exports a file to "D:\Reports\Employees\EmployeeRetentionReport.txt", which is a drive on […]
SQL Server 2019 - Administration
Transitioning AlwaysOn Availability Group to Synchronous Commit Mode - Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas operating in asynchronous commit mode. I have received a request to switch to synchronous commit mode, but I am concerned about potential data loss risks. Currently, the database is in "Synchronizing" status. My question is: What will be the status of […]
SQL Server 2019 - Development
Window Functions in a View - Is there a trick to get a where clause filter to push into a view that has window functions that don't include that filter in the window function partition?
SQL Azure - Administration
Azure Database Watcher Monitoring - Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed Instance, using the free tier of Azure Data Explorer. However, I’m currently overwhelmed by the visual data and trying to understand which performance metrics are most critical—particularly regarding Compute. Could someone point me to a comprehensive guide or documentation that explains […]
Editorials
Patching the Patch - Comments posted to this topic are about the item Patching the Patch
Can You Ask for a Raise? - Comments posted to this topic are about the item Can You Ask for a Raise?
What is a Failed Deployment? - Comments posted to this topic are about the item What is a Failed Deployment?
PostgreSQL
How to add metadata for every record in Azure postgres tables - Hi, I have a situation in one of the applications I am working on where prior to going live in production, we are going to migrate data from legacy systems over the period of few weeks. And at the same time, there will be activity from users in this production application. i.e, new records generated […]
Article Discussions by Author
Stored Procedure Generation Script - Comments posted to this topic are about the item Stored Procedure Generation Script
SQL Server 2022 - Administration
One big server with multiple instances, or multiple smaller servers... - We're currently on SQL 2019 and will likely be looking to migrate to a newer version in a year or so (definitely before Extended Support runs out,) and I'm looking to try to save some pennies for the org.  Currently, we host SQL instances for several different orgs and their applications (so multiple, often unrelated, […]
CDC & Azure Managed Instances - Performance degredation - Anyone got any good advice for performance tuning CDC on a Managed Instance? We are seeing around a 30-35% performance degradation (mainly runtime), with CDC enabled in test. Done the usual, put the change tracking tables on its own file and file group, set the capture job to poll every second (to try and keep […]
SQL Server 2022 - Development
OpenQuery with Application Intent specified runs on primary node. - I have an Open query that runs on an Always On server via a linked server and does selects * only. Select * into #Temptable from openquery (linked server) The linked server in its connection properties specifies application intent as ReadOnly, so this query should run on the secondary node but we find that it […]
average duration increasing inline with exec counts - As the title says , I've got a handful of stored procs where the avg duration rises and falls pretty much mirroring the exec count. I've looked to see if there's any blocking chains they're involved in and cant seen anything that would account for the behaviour. Whilst Id obviously expect total duration to do […]
How do I add all the values in the column considering it to be in hh:mm:ss:ms - How do I add all the values in the column considering it to be in hh:mm:ss:ms Please help.  
 

 

RSS FeedTwitter

This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
[email protected]

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -