In my case, 2019 CU1 has the same behavior as well. No idea what SQL Server is trying to tell me by spitting this information out to error log.

Not sure if those links has complete details you need to achieve this.

Again...I don't see how SQL Server can create underlying DNS records for your listener without WSFC involved. In...

Does the same query take forever if you run it from SSMS locally?

We haven't setup a clusterless Availability groups in our environment, but I don't see how we can have a listener when there is no underlying Failover Cluster involved. As far...

Any specific pattern on what day of the week diff is starting to get bigger? Did you look for any other maintenance jobs you might have running against this DB...

Sorry, but is there a question?

If little to no updates happening on the database, Any chance the Diff backups are getting appended instead of creating separate files?

you had same question almost 8-9 years ago and the discussion had all the answers you need why a diff could become as big as a full backup or even...

Okay, just remove the unwanted column from above script.

Try this, took the above code and added HTML logic, replace with your email and test it....

DECLARE @xml NVARCHAR(MAX)
DECLARE @body NVARCHAR(MAX)
DECLARE @servername SYSNAME = (
SELECT @@SERVERNAME
)
DECLARE @sub...

What if the usual run time of the job(s) is more than an hour? Do you want to know about that as well? I generally look for just the jobs...

This happens when SQL comes online before underlying disk drives become online and made available to be used by OS, hence whatever files SQL is looking for are not available...

If all you need is just listing all the objects and corresponding type in your DB, you could query sys.objects. something like...."select name,type_desc from sys.objects" within your database.

It's little ugly, but how we did this in the past is by creating linked server on all replicas for our listener name IIRC. I don't have the exact steps...

When you are rebuilding a HEAP it also rebuilds all the NC indexes on your heap table as a side effect. You have to keep that in mind and plan...