Reports a break in connection with a mirrored database for more than the nominated period.
Reports on the number of 'kill' commands that have been handled by TSQL.
Queries or updates that take longer than expected to execute.
Reporting that two or more processes are competing for exclusive access to a resource but are unable to obtain it, because some other process is preventing it. The only way out of a deadlock is for one of the processes to be terminated.
Deadlock means that two task trying to lock resource (Table or Row table) that the other task is locking , than SQL decide which task to kill.
Risk - SQL lost of data or response cause application fault.
Reports an average of the waits over the nominated period.
SQL exceptions occur where a query has been executed but cannot complete. Best practice requires that all SQL functions and calls should be properly coded with provision for possible failure via the TRY...CATCH protocol.
Reports log files that have grown to big and could consume all available disk space, leading to a system crash. Log file size is highly dependent on level of activity, on database backup being performed correctly and frequently.
If uncontrolled, log files can consume all available disk space, leading to a system crash. As well, as the log gets larger, the potential for more downtime when recovering from a disaster increases.
Reports a break in connection with a mirrored database for more...
Reports on the number of 'kill' commands that have been handled by...
Symptoms : Server is consuming high levels of CPU capacity...
Reports a shortage of memory to satisfy all program needs. Steady...