GilaMonster (7/29/2008)

---

As far as I can tell from the deadlock graph, both parts of the deadlock are selects that are taking IX or SIX locks. If I've misinterpreted the deadlock...

They are listed in the attached doc on the original post. Both...

http://support.microsoft.com/kb/246133

In a month's time, it's deadlocked about 6 times total ... so not to bad.

I don't see any triggers at all in this database and there are only a few...

Unfortunately this is a third party vendor application and as of now I do not know much of anything to as how it works. This just happened and I'm just...

Hate to bump, but hoping to catch the right people at the right time ...

Thanks

Any help would be much appreciated.

Profiler has the ability to do a replay.

Another good tool can be found here.

Christopher Favero (7/7/2008)

---

cant easily do snapshots or copies as the data size of some of ourt dbs are over 300GB. with 1000's of Id's we would need 3 or...

Christopher Favero (7/7/2008)

---

I have the director of QA asking for this "golden copy" of data that they wish to test against and then revert back after testing.

is this a...

Nice! Thank you.

Shameless bump ... I tried a pivot, didn't get what I was looking for.

Is what I'm attempting to do possible?

Thanks all

Great point ... That is the path that I would want to take as well, but obviously not always the easiest of tasks.

I've heard that some software out there...

Shameless bump ...

Here is an example ...

DECLARE @ServerNames TABLE

(

[ServerName]VARCHAR(50)

,[Environment]VARCHAR(50)

)

INSERT INTO @ServerNames ([ServerName],[Environment]) VALUES ('ProdServer1','PROD')

INSERT INTO @ServerNames ([ServerName],[Environment]) VALUES ('ProdServer21','PROD')

INSERT INTO @ServerNames ([ServerName],[Environment]) VALUES ('ProdServer3','PROD')

INSERT INTO @ServerNames ([ServerName],[Environment]) VALUES ('ProdServer4','PROD')

INSERT INTO @ServerNames ([ServerName],[Environment])...