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.
I would say, SharePoint does take of DB stuff pretty much, but we need DBA skill for initial set up like DB names, tempDB, auto-growth, logs and backup. But apart from that you can use SCOM to monitor system health, login to SQL server management studio to see DB settings and size. I think Idera and Control Point from Axceler serves this purpose with more Governance options.Â
PS: I have just seen demos of the products and not tried them.
