srawant (6/22/2010)

---

Am I understanding differently or is it the fact that to have a view on the missing indexes we gotta run the query first ? If so would it...

lmu92 (6/16/2010)

---

We're using XML files only for getting data from a DB2 into SQL Server through a (required) 3rd party middleware.

The reason we're using XML is to be flexible in...

Grant Fritchey (6/15/2010)

---

Yes, it's absolutely possible that you're seeing contention. That much contention though would be a bit concerning. What is running on the systems that could block a shared...

Both servers are in...

Robert Davis (6/11/2010)

---

That's not an error message. Every time you create a snapshot, it has to run crash recovery on the snapshot because it may have transactions in progress when...

Robert Davis (6/10/2010)

---

Your timeout value should NOT be getting reset when the mirror fails over. What is your SQL version/build #?

You can change the timeout value in any mode, but...

One more question: can the default mirroring timeout be modified even when in High-Performance (Async) mode?

On BOL it is stated that it can only be changed from the 10-sec default...

Brandie Tarvin (6/9/2010)

---

Thank you,...

Brandie Tarvin (4/29/2010)

---

dallas13 (4/29/2010)

---

I was able to see the improvements after this. It worked for me.

But every time after failover this value again gets set to 10 sec

so you need...

ALZDBA (6/7/2010)

---

We've has some connection losses to, but the mirroring (primary-mirror-witness) resumed as soon as the connection could be reactivated between principal and mirror.

It caught up very well (sql2005 std)

I...

GilaMonster (6/4/2010)

---

Interesting.

What I suggest is that you go through all of the attributes in sys.dm_exec_plan_attributes, one of the columns in there is 'is_cache_key'. If any attributes with that column =...

Sure, pls give me some time to get you the info, much appreciated.

GilaMonster (6/4/2010)

---

What does this return? Should be safe to post, there's no info on the query or plan anywhere in there.

SELECT cp.plan_handle, cp.cacheobjtype, cp.refcounts, cp.usecounts,

pa.attribute, pa.value

FROM sys.dm_exec_cached_plans cp

CROSS APPLY...

Cacheobjtype for all plans is "Compiled Plan".

GilaMonster (6/4/2010)

---

Are all 12 plan handles different?

Could you perhaps attach the results as an excel sheet? Without seeing results, hard to tell you why there are multiple rows. Can you...