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.
As I said before, you just need a DBA to set up everything. DB backup can be scheduled and once done you do not need to worry about it. Also, sort out what is your DR/HA strategy. If you are have having DR options, then they need to do mirroring and log shipping etc. You might just need a sys admin later on to monitor resource usage of SQL environments. Hope you are not sharing you SQL Instance with any other application if this not the case then “It depends”. If they expect one person to do all the stuff, then with all due respect “Good Luck” 🙂
