Archive

Monthly Archives: January 2012

The biggest challenge to implementing a standardized maintenance plans in a wide-spread environment is finding where the SQL Server instances reside.  The proliferation of SQL Server instances is a side effect the virtual environment.  Super easy to just spin up a new server.  Servers are created and SQL server is installed.  The install is usually guided by the software vendor or a well-intentioned department professional.  Maintenance does not get the consideration required.

Now a full-time DBA is on site and ready to wrangle all the servers into a stream lined configuration with a very secure and desirable assortment.  Guided by Ola Hallengren http://ola.hallengren.com/   These servers will be maintained.  No more log bloat, recovery ability meeting the SLA, and peak performance on the indexes.  Good times ahead!

Advertisements