Performance Assessment

Get expert help with specific SQL Server performance problems

 

Pro Services Home

SentryOne Performance Assessment gives fast relief for performance headaches
 
Is your team struggling to resolve SQL Server performance issues? Need help removing database performance blockers that are slowing your company's momentum?
 
A SentryOne Performance Assessment leverages the unique SentryOne and SQL Server expertise of our consultants to identify the root cause of SQL Server performance issues. If you're not currently using SentryOne tools, we install and configure the required SentryOne software needed to diagnose and document performance issues in your SQL Server environment.

What we do:

  • Utilize the power of SentryOne to:
    • Analyze server performance using metrics-based methods
    • Use the SentryOne client dashboard to identify resource bottlenecks
    • Correlate dashboard performance metrics to specific workload-generated events
    • Compare peak resource utilization periods to established baselines
    • Use Plan Explorer to analyze execution plans of resource-intensive queries
  • Identify your most pressing SQL Server performance issues, such as:
    • SQL Server configuration optimization
    • Current and potential resource bottlenecks and contention
    • Database design-related issues
    • Index usage and effectiveness
    • Index and statistics maintenance
    • Blocking and Deadlocks
    • Poorly performing queries
  • Develop a SQL Server performance improvement program
  • Document the entire effort and conduct a personal review of our findings and recommendations

 

Pro Services Inquiry

Have questions about Performance Assessment?

Check out our FAQs below, or submit the form above for immediate answers. 

Q: How many hours of consultation does the Performance Assessment session provide?

A: SentryOne Performance Assessment is not based on a specific estimated number of hours: We follow a defined methodology for providing an assessment of your database environment, along with suggestions for performance improvement. SentryOne Custom Consultation sessions are available to accommodate more complicated scenarios. Just ask your SentryOne Pro Services for a session tailored to your needs. 

Q: I need help with general SQL Server database management. Can SentryOne Pro Services help?

A: SentryOne has partnerships with industry-leading consulting companies who can provide expert database management services and training. Submit the form above for more information.