SQL DBA Regular Alerts & Tickets (Service Request and Incident)

Customer Raised Tickets

1) Unable to connect to SQL Server
2) Unable to access a database
3) Unable to identify a table
4) Want to run a script, but need DBA assistance
5) Queries are running slow
6) Queries are failing due to space issues (Logfile full or Data file full)
7) Server is running/responding slow
8) Customers not able to find replicated data in subscribers. Reports are failing.
9) Customer trying to access the table in another instance through Linked Server, but not able to query it.
10)Customer asks for Adhoc restore in another server.

Monitoring Tool/Alerts Raised

1) Space issues (Log File Full, Data File Full) 90% Full
2) Job Failures
3) CPU 100%
4) Memory 100%
5) Blockings
6) Deadlocks
7) Database Crash
8) Corruption (DB, Page)
9) Log Shipping Out of Sync
10) Mirroring Out of Sync
11) Replication Out of Sync
12) Node failures in a cluster.

Facebook Comments Box
Please like or share this post if you found it helpful, thank you.
Share on Facebook
0Tweet about this on Twitter
Share on LinkedIn
Email this to someone
Print this page


Leave a Reply

Your email address will not be published.