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

Spread the love

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.

Spread the love
Author: OTi
Meet OTi, the brains behind the popular tech blog "OurTechIdeas.com." OTi is an accomplished author, tech enthusiast, and an expert in SQL Server. With over a decade of experience in the tech industry, he has become a trusted voice in the world of database management. OTi's passion for technology began at a young age, and he has been tinkering with computers ever since. He graduated with a degree in Computer Science and has since worked for some of the biggest tech companies in the world. His experience has given him a deep understanding of how technology works and how it can be used to improve our lives.

Leave a Reply

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