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