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

468 views 11:27 0 Comments 7 October 2017
Ticketing tools

Customer Raised Tickets

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

Monitoring Tool/Alerts Raised

  • Space issues (Log File Full, Data File Full) 90% Full
  • Job Failures
  • CPU 100%
  • Memory 100%
  • Blockings
  • Deadlocks
  • Database Crash
  • Corruption (DB, Page)
  • Log Shipping Out of Sync
  • Mirroring Out of Sync
  • Replication Out of Sync
  • Node failures in a cluster.
Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *