rocky_498 (1/8/2013)
I am dam sure about this ALL SPS/INDEX/VIEW/TRIGG/ and so on are same (Prod/Test)
I am not talking about the *definition* of the queries. To get a deadlock on two different servers, they have to have exactly the same queries *running* at the same time. That means that unless Test has as many connections as the production server does, running exactly the same queries, exactly the same data columns and activity, you won't see the deadlock on Test.
Deadlock require 2 or more queries running simultaneously, not just for the same pieces of code to be sitting in the database.
If i ran Same SP without any changes on Prod giving me Error and On test No Problem.
Because on Test, the procedures that it is deadlocking with are not executing at the same time (which they are on production)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability