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)
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass