Prev: running a job
Next: Sum on Rounded column
From: Michael MacGregor on 29 Jun 2010 18:49 Sometimes you have no choice but to do it on production because the load is not sufficient to produce the same issues on a dev or QA env. MTM
From: Simon Whale on 30 Jun 2010 04:53
Thanks for all your suggestions and comments that has given me some great reading to do :) "Simon Whale" <simon(a)nospam.com> wrote in message news:eK9YxrvFLHA.588(a)TK2MSFTNGP06.phx.gbl... > Hi, > > i have at the moment in SQL 2005 a period of time when processes lock and > slow down a back office system, but when reported they seem to disappear. > > What i am asking is that from the logs in SQL Server can i trace period > where deadlocks or wait requests happen? > > any links would great :) > > Many thanks > Simon > |