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.

Hi,

on a failover Cluster, every node got a sql server Installation. If a failover occours  the Cluster Manager will Start the services.

There are patches wich are installed on the passive...

Hi,

are you talking about windows failover cluster, or about always on availibility groups?

These anwsers are for the fail over cluster, not for the aoag.

1)

standard edition is able to create a...