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.
Because Microsoft strongly recommends not touching SharePoint databases so I think you just need to have backup and recovery plan, performance analysis or so on. Idea or Quest are doing so very good. However, IMHO, built-in features over SQL Server Management Studio are pretty enough for SharePoint administrator responsible for handling SharePoint databases. In case you want to manage virtual/physical machine then System Center as Vlad says should help you (if you use Microsoft virtualization technology rather than VMware).
