About This Gig
<<=You will get =>>
#Fix Performance issues :
--------------------------
> Server/Database Level Configuration
> Implement best practices for server like, tempdb file location, guest account, configuring high availability, always on etc
> Optimizing the slowest queries that consume more CPU, memory or disk I/o
#Indexes:
-----------
> Implement missing indexes
> Remove duplicate/unused indexes
> Automatic Rebuild\Reorganize database indexes
# Backup Plan:
-----------------
>Schedule backup (Full, Differential, Transaction Log)
> Restore of latest backup on staging or DR server or test or UAT server
# DB Mirroring:
#Miscellaneous:
------------------
>Weekly DB audit report: Provide information on changes made on stored procedure, functions, tables, views and other database objects.
>DB Users configurations
>Adding linked servers/odbc drivers etc
>Server migration
>Database Migration