I suspect this is due to memory pressure, but I find it hard to relate to db mirroring.

Have you checked your memory usage stats?

You're welcome.

Glad I could help.

Little Nick (10/7/2010)

---

Gianluca Sartori (10/7/2010)

---

I forgot to mention that if you are experiencing high disk queue, a new monster server connected to the same storage will run as slow as...

This could be a template for your trigger:

-- =============================================

-- Author:Gianluca Sartori

-- Create date: 10/07/2010

-- Description:Catches SQL DML statements and logs

-- ...

Try this:

IF (EXISTS ( SELECT 1

FROM LINKED_SERVER_NAME.REMOTE_DATABASE_NAME.INFORMATION_SCHEMA.TABLES

...

What do you mean "accessing a table"?

There's no trigger for select, you would have to catch the event with a different strategy (trace or whatever).

If you want to log...

hahnorlaska (10/6/2010)

---

Side note: adding the "LagsDetailId > 91879813" to the outer query dramatically slowed the query. This was counterintuitive for me as there are lots of records that otherwise...

I forgot to mention that if you are experiencing high disk queue, a new monster server connected to the same storage will run as slow as your current server.

What...

If performance decreased suddenly, I would investigate what changed before thinking of an hardware update.

Do you have a performance baseline to compare your current activity with?

Did the transactions per seconds...

I was sure it would have been Alvin!

Thank you Steve and everybody. This is a great site and an extraordinary community of people.

Keep up the great job.

Steve Jones - Editor (10/4/2010)

---

Gianluca Sartori (10/4/2010)

---

Dave Ballantyne (10/3/2010)

---

Thats sqlbits all over with now , great conference. My talk seemed to go pretty well, room full of blank...

Dave Ballantyne (10/3/2010)

---

Thats sqlbits all over with now , great conference. My talk seemed to go pretty well, room full of blank faces when i asked "who uses...

Alvin Ramard (10/1/2010)

---

Ray K (10/1/2010)

---

Gianluca Sartori (10/1/2010)

---

Yes, me too. I'm too busy to post. This f*** work is always in...

Yes, me too. I'm too busy to post. This f*** work is always in the way. 😀

No, seriously, no trouble...

Jack Corbett (9/30/2010)

---

Gianluca Sartori (9/30/2010)

---

Totally different topic: how big was the biggest SQL statement you had to deal with?

This is a statement generated by our BI front-end.

Surprisingly enough, after 4...