1. Getting Started Installation and Setup Steps There are three basic steps to installation and setup. 1. Install SQL Sentry 2. Complete the
You can also highlight any time slice within any chart, and the dashboard will synchronize all charts and enable you to zoom into a time slice, or jum
7. Disk Activity, Latency and Capacity SQL Sentry Performance Advisor provides a revolutionary, patented graphical view of your server's disk top
8. Top SQL In the Top SQL view, you can see details about any live or historical long running and/or high impact statements. You can see the specific
9. Index Analysis If you have Fragmentation Manager, then you will have access to advanced tools to help manage your index fragmentation. You have the
The other way to view your indexes is the Tree View. The Tree View is the same as the Index Grid View except that it’s organized by databases on the m
10. AlwaysOn Monitoring and Management In the AlwaysOn tab, you have access to information that you will need about your AlwaysOn environment. The tab
Another layout is the Groups/Replicas layout, which shows the performance, health, and configuration of each Availability Group. In the AlwaysOn
11. Query Plan Analysis The Query Plan tab come with integrated Plan Explorer functionality to give you dramatically enhanced visibility into SQL exec
12. Block and Deadlock Analysis Blocks SQL Sentry Performance Advisor's hierarchical display of all blocking chains provides the most complete pi
Deadlocks Unlike other deadlock graphing tools, deadlock nodes in Performance Advisor contain the concise information you need to quickly visualize th
2. Client Start Page Using Performance Advisor and/or Event Manager SQL Servers and Analysis Services can be watched with either Event Manager or Perf
13. Quick Trace® Quick Trace provides a complete picture of exactly which processes are doing work on the server by automatically correlating trace an
Quick Trace can also be automated in response to many different conditions such as "Blocking SQL", so if a problem occurs after hours you&ap
14. Visual Schedule Management No more trying to use "Next Run Date" to guess a server's job schedule! Unprecedented Visibility and Con
Custom Event Views You can quickly group common events or servers in a single calendar view. Custom Event Views allow you to easily group jobs, server
15. Alerting and Response System Do you currently go through the time consuming activity of configuring each server and each job to establish a basic
16. Schedule Performance Monitoring Have you ever been burned by a "hung" job that never failed, but chewed up valuable resources and caused
17. Graphical Reporting You believe your database environment is running slower than normal but how do you present the details to management? SQL Sent
18. SSIS and DTS Support Tired of the scavenger hunt required to track down all the details you need to resolve an issue with your DTS packages and SQ
19. Chaining and Queuing Did you ever wish you could find just a few more hours in your maintenance window, or need to have jobs run in a particular s
20. Cross-Platform Support Wouldn't it be nice to see your entire enterprise in one global view? Event Manager seamlessly integrates external eve
Contacts Node You can create users and groups to monitor the activity on different connections and be alerted for on any condition that you set. To cr
21. Performance Advisor and Event Manager Integration Performance Advisor integrates with Event Manager through a single client to provide functionali
Double click on the event to jump directly into an in-depth analysis within the corresponding Performance Advisor view. You can also generate email an
3. Performance Advisor for SQL Server Performance Advisor for SQL Server shows the most important Windows and SQL Server performance metrics side-by-s
Network Utilization Network utilization is displayed by SQL Server instance and by network adapter. Disk Latency Disk latency charts show you exactly
4. Performance Advisor for Analysis Services SQL Sentry Performance Advisor for Analysis Services shows the most important Windows and Analysis Servic
High Impact SSAS Command Analysis Performance Advisor for Analysis Services captures and aggregates all high impact SSAS commands (MDX, DMX and XMLA),
5. Performance Advisor for Windows Performance Advisor for Windows takes process and service performance monitoring to a new level. It auto-correlates
6. Real-Time and Historical Performance Analysis Easily switch between real-time and historical modes to view performance metrics for any point in tim
Kommentare zu diesen Handbüchern