---
updatedAt: 2025-11-19T14:07:38.000Z
agentTools:
  projectIndex: https://docs.rackspace.com/llms.txt
---

# Annex 1: SQL

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