| 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 |
