The one thing I would start with is gathering performance metrics. Know what is happening on the system. What do the wait stats look like. Do we have queuing somewhere....

You can pull the plan generated out of cache using dynamic management views such as sys.dm_exec_query_stats combined with sys.dm_exec_query_plan. You can also use extended events to capture either estimated or...

The best piece of advice, go and get someone who knows what they're doing. You go past about 2-3tb and the rules change pretty radically. It's not something you can...

Great seeing you guys. SQLBits has some kind of magic perpetual engine, it keeps getting better.

SQLRNNR (7/17/2014)

---

That looks eerily...

It's right there in the post.

Basically, run through the Object Explorer in SSMS. You have the database backup, so that's done. So, Security, logins & roles next. Then Server Objects, usually just linked servers, but...

You don't have to turn on a traceflag any more with SQL Server for deadlocks. The full deadlock graph is available in the system_health extended event session.

Posting the deadlock...

Then you need a way to mark the IP as changed (UpdateDate or something similar) or you have to capture the full data set and then compare it to spot...

Double post. Not sure why. Apologies.

I actually had to support a policy management system at an insurance company and had to deal with latest versions similar to this. Largely you've already got good solutions from...

Deadlocks are usually caused by a combination of poor performance and problematic coding choices. Not being able to see your structures, code or the output of the deadlock graph, all...

murnilim9 (7/16/2014)

---

Jeff Moden (7/16/2014)

---

murnilim9 (7/16/2014)

---

Thanks a lot on your response !

Btw I performed rebuild indexes on certain databases ..maybe around 22 indexes need to be rebuilt and it failed and...

Threadizens!

Make sure we talk if you're Telford this week. The Red Gat Army is travelling up there this afternoon.

Could be that you've enabled Enterprise settings on the databases and that's being detected.

I wouldn't recommend doing an in-place downgrade of this type anyway. May just be my paranoia shining...