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 have used multiple products fom Idera. Awesome tools. Even the free ones are extreemely useful..
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).
System Center tends to do entirely infrastructure management rather than specifies to SQL Server database management system.
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” 🙂
Idera’s SQL diagnostic manager is one of the better tools I’e worked with and it covers alot when visability and reporting is essential. But by no means is this enough to hedge against failures and outages where core SQL DBA knowledge is essential.
Most people will tell you a SharePoint Admin’s best tool for supporting SQL is a SQL DBA. However, if you can’t get a DBA on staff, start training yourself to be one. So if your already plaiining on heading in that direction, awsome.
70-462
