|
What is the best way of automating DBA tasks like backups, space, jobs, errors on windows and sql? we have 200+ servers and there is no 3rd party monitoring tool. I'm thinking about using SSIS but I am not sure where to start. Any guidance on where to start? Thanks.
(comments are locked)
|
|
Funny you should ask - that was last month's T-SQL Tuesday topic. You should be able to get quite a bit of insight from reading the various topics available on the summary page.
(comments are locked)
|
|
In the past, I've taken the system built by David Bird in his series of articles on the main SQL Server Central website, and used this to monitor the basic health of the servers, including job failures. In terms of automating scheduled tasks for routine maintenance, then I would look at using something quicker to roll out than the normal SQL Server maintenance tools. I would suggest you investigate Ola Hallengren's set of SQL Server maintenance scripts (SQL2005 and up).
(comments are locked)
|
