L2 Deliverables:
Trouble shoot Disk related I/o error or data and log file error if any
Trouble shoot SQL job monitoring issue if any
Session / Process Monitoring
Client Installation (server)
Transaction monitoring during EOD/SOD jobs dependent instance based on the request
Trouble shoot critical dead lock or session issues
Service pack/Patch updates on Cluster server
DBCC CHECKDB or Consistency verification job monitoring
Lock and Deadlock
Service pack/Patch updates on standalone server
Addition of Data or Log file
Addition Secondary file group/stream
Database properties change
Instance properties Change
Full Backup plan configuration using the Maintenance plan
Backup plan configuration using the T-SQL statement.
Rebuild/ Re-organize index configuration using the Maintenance Plan
Rebuild/Re-organize index configuration using the T-SQL statement.
Create logins, users and also provide the appropriate privileges for the same.
Shrinking of Data and log files
Checking DB fragmentation level and re-org index
Taking manual backups based on the request
Database restoration based on the request for supported assets.
Data file and log file movement.
Incident and Request Fulfillment Management
Linked server creation and configuration on SQL Server
DR reconfiguration and setup in case of failure due to incident
Service account change and password reset
TCP / IP port configuration
Named pipe configuration
C2 audit enabling
sp_configuration changes
Database creation
Backup restoration drill
SQL mail or Database mail configuration jobs
Creation of jobs using T-SQL statements based the request from application team
Trouble shoot all jobs and maintenance plan issue
Trouble shoot login/instance connectivity issues
Log Shipping configuration in standby mode.
Log Shipping configuration in no recovery mode
Trouble shoot logshipping Issues
Mirroring Configuration in asynchronous mode
Mirroring Configuration in synchronous mode without automatic failover
Mirroring Configuration in synchronous mode with automatic failover
Trouble shoot Mirroring Issues
Trouble shoot DB cluster Issue
Trouble shoot Linked Server Issue
Change the recovery model.
TempDB movement.
Data file and log file movement.
DR drill activity
Login creation with Sysadmin privileges
Schema Creation
System Performance analysis as per L2 and escalate to L3 in case further analysis is required.
Database performance analysis as per L2 and escalate to L3 in case further analysis is required.
Instance performance analysis as per L2 and escalate to L3 in case further analysis is required.
Identify bad growth projections and Identify space-bound objects
Capture Performance Statistics using performance monitors
Capture Performance Statistics of Instance like IO, Waits, Paging, Buffer Hit Ratio, Full Scans etc.,
Database Objects Creation / Review
Re-cycling of error log
Necessary support for restoration or drill
Preparation of MIS for Major Incidents
Review of daily/weekly/monthly checklist
Repeat Incident / Alert Analysis
Reinstallations raise due to incidents
Incident / Request Fulfillment / Change management
Setup new configuration as per application requirement
Configuration of Master/Slave setup
Configuration of Always on setup
Configuration of Sharding
Configuration installation of database Cluster
DF installation.
Database integration.
Daily reports review.
Troubleshooting.
Application profiling.
Patch management.
Upgrade of the system to the supported version.
Migration of the system to the new machine
Data migration
Cross platform migration
Failover testing.
Periodic HA review and testing.
Closure of audit requirement.
Vendor co-ordination.
Compliance as per policy.
VA/CA point closer
Audit point closer
System book creation and periodic review.
Inventory Management