Great that you found the trick - it works with my SQL Server 2014 🙂

Best Regards,

Volker Bachmann

Same for me on one of the linked servers. The other one works fine...

I've created a Planned Task with a sqlcmd Command for the health report on the server itself.

Regards,

Volker

Hello,

would it be a good idea to create an automatic purging job for the history tables - maybe with configurable days to keep the data?

BTW: I've created Jobs for SQL...

Hi Michael,

first of all a big thanks for the update.

It's exactly what I thought of - especial the health report!

Since the beginning I have an error that's coming up only...

In my environment the Job "LongRunningQueriesAlert" fails often.

I think it's something with the original SQL Text that is inserted in the Table QueryHistory at the beginning of "usp_LongRunningQueries".

Maybe we...

for the quick Report:

- databases without backup in the last day

- errors from the sql server log (no warnings and dbcc checkdb without Errors...)

- Connections, Buffer Hit Cache Ratio...

(once again in the right forum)

Hi,

first of all a big "Thank You" for this script!

This is exactly what I'm seraching for.

On the first two server the Reports work fine but...