From: Michael MacGregor on
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
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
>


First  |  Prev  | 
Pages: 1 2
Prev: running a job
Next: Sum on Rounded column