SentryOne Tools for Productivity & Performance
Published On: November 14, 2019
Categories: SQL Server, SentryOne 0
Active SQL Server monitoring is invaluable to enable the operational DBA to identify and address issues quickly. SentryOne software solutions help data professionals do just that. But did you know that SentryOne offers capabilities beyond just monitoring?
I recently led a webinar, Tools for Productivity & Performance, that showcased how SentryOne provides you with visibility into your entire data estate and aids in managing cross-server activities. I demonstrated how SentryOne delivers both operational and business value to address your application challenges, whether they are performance-related or usability problems.
During the webinar, I covered the following:
- How to manage your back-up jobs using SQL Server
- How to identify and troubleshoot what may be slowing down your overnight processing
- How alerting can be tuned to be effective
If you missed the webinar, you can view the recording here.
During the webinar, I received several great questions from attendees. I’ve answered them below in case they are helpful to you.
Q: Are the jobs in the Event Chains set up without a schedule (in SQL Server itself)?
A: The jobs that you set up in Event Chains do not need to be scheduled on their own. Only the very first job in the chain should be scheduled. SentryOne will watch for that job’s completion and kick off the rest of the jobs in the chain automatically, as the chain specifies.
Q: What permissions are required at the VM host level?
A: For VMware, you will need read-only access to the vCenter. More information about this can be found here.
Q: Do I need to install an agent on SQL Server to run SentryOne?
A: SentryOne monitoring is agentless. Our monitoring is accomplished remotely from a separate server, which reduces the amount of overhead you’ll see on your targets. More information about this can be found here.
Schedule a SentryOne Demo
Interested in learning more about how SentryOne can address your needs? Schedule a one-on-one demo with a SentryOne Solution Engineer or join us for one of our upcoming public demos.
Alec is a Solutions Engineer at SentryOne. He's been with the company for 4 years and started with the support team, focused on onboarding new customers to the solution. Eventually he moved to his new team where he loves helping DBAs find new ways to troubleshoot and diagnose problems with SQL Server, using SentryOne.