Key lookup is bad, instead you can avoid this by using a covering index by including all those referred columns in the index itself.

--

SQLBuddy

When you say "cross data center automatic failover" are you refering to failing over whole instance\bunch of databases\a single DB ?

--

SQLBuddy

You can't find it that way. Either you need to use Blocked Process report in profiler or use extended events as Grant mentioned.

--

SQLBuddy

Chek it using the script1. You need to find if any of the DB_Owner login is no longer...

Yeah you can do that either way. In MP you need to select the server name 2.

--

SQLBuddy

What's the purpose of this actually ? Is it for HA or DR or something else ..

--

SQLBuddy

Did you check the SQL Server Error Logs and Windows Event logs for any messages during the SQL Server failure ?

--

SQLBuddy

Try this ..

This error may occur is the DB_Owner associated with a DB no longer valid. First find such DB and then change it to 'sa'.

SELECT d.name AS 'DB_Name',...

Run this and see if you can find the source of that backup

SELECT bs.database_name AS DB_Name

...

Don't you have a Migration window during which you do the cut-over ? Usually you should pick up a window when none of the jobs \ user processes are running....

Do you anticipate this...

You are welcome, Oracle_91. Sounds good to me 🙂

--

SQLBuddy

Is it possible to run index reorg & update stats on nightly basis and rebuilds during the weekend ?...

john_c_deprato (4/3/2014)

---

We didn't see any patches that would be related to this problem. There aren't any error log or windows event logs that indicate there is something causing the IOPS...

Oracle_91 (4/3/2014)

---

Yeah. I mean normal disk as DAS.

Thanks for pointing out of SQLIO tool.

Is there anyway I can import results of sqlio and load it into sql server table...