Hi,

if you are able to use the sql server 2022, just watch the lifecycle of the products:

sql server 2019:

Mainstream End Date: Feb 28, 2025

Extended End Date: Jan 8, 2030

sql server...

Hi,

and what kind of workload do you use?

OLTP or OLAP?

Check your configuration for parallelism and so on.

There are some nice free tools to check, what kind of problem your server...

Hi,

I work not for RedGate, but we were able to run a POC with the RedGate SQL Monitor. And we testet a lot of monitoring tools.

After a long long time,...

Hi,

maybe this can help you to find a solution:

https://studio3t.com/knowledge-base/articles/export-mongodb-to-sql-database/

Kind regards,

Andreas

Hi,

thanks for your help, it looks pretty good.

Hi,

did you take a look on the execution plan of your query?

Hi,

please learn to post sql code, it is quite diffucult to read.

SELECT @@version
-- it is so simple!

Hi,

just take a look, what is your logfile blocking from "shrinking"

SELECT
    name AS DatabaseName,
    log_reuse_wait_desc AS LogBlocking,
    recovery_model_desc...

Hi,

please post Code as Code should be postet.

It is quiet difficult to read.

USE msdb
GO
DBCC sqlperf (logspace)

This ist just am sample, how code should looks like.

Kind regards,

Andreas

Hi,

if you use a listener, I think you need a DNS server, because the IP from the listener will change to the active node if a failover occurs.

But we do...

Hello,

would you delete the rows in the database, or in the result set?

And, please avoid to post photos, use code instead.

Kind regards,

Andreas

Hi,

maybe you can use the sa user, only to kill your own admin account. After you removed your account, just disable the sa account for a better security.

kind regards,

Andreas

Hi,

we don't know how many rows you've got, but it is better, if you create an index after you put all the data in the table.

If your application will change...

Hi,

just add 1 step in your job, where you can check, if your node is currently the active node.

If so, just execute step nr.2, otherwise, quit the job.

Good luck,

Kind regards,

Andreas

Hi,

it is very diffucult to read the t-sql. Try to put your code in the right form

select @@version

It is very easy.