I would recommend you set up an alert for when log backups are not working. Something that checks when the last log backup was and alerts you if it's more...

The most important thing is the listener. You application's connection string will contain the listener.

The listener will direct the application to the relevant node.

As Gail pointed out, your log should not be growing. Proper sizing and regular log backups are vital.

Have a read through the link she posted.

If you need to monitor disk...

Without some sort of auditing process in place - it's gonna be extremely difficult to get what you want.

You could examine the transaction log with fn_dblog but transaction logs get...

Do you have some sort of auditing enabled on the instance?

Auditing = Auditing, Profiler Trace, XEvents, Triggers

This will alert you when the log usage gets to a certain %, this % amount is up to you.

CREATE procedure sqllogalert ...

What are you looking to capture?

Have you looked at running a server-side trace?

Have you managed to get to the bottom of this?

Are the execution plans different?

GilaMonster (10/29/2013)

---

No, that's describing the write portion of scatter-gather IO, not a read operation.

Why would you expect to see an increase in lazy writes/sec when all you're doing are reads?...

GilaMonster (10/29/2013)

---

No, that's describing the write portion of scatter-gather IO, not a read operation.

Why would you expect to see an increase in lazy writes/sec when all you're doing are reads?...

Thanks Gail

Regarding the free buffer list. I understand that the Lazy Writer is responsible for maintaining a decent amount of free buffers to serve incoming requests. I found the following...

GilaMonster (10/11/2013)

---

No, it's very useful. It's...

So, is it safe to say that measuring checkpoint pages/sec is absolutely useless when investigating memory usage and pressure on my SQL Server.

High lazy writes/sec is the way to...

The Checkpoint process never removes pages from memory. It finds dirty pages, writes the changes to disk and marks the pages as clean. So that means that the page still...

Grant Fritchey (10/5/2013)

---

I would suggest focusing first on wait stats to understand what is causing the server to run slow. But, if you want to know if you're out of...