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.
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
> 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