Annex 1: SQL
| SNo | Work Type | Action/Deliverable |
|---|---|---|
| 1 | Change Request | Backup/Recovery: Create and maintain backups and recovery plans |
| 2 | User Request | Backup/Recovery: Perform full, incremental, or partial backups of databases. |
| 3 | Change Request | Backup/Recovery: Automate the backup and restore process. |
| 4 | User Request | Backup/Recovery: Monitor the backup disk space and archive or delete old backup files. |
| 5 | Incident | MSSQL FCI Cluster: SQL Server cluster troubleshooting |
| 6 | Incident | MSSQL FCI Cluster: Windows cluster troubleshooting |
| 7 | Maintenances | Always On: Prerequisites and planning for new build/migration |
| 8 | Change Request | Always On: Add/remove database |
| 9 | Maintenances | Always On: Performing failover/failback |
| 10 | Incident | Always On: Troubleshooting AOAG issues (Latency/ DB Performance /AOAG offline) |
| 11 | Change Request | Always On: Creation of new AOAG |
| 12 | Change Request | Database Mirroring: Setting up database mirroring |
| 13 | Incident | Database Mirroring: Reconfigure DB mirror |
| 14 | Incident | Database Mirroring: Troubleshooting generic issues with mirroring |
| 15 | Maintenances | Database Mirroring: Performing failover/failback |
| 16 | Incident | Log Shipping: Logshipping setup for fresh databases |
| 17 | Change Request | Log Shipping: Basic troubleshooting of log shipping out of synchronization |
| 18 | Incident | Log Shipping: Troubleshooting of LS job failure |
| 19 | Maintenances | Log Shipping: Logshipping setup for large no of databases |
| 20 | Change Request | Log Shipping: Reverse Logshipping Configuration |
| 21 | Incident | Replication: General troubleshooting |
| 22 | Change Request | Replication: Setting Replication (Transactional) |
| 23 | Change Request | Replication: Setting Replication (Merge) |
| 24 | Change Request | Replication: Setting Replication (Snapshot) |
| 25 | Change Request | Replication: Add remove article from replication |
| 26 | Incident | Replication: Handling replication errors |
| 27 | Change Request | Replication: Adding new subscriber to existing publication |
| 28 | Change Request | Replication: Removing replication |
| 29 | Performance optimization | Performance optimization: Query optimization |
| 30 | Performance optimization | Performance optimization: Instance slowness/tuning |
| 31 | Performance optimization | Performance optimization: Hardware related slowness |
| 32 | Maintenances | Database Encryption (TDE) and Data Encryption: |
| 33 | Change Request | Repotting Services: Configuration and Administration |
| 34 | Change Request | Repotting Services: Security management |
| 35 | User Request | Repotting Services: Review of execution logs |
| 36 | Change Request | Repotting Services: Report deployment |
| 37 | Change Request | Repotting Services: Data source and subscription management |
| 38 | Incident | Repotting Services: Reporting service troubleshooting (Logs and Issues) |
| 39 | Change Request | SSAS(Admin): Security management |
| 40 | User Request | SSAS(Admin): Performance monitoring |
| 41 | Incident | SSAS(Admin): Process monitoring |
| 42 | Change Request | SSAS(Admin): Backup/Restore |
| 43 | Proactive Initiatives | Capacity Planning: Database growth forecast |
| 44 | Proactive Initiatives | Capacity Planning: Storage capacity planning |
| 45 | Proactive Initiatives | Capacity Planning: Memory/CPU usages forecast |
| 46 | User Request | Tools (Extended events, Trace, Perfman, Query Store, Profiler, DTA) |
| 47 | Incident | T-SQL: Basic T-SQL Knowledge for day-to-day support |
| 48 | Change Request | T-SQL: Advance T-SQL work including preparing scripts/ automation |
| 49 | Incident | SSIS troubleshooting: Review SSIS Catalog/Package logs in msdb and troubleshoot |
| 50 | Change Request | SSIS troubleshooting: Deploy SSIS package in catalogue/msdb/file system |
| 51 | Change Request | SSIS troubleshooting: Work on SSDT for package management. |
| 52 | Incident | General troubleshooting: Blocking |
| 53 | Incident | General troubleshooting: Dead Locking |
| 54 | Incident | General troubleshooting: High CPU |
| 55 | Incident | General troubleshooting: High Memory |
| 56 | Incident | General troubleshooting: High IO |
| 57 | Incident | General troubleshooting: Connectivity Issues |
| 58 | Incident | General troubleshooting: Login & Permission Issues |
| 59 | Incident | General troubleshooting: Disk Space related issues |
| 60 | Incident | General troubleshooting: Mount point related issues |
| 61 | Incident | General troubleshooting: Server Not Responding |
| 62 | Incident | General troubleshooting: Down Database - User Database |
| 63 | Incident | General troubleshooting: Down Database - Consistency Issue with User DB |
| 64 | Incident | General troubleshooting: Down Database - System Database |
| 65 | Incident | General troubleshooting: Backup Audit / Backup Job Failure |
| 66 | Incident | General troubleshooting: Agent Job Failure - Customer Jobs |
| 67 | Incident | General troubleshooting: Data and Log file high Usage |
| 68 | Incident | General troubleshooting: TempDB issues |
| 69 | Incident | General troubleshooting: Services Down |
| 70 | Incident | General troubleshooting: Long Running Jobs |
| 71 | Incident | General troubleshooting: Rebuild Master Database |
| 72 | Incident | General troubleshooting: DB mail Issues |
| 73 | Incident | General troubleshooting: Linked Server Issues |
| 74 | Replica/Migrations | Provisioning and managing database instances |
| 75 | Replica/Migrations | Setting up replication and high availability |
| 76 | Change Request | Deploying instance or database level objects |
| 77 | User Request | General Requests: DB Mail |
| 78 | User Request | General Requests: Linked Servers |
| 79 | User Request | General Requests: CDC |
| 80 | User Request | General Requests: DB refresh |
| 81 | User Request | General Requests: Script Execution |
| 82 | User Request | General Requests: Audit Configuration |
| 83 | User Request | General Requests: Table Partition |
| 84 | Change Request | General Requests: Adding or moving datafiles |
| 85 | Change Request | General Requests: Creating and managing user accounts, roles, privileges |
| 86 | User Request | General Requests: Auditing and logging the activities |
Updated about 1 year ago