Hi all,
Have a question for the technical folks here. What tools do you recommend for helping a SharePoint Administrator manage the SQL server (we have no SQL DBA, so I get to handle SQL as well). I’ve looked at Idera tools, but would like to know what other people use for analyzing, monitoring, alerting of possible issues and what recommendations you may have.
We’re currently running SQL Server 2005, but will be going to SQL 2012 with our SP 2013 implementation.
Thanks in advance for your input.
While I would love to have a DBA on staff, it is not an option I have.
We have an outside consulting firm assisting with our upgrade/migration, and they will be a resource for any issues we experience (we have used them before for backup issues with our existing implementation).
Part of the budget plan for this coming fiscal year (starting in July) is for me to receive SQL administration training.
Thanks for your input, Thomy.