Idera's SQL diagnostic manager (SQLdm) provides increased availability and faster time-to-recovery for database problems. With real-time status displays that organize SQL Server information into easy-to-understand, logical groupings, SQLdm eases problem diagnosis and correction. These displays help you quickly access crucial database information and, if necessary, take preemptive action. The extensive wealth of database health knowledge in SQLdm helps both experienced and novice DBAs increase productivity.

SQL diagnostic manager View

 

Why SQL diagnostic manager?

In many organizations today, SQL Server supports business-critical applications and DBAs are required to ensure performance and availability, supporting growing SQL deployments often with constrained resources.

To ensure optimum performance, administrators need reliable SQL Server information. SQLdm enables a quick and accurate response when users complain or automated monitoring tools indicate trouble. Whether you need to see real-time events or want data for long-term planning, this product helps you diagnose problems, identify unusual behavior and obtain the information to resolve issues.

Key Benefits

Increases SQL Server availability – Enables DBAs and other administrators to quickly investigate, diagnose and correct performance and availability problems. On-screen recovery tasks make it easy to solve a problem once diagnosed. Convenient tasks include starting or stopping a SQL Agent job, stopping a blocking process, terminating a user connection, rebuilding indexes on a table and updating statistics.

Improves the productivity of both skilled and novice DBAs – Delivers organized data views with built-in data collection. These views eliminate the need to look up and understand how to apply complex system commands, while built-in features detail exactly what the interface displays.

Provides a comprehensive view of current performance – Collects and displays real-time activity and performance information for processes, caches, alerts, memory, transactions, logs, locks, replication, reorganization status and trace data. Extensive details are available from easily accessible, drill-down detailed charts.

Gathers data across multiple servers simultaneously – Collects and sorts data, enabling you to view information for one server or for the entire environment. You can easily identify the worstperforming stored procedures across all your servers or learn whether a SQL Agent maintenance job has failed on one server or all simultaneously.

Supplies continuous unattended monitoring – Allows you to log off of your computer, while SQLdm continues monitoring your mission-critical SQL applications. Its service-driven collection and alerting mechanism keeps you informed even while you are away.

Offers easy installation and use – Installs quickly and supports a mixed environment of Windows integrated security and SQL Server native security. An interactive tour walks new users through the product, eliminating specialized training.

Part of Idera’s SQL Management Suite – Idera’s SQL Management Suite (SQLsuite) is the industry’s most comprehensive toolset dedicated to managing SQL Server production operations. Built on leading technologies, the SQLsuite increases availability and improves productivity. Offering real-time performance monitoring, in-depth diagnostics, Web-based administration, configuration management and automated job management, this complete solution addresses critical problems SQL Server administrators face.

 

Idera’s SQLsafe provides a high-performance backup and recovery solution for Microsoft SQL Server. Designed to meet the needs of enterprise-scale SQL Server implementations, SQLsafe provides fast-compressed and secure-encrypted backup, reduced storage costs, automated multi-server backup management, enterprise manageability and reduced mean time to recovery. From implementations with tens of SQL servers to enterprises with thousands of servers spread around the globe, SQLsafe is the only SQL Server backup and recovery solution that scales to meet the challenge.

SQLsafe Enterprise Console

Why SQLsafe?

SQL Server today has become a critical component in many organizations’ computing infrastructure. SQL Server DBAs need a powerful backup and recovery solution that reduces the time required to execute the backup process, reduces storage requirements, enables backups to be managed across large numbers of servers simultaneously and provides for rapid recovery in the event of an emergency. SQLsafe has been specifically designed to meet these requirements, resulting in increased application and business availability for your critical SQL Server infrastructure.

SQLsafe Architecture

Key Benefits

Increases SQL Server availability – SQLsafe contains highly advanced compression, disk writing and multi-threading technologies that dramatically increase the speed of backup execution. This increases the availability of your SQL servers for your applications and your business, as well as increasing the available window for you to perform other critical SQL Server maintenance activities. Simply put, rather than spending time doing backups, with SQLsafe installed, your SQL servers spend more time working for your business.

Reduces Storage Requirements – SQLsafe’s state-of-the-art variable compression technology reduces the size of the backup output files by as much as 95%, resulting in significantly reduced storage costs and simplified backup and recovery strategies for very large databases.

Accelerates Mean Time To Recovery – SQLsafe has been engineered to perform well when you most need it – in an emergency recovery situation. A central repository keeps track of the location of backup files and the backup approach employed. An enterprise console interface and DynamicDeployment™ technology enables the restore operation to start in seconds,eliminating critical time wasted hunting for backup files, your restore software CDs and license codes.

Enterprise scalability and manageability – SQLsafe has been specifically designed to support large SQL Server installations. SQLsafe scales from supporting a single SQL Server instance to thousands of SQL servers around the globe; from databases with only a few tables to databases with thousands of tables and large volumes of data. In addition, SQLsafe’s enterprise console and enterprise-management engine enable you to perform massively parallel backup and restore operations, monitor execution in real time and store a complete history of all backup and restore operations in the central repository.

Deploys rapidly – With SQLsafe’s DynamicDeployment™ technology, a lite backup and restore agent is dynamically deployed to the target SQL servers only for the duration of the backup or restore operation. This approach enables SQLsafe to be deployed in minutes. No need to perform time consuming software installs on each target server, plus SQLsafe eliminates risk and increases performance by running as a separate process outside the SQL Server process space. Nothing is installed that may interfere with the production operations of your SQL servers.

Part of Idera’s SQL Management Suite, Enterprise Edition – Idera’s SQL management Suite (SQLsuite) is the industry’s most comprehensive toolset dedicated to managing SQL Server production operations. Built on leading technologies, the SQLsuite increases availability and improves productivity. Offering real-time performance monitoring, in-depth diagnostics, Web-based administration, configuration management and automated job management, this complete solution addresses critical problems SQL Server administrators face.

 

Designed in partnership with major auditing firms and leading security experts, Idera's SQL compliance manager provides a powerful auditing and compliance solution for Microsoft SQL Server users. SQL compliance manager provides: low overhead data collection, a central repository of audit data, a central management console, pre-defined compliance reports, an auditors console for ad-hoc queries, reporting and forensic analysis, and efficient, secure data archival. If you are tasked with ensuring compliance to external standards such as Sarbanes-Oxley, GLBA, HIPAA, Basel II, need to meet the requirements of internal auditors, or simply need to feel comfortable with your database security model, then SQL compliance manager is an essential component of your SQL Server management infrastructure.

Download our free guide, "The Seven Steps to Successful SQL Server Auditing" and learn how SQL compliance manager simplifies and dramatically reduces the cost and time associated with ensuring compliance to internal and external standards.

SQL compliance manager Enterprise Console

Why SQL compliance manager?

As mission-critical data is stored in SQL Server databases throughout the enterprise, DBAs are regularly tasked with answering the question “Who accessed my databases, what did they do, and when?" In addition they are required to provide an accurate, immutable audit trail of all access and update actions, schema changes and security permissions changes. Unfortunately, providing this audit information can often mean weeks or months of research and development, or in some cases the deployment of full-time DBA staff to provide regular reports to auditors. SQL compliance manager eliminates this overhead by providing real-time monitoring and auditing of SELECT statements, data updates, schema changes, security permissions and logins; providing quick, easy, accurate and trusted answers whether you have tens, hundreds or thousands of SQL Servers in your organization.

SQL compliance manager Architecture

 

Key Benefits

Continuous Compliance – SQL compliance manager goes beyond traditional auditing approaches by providing real-time monitoring and auditing of all data access, updates, data structure modifications and changes to security permissions. The audit data captured is stored in a central repository for reporting, querying and forensic analysis.

Low overhead data collection – SQL compliance manager employs a very efficient, low-overhead data collection mechanism. A lite agent monitors the SQL Server trace data stream in real time, collects the audit data and sends it back to the repository. The type and detail of audit data collected is highly configurable and may be defined at the server, database and object level. No changes to applications or production databases are required.

Powerful reporting and analytics – SQL compliance manager provides ‘out of the box’ auditing and compliance reports. These reports were developed in conjunction with industry experts in security, compliance and auditing policies, such as Ernst and Young and InformationShield Inc. All reports may be easily customized, plus the user-friendly schema of the audit data repository enables rapid development of ad-hoc queries and reports for forensic analysis.

Self-auditing – SQL compliance manager has been engineered to provide a trusted, immutable source of audit data. Its powerful self-auditing features ensure that you are alerted to any changes to data collection settings or attempts to tamper with the audit data repository.

Enterprise scalability and manageability – SQL compliance manager has been specifically designed to support large SQL Server installations. SQL compliance manager scales from auditing a single SQL Server instance to thousands of SQL servers around the globe; from databases with only a few tables to databases with thousands of tables and large volumes of data.

Rapid deployment – With SQL compliance manager’s DynamicDeployment™ technology, a lite agent is dynamically deployed to the target SQL servers. This approach enables SQL compliance manager to be configured and deployed in minutes. No need to perform time-consuming software installs on each target server. Plus, the Compliance Manager agent eliminates risk and increases performance by running as a separate process outside the SQL Server process space.

All-inclusive package – SQL compliance manager provides an all-inclusive package with no requirement to purchase additional components. Licensing is on a per SQL Server instance basis independent of hardware configuration.

 

Idera’s SQLconfig monitors database server hardware, operating system (OS), SQL Server instance and database configuration, providing both automated change notification and comprehensive reporting on changes in your SQL Server environment. In addition, SQLconfig allows you to fine tune and control SQL Server configuration across your entire infrastructure by setting a master or golden server. You can ensure that new servers match the ‘gold standard’ configuration and that existing servers remain compliant.

SQLconfig View

Why SQLconfig?

In a typical enterprise, many people make changes to database servers that can compromise SQL Server performance and availability. Undetected quick-fixes made during a fire drill often cause long-term trouble for database managers. Change reports and automated notification ensure database managers are aware of and can easily respond to configuration changes.

You can also streamline and ease your workload when managing multiple SQL Servers with SQLconfig. By identifying a golden master or model server, then grouping and comparing machines to your model, you can use SQLconfig to identify key configuration differences between multiple servers. This information helps you maintain identical configurations and eliminates differences as a problem source, reducing time spent investigating problems.

Key Benefits

Automates change detection — Notifies you when configuration changes occur, allowing you to evaluate and quickly correct undesirable modifications. SQLconfig identifies changes to database schema, settings and security, as well as to server hardware, OS and Windows security across dozens or even hundreds of servers.

Assures common settings across database servers — Provides a standard golden master feature. You can easily configure a model server and measure groups of servers against your model. SQLconfig provides automatic notification if any server deviates from the model. Compliance functions are not compromised if you decommission or change your model server.

Eases production rollouts — Enables you to validate the results of rolling out changes from your development environment into production. SQLconfig’s comprehensive change reports will highlight any discrepancies ensuring a smooth transition for your users.

Maintains configuration data — Gives you constant access to the baseline and current configurations, as well as a complete change history. In the event of a catastrophic server failure, you can use this key information for quick recovery. In normal operations, this is useful for planning server upgrades and simplifying routine inventory reporting.

Creates rich reports — Presents comprehensive configuration information with well-organized reports detailing the status of your enterprise hardware, OS, OS security, database schema settings and security settings.

Integrates with management systems — Functions as a stand-alone product or integrates with management systems, such as Microsoft Operations Manager 2000 (MOM) and NetIQ’s AppManager Suite (AppManager).

Part of Idera’s SQL Management Suite – Idera’s SQL Management Suite (SQLsuite) is the industry’s most comprehensivetoolset dedicated to managing SQL Server production operations. Built on leading technologies, the SQLsuite increases availability and improves productivity. Offering real-time performance monitoring, in-depth diagnostics, Web-based administration, configuration management and automated job management, this complete solution addresses critical problems SQL Server administrators face.

 

Idera's SQLschedule provides a powerful solution for scheduling and managing SQL Server job streams. Designed specifically for SQL Server and built by professional DBAs working in large scale SQL Server environments, SQLschedule enables organizations to streamline the process of SQL Server job management, dramatically reducing job failure rates and administrator overhead while increasing performance and availability.

SQLschedule calendar view

Why SQLschedule?

Scheduling and managing an ever-increasing number of SQL Server jobs has become a major challenge for DBAs in most SQL Server environments today. The volume and complexity of the job streams means that traditional manual approaches can no longer be applied; an automated solution is required to reduce administrative overhead and increase service levels.

Key Benefits

Reduces database administration operating costs – By using SQLschedule to perform SQL Server job management, monitoring and alerting, the amount of manual labor required to perform these tasks is dramatically reduced. Providing database administrators with a tool that reduces the effort to perform mundane job management tasks allows them more time to proactively manage their SQL Server environment.

Reduces downtime – SQLschedule’s powerful job monitoring and alerting capabilities help eliminate costly database downtime by tracking critical jobs such as transaction log backups, optimization, replication, log shipping, etc. Realtime alerts using SMTP instantly inform oncall personnel of jobs that have failed, finished too quickly, run too long or have never ended. In addition, a powerful visual calendaring facility enables users to quickly find, diagnose and solve problems such as failed or conflicting jobs. These conflicts can be quickly identified and corrected using the “drag and drop” capability.

Improves application performance – SQLschedule’s comprehensive reporting facilities enable administrators to make more informed decisions about job scheduling. This ensures that job contention is minimized and that the job mix is optimized to increase application performance.

Scales to support large complex environments – SQLschedule has been specifically designed to support SQLServer installations with large complex job streams. From a single instance to thousands of SQL Servers in multiple time zones, SQLschedule ensures that the job stream is optimized and that management overhead is reduced.

Deploys rapidly – With no agent installation required on the SQL Server database machines, SQLschedule installs quickly. The intuitive user interface and builtin tutorials and guidance also eliminate the need for specialized training. SQLschedule installs in minutes and can be deployed worldwide in hours.

Part of Idera’s SQL Management Suite – Idera’s SQL Management Suite (SQLsuite) is the industry’s most comprehensivetoolset dedicated to managing SQL Server production operations. Built on leading technologies, the SQLsuite increases availability and improves productivity. Offering real-time performance monitoring, in-depth diagnostics, Web-based administration, configuration management and automated job management, this complete solution addresses critical problems SQL Server administrators face.

 

Idera's DTx simplifies and accelerates the task of migrating data across databases and platforms. Whether you are implementing a new application, building a data warehouse, migrating databases, integrating data from partners or legacy applications, DTx provides a powerful, cost-effective and easy-to-use solution. Designed by database professionals with many years experience on data migration projects, DTx provides a simple browser-based tool that automates common data integration tasks. From simple data extraction to complex migration or integration projects, DTx is the one tool that handles it all.

DTx View

Why DTx?

Data transformation and integration plays a critical role in implementing new applications and delivering essential business data to users. Traditional solutions have required complex software packages, expensive consulting services, skilled programmers and database professionals. DTx's "out of the box" approach dramatically reduces complexity enabling your team to easily create, test and execute data transformation and mapping rules in a fraction of the time taken by traditional approaches. DTx eliminates the need for intensive training sessions and avoids costly ramp-up times.

Key Benefits

Provides comprehensive support for platforms and data sources – Provides built-in connectivity to Microsoft SQL Server, Oracle and MySQL. In addition, DTx provides powerful support for text files, XML and JDBC drivers, thus infinitely expanding the range of connectivity options.

Improves the productivity of your data migration team – Enables both database and non-database professionals to quickly and easily define, test and execute data transformation tasks, with no need for complex scripting or programming.

Cost effective – Deploys quickly at a fraction of the cost of traditional data transformation solutions. With its intuitive interface DTx eliminates the need for intensive training sessions and avoids costly ramp-up times.

Powerful execution engine – As well as providing a comprehensive, easy-to-use development environment, DTx also contains a powerful execution engine with job stream development and scheduling, and alerting.