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   These servers will be maintained.  No more log bloat, recovery ability meeting the SLA, and peak performance on the indexes.  Good times ahead!