Menu:

Data Management Solutions

We glad to offer our ussual arrangements for support SQL Server- generaly, monthly and daily

Initial arrangements

  • Automate all possible jobs and maintenance plans on the server for things like database backups, integrity checks, automatic shrinking, transaction log backups, etc.
  • Install SQL Mail on all your production servers for getting notifications on email.
  • Through SQL Mail, we set up email notifications for all the jobs and maintenance plans on the production server - for every database. Also we set up email notifications to be notified in case of a severity alert - like file growing large and thus reducing disk space, etc.
  • Set the MSSQL and SQL Server Agent services to Auto-start when the server starts.
  • Create initial list of servers, databases, users,logins/passwords, etc and store it in secure place

Monthly arrangements

  • Backup Verification - Verify backups on a regular basis
  • Review changes in list of servers, databases, users,logins/passwords, etc
  • Create a prognos for increasing filesize of databases, execution time of query and another factors witch affects to database avability and performance
  • Windows, SQL Server or Application Updates - Check for service packs/patches that need to be installed on SQL Server from either a hardware, OS, DBMS or application perspective
  • Fragmentation - Review the fragmentation for your databases to determine if you particular indexes must be rebuilt based on analysis from a backup SQL Server.
  • Security - Remove unneeded logins and users for individuals that have left the organization, had a change in position, etc.
  • Shrink databases - If databases or transaction logs are larger, than necessary shrink those files to free up disk space.

Daily arrangements

  • Check the connectivity of each server over the network.
  • Check whether the services are running.
  • Check whether the scheduled tasks on the production servers are running normally.
  • Check the hard disk space available on the SQL Servers.
  • Check all the database and transaction log space on each server.
  • Check Windows event Logs for any error messages.
  • Check SQL Error Logs for any errors occurring within SQL Server.