Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Software to monitor SQL Server..

    The best thing to is run profiler (ensure it writes the data to disk and that there is sufficent disk space)

    Under Event ensure the following are recorded

    Locks: Deadlock

    Locks: DeadlockChain

    Storedprocedues:RPC:Completed

    TSQL:SQL:BatchCompleted

    Under filters...

Viewing post 1 (of 1 total)