Related Links
Product Screenshots
|
Features & Benefits Two of SQL-Hero's primary differentiators include: - Performance data warehouse ("Performance daggor")
- Audit - "History of Everything" capability
Performance Data Warehouse Collect performance data related to any of these five sources: - SQL Profiler Events
- SQL Extended Events
- DMV Query-based Events (Sampling)
- Windows Event Log Events
- SQL Job Execution
Built on a plug-in model, you can write additional aggregators or watch for new ones we introduce. (Expect to see log file and IntelliTrace file aggregators coming soon!) This data funnels into a common data warehouse structure which allows you to dynamically generate a SQL Server 2012 Analysis Services (Tabular Model) database that enables construction of reports using tools such as Excel, Power BI, and any other of your favorite data visualization products that speak to SSAS using DAX or MDX. Imagine being able to construct ad hoc reports that let you drill down and drill through to execution detail and see application-level events, along with SQL-based measures, allcorrelated by time. We have demos / videos showing how you can a) install everything you need quickly and easily and b) using just a couple of screens, establish all the settings you need in order to be building rich, meaningful reports in a matter of minutes.
Audit Even if you feel like you've got a good source control solution for your databases, it's important to understand all actual changes applied in thephysical databases, from an audit perspective. This is important to address issues like model drift and understanding who to "blame" for changes made outside of normal process. It's also useful for smaller organizations that prefer to manage their schema strictly in databases as opposed to models, where many developers may even share a common development database. SQL-Hero even allows you to reconstruct a database as of a point in time based on audit logs, making backups for development databases an optional thing. SQL-Hero records 21 types of events related to SQL objects, all made visible in its "History of Everything" reporting.
And More... There's numerousother features that we cover as well including: - Creation of test data (rule-based, meaningful final product, fast)
- SQL editor (many data analysis functions not seen in other products; focus on developer productivity, cutting out time-consuming tasks)
- Data comparison tool (color coding, intelligent scripting: e.g. knowledge of how to handle SEQUENCE's, etc.)
- Unit testing of SQL objects (auto-generate tests as an option, based on configurable rules)
- Tracing client - supports SQL Profiler and Extended Events; with Extended Events, collect using asynchronous file target (proven least impact on traced systems) without having to manage files yourself; advanced analysis tools, perfect for developers who are continually called on to track down problems by capturing workloads
- Monitoring KPI viewer - use your own favorite community DMV queries, color code results based on "good" and "bad"
- Centralized connection management - use aliases to refer to connections throughout the tool instead of connection strings (encrypts connection strings and can tailor actual string based on user's identity)
- Template engine - generate any kind of output format using a wide range of input formats, script using C# or simple mark-up tags
- Automation with SHCommand.exe - take a look at some of our examples
- SSIS components - five components that let you read data from emails, web sources including HTML, and more
- Stay current with frequent updates, received automatically or manually
|
