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 11 days ago