Database Management Solutions
Database Solutions for Every DBA
Monitoring & Performance
Security & Compliance
SQL Diagnostic Manager
Achieve 24/7 SQL Monitoring
- Performance monitoring for physical and virtual environments
- Query plan monitoring to see the causes of blocks and deadlocks
- Integrated SQL Doctor expert recommendations
- Easy integration with Microsoft SCOM
- Predictive alerting with settings to avoid false alerts
- Web-based dashboard with at-a-glance views of top issues and alerts
IDERA SQL Diagnostic Manager provides an unprecedented level of diagnostic information on the health, performance, and status of SQL Server instances across your environment. You can view, diagnose, and report on critical performance statistics from a central point of control.
Using a unique agent-less architecture, SQL Diagnostic Manager gathers diagnostic information in real time, keeping database administrators and managers informed by providing customised alerts. Easy to install and use, SQL Diagnostic Manager is an indispensable SQL Server management tool that benefits both experienced and junior database administrators.
Physical and Virtual Performance Monitoring
Easily monitor and view the performance of both physical server and VMware or Hyper-V virtual server environments to get a complete view of SQL Server databases. View performance metrics and alerts for virtual machines and their related hosts including CPU, memory, disk usage, network etc. to get a complete performance picture of the SQL server environment.
Query Performance Monitoring
Identify and monitor inefficient and poor performing SQL queries, batches, statements and stored procedures causing blocks and deadlocks, such as long or most frequent queries or queries consuming unusually high CPU or I/O. Thresholds can be configured on each individual server allowing for greater flexibility, and the interface makes it very easy to see the most costly queries by looking at individual query executions or query signatures.
*New* Integrated SQL Doctor Expert Recommendations
Expert recommendations from IDERA SQL Doctor are now integrated into SQL Diagnostic Manager. Enhance performance and speed up problem resolutions with built-in tuning advice and best practices developed by SQL Server MVPs. These updated recommendations are integrated into analysis workflows and provide specific guidance to address problem issues including automatic corrective scripts and links to related online content to supercharge your SQL Server performance.
Complete SQL Performance Tuning
- New and enhanced Expert Recommendations to help improve performance
- Dashboard exposes performance metrics in real-time
- "Quick Findings" instantly locates SQL performance issues
- Executable scripts are generated to optimise performance
- Stored history of analysis recommendations for trending
IDERA SQL Doctor is your one-stop source for identifying and resolving SQL Server performance problems. SQL Doctor includes a robust, yet light-weight analysis engine that not only checks your SQL Server configuration for potential problems and the health of your databases. At the end of the analysis detailed, specific recommendations are provided that will improve your SQL Server performance.
See Detailed Performance Metrics
Analyse the performance of SQL Server databases and receive tuning recommendations for resolving them in minutes as opposed to hours. SQL Doctor targets some of the most common areas of SQL Server performance problems, such as queries, server configuration, security, database objects, memory, wait statistics, query plans, and much more.
Locate Issues via "Quick Findings"
SQL Doctor Instantly highlights where performance threatening issues are occurring, displaying metrics in real-time for processes, network interface cards, processor, processor cache, memory, disk, and system information.
Enhanced Expert Recommendations
Leverage the latest proven industry best practices endorsed by SQL Server MVPs to analyse the performance of SQL Server. Get expert recommendations including index usage, query syntax enhancements and configuration changes with a patented ranking system that shows the highest performance improvement options first. Expert recommendations have been developed against, and SQL Doctor has been tested to work with, pre-release copies of SQL Server 2016.
Security & Compliance
SQL Compliance Manager
Improve Any SQL Server Audit
- Audit Sensitive Data - see who did what, when, where, and how
- Track and Detect - monitor and alert on suspicious activity
- Satisfy Audits - for PCI, HIPAA, FERPA and SOX requirements
- Generate Reports - 25 built-in reports to validate SQL Server audit trails
- Minimise Overhead - light data collection agent minimises server impact
Audit sensitive data
Comply with regulatory standards by auditing the most sensitive data contained in your databases, right down to the column level. Determine where sensitive data resides and add this data and columns to the audit wizard.
Stop potential threats
Track access and changes to databases, alert on failed log-ins, and customise alerts to notify of activities that could cause harm to your SQL Server environment.
Pass audits with ease
Templates for PCI, SOX, HIPAA, and FERPA help you meet compliance requirements, A simple wizard helps add these compliance regulations to your audited SQL Server objects with preset auditing settings aligned to over 16 regulatory citations.
Choose from over 25 pre-defined compliance reports, developed in partnership with auditing experts, that address security auditing & compliance reporting requirements. The Microsoft Reporting Services reports are available in the Console or can be easily deployed to SQL Reporting Services and customised if needed.
Keeping an eye on SQL servers shouldn't bring down your SQL enterprise. Using SQL Compliance Manager maintains a watchful eye on SQL servers without performance impact implications.
Take Full Control of SQL Permissions
- Identify existing vulnerabilities in your SQL Servers
- Harden security policies across SQL Servers
- Rank security levels with the security report card
- Analyse and report user permissions across SQL Servers
- Customisable templates for PCI, HIPAA and more
Understand who has access to what and identify each user's effective rights across all SQL Server objects. Drill down by user or group to shed light on areas where security vulnerabilities may exist or have a chance of developing. Use the report catalog to track vulnerabilities, security changes, and user entitlement over time.
Set Strong Security Policies
View a complete history of SQL Server security settings and designate a baseline to compare against future changes, providing a valuable audit trail for forensic analysis.
Prevent Security Violations
SQL secure provides an Idera defined Level 2 security check for balanced intrusion protection that leverages MSBPA and CIS guidelines, and more. The security report card identifies top security vulnerabilities on your servers. Each security check is categorised as High, Medium, or Low Risk. You can drill into each security check to get more detail.
Analyse User Permissions
Analyse membership to powerful server roles and groups such as administrators, systems administrators, and security administrators to ensure the level of access is warranted. From a group, see the list of group members and select a member for further analysis. From a user, see the group memberships and drill upwards to view inherited permissions.
|For more information please contact
the MicroWay sales team:
MicroWay Pty Ltd
PO Box 84,
Braeside, Victoria, 3195, Australia
Ph: 1300 553 313
Fax: 1300 132 709
ABN: 56 129 024 825
|Sydney Sales Office
MicroWay Pty Ltd
PO Box 1733,
Crows Nest, NSW 1585, Australia
Tel: 1300 553 313
Fax: 1300 132 709
ABN: 56 129 024 825
|New Zealand Sales Office
MicroWay Pty Ltd (NZ)
PO Box 912026
Victoria Street West
Auckland 1142, New Zealand
Tel: 0800 450 168
+61 3 9580 1333, fax +61 3 9580 8995