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.
Ok, I understand, but I would really recommend to have an DBA in your reach. If you plan to work with your consulting firm if you encounter any problems, I would talk to them how they would monitor your enviorment, the more they now about your system the better they can help in an emergency case.
h2h
Thomy
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.
Hi, Vlad
Due to issues with MS licensing and purchases, I don’t know if I will end up with System Center suite, so I was looking at what other options were available if that didn’t pan out. Thanks!
We do have an outside consulting firm working with us on the upgrade/migration. They are providing the technical skills for the set up. I’ve read good things about Idera and Control Point products in terms of governance.
My humble opinion, go get an DBA asap. Without any SQL ressources available you will run into problems regardless of any tools.
what’s your backup/restore plan for example?
