Tuesday, November 25, 2014
SQL daily HealthCheck - My Reference
SQL daily Healthcheck
CPU - System CPU, SQL CPU, max CPU, avg CPU
SQL Log Size > 40%? -dbcc sqlperf(LOGSPACE)
SQL Connection - How many connection
SQL Active Connection
Blocking ? any blocking, what is the blocking header?
Deadlock? any deadlock?
Long Run Queries?
Any SQL Job fail?
Last IO Error?
SQL Error log that need attention
DB Size
Disk size
SQL 2005 - mirroring status
SQL 2012/SQL 2014/SQL 2016 : AGL Status
Subscribe to:
Posts (Atom)