DBAs have feelings!
Computers don’t have feelings, but humans that operate them do. Sometimes we pretend as if we don’t have feelings, but…
SQL BATCH REQUEST
Symptoms: Slow SQL responses when a mirrored database is experiencing connection speed problems. Impact: Medium Expected behavior : There is…
AVAILABLE MEMORY % BELOW THRESHOLD
Symptoms: Slow SQL responses coming from fall in available RAM. Available memory (percentage of total) is below the threshold. Impact:…
QUERIES BLOCKED
Symptoms: Users report that some process has stopped or timed-out. Impact: Medium This alert means that some unidentified query has…
INTERNET PACKET LOSS
Lost packets alert indicates that communications with the internet either get no response or only get a partial response. As…
MONITORING SQL DATA GROWTH
Symptoms: Total database size increased and is now larger than the designated threshold. Impact: Medium Rapid increase in database size…
HOST: NETWORK UTILIZATION
Symptoms: Network utilization levels are above threshold Impact: Medium Slow SQL responses will degrade the user experience, resulting in poor…
SQL: BUFFER CACHE HIT RATIO
Symptoms: No longer caching data pages in memory, reads from disk are higher, possible memory bottleneck – SQL is running…
HOST: MEMORY FREE
Symptoms: Free memory is low – all host functions are running slower than normal. Impact: High The source may be…
HOST: MEASURING NETWORK JITTER
Symptoms: Network failing. User responses are slow, and some data may be lost. Impact: Medium Slow SQL responses will degrade…
