I have tried using the EPM but the documentation failed me.

When I start Powershell through SQL server and modify the command with my parameters and paste it in to Powershell...

We were able to add an index that allows the following statement to execute within a reasonable time. However what I don't get is each time I run it,...

I will try making a new table and copying in the events I want to keep as plan b. We just built a new index which hopefully will help....

Thank you. I would prefer not to use temp tables. I have to figure out why it's so slow compared to staging, once I do that I will...

Thanks everyone. All good tips. I was incorrect about the indexes. I'm not sure but I must have been looking at the wrong table or server because...

Yes the EventDate keeps increasing, as in new entries are added with the most recent dates. As I said there is no unique index, there is only that index...

There can be minimal down time. This table is used to log application events, so it doesn't really effect end users but there are sql jobs that load this...

I haven't, I will take a look.

I am querying for a count right now, but it will take a long time. I estimate half, so 250 Million...

Posted too soon, sorry. Figured it out.

Good tips thank you all. My first attempt to install the cluster and then the sql cluster did not go flawlessly but mainly due to that fact I am...

Thank you. Since the incident I have lowered the max memory threshold in SQL and so far it's been working better. I also upped the threshold cost for...

Do you use LogicMonitor to monitor SQL Server?

Do you monitor lock timeouts and does it often go above the default threshold of 1? I am asking because we often...

This is great and so close to what I'm looking for. However we do have several databases that consist of several ndf files, this only shows me the main...

Thanks 🙂

This somewhat relates to the no history issue. I see a few jobs that only have a few rows of history, they are only failures and nothing recent. ...