Blog

SQL Server databases are often repositories for large volumes of business-critical data. As the sizes of databases grow, restore operations become time-consuming. Database professionals need to access data in backup files quickly to reduce recovery time and increase application and business availability. Learn how to instantly access your data in backup files via several conventional and advanced recovery capabilities...

SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance information, analyze it, and determine the resolution in minutes rather than hours. Leverage proven industry best practices endorsed by Most Valuable Professionals (MVPs) to analyze the performance and to provide recommendations. Target some of the most common areas of performance...

Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases. Determine which databases are not backed up within the last specified number of days.Display the last backup time stamp for each database. Display the last backup time stamp for each database. Drill down into the complete backup history for a specific database. Display...

Use IDERA Uptime Cloud Monitor (UCM) to monitor your PostgreSQL database for availability and performance. Prerequisites Uptime Cloud Monitor from IDERA offers a SAAS based out-of-the-box solution for monitoring PostgreSQL for performance and availability. If you are not familiar with the concept of custom metrics as used in Uptime Cloud Monitor, please go through Custom Metrics information once before continuing...

To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases. For this purpose, display these statistics of indexes: The percentage of rows modified since statistics were last updated. The percentage of updates to the total number of times the index is accessed. The columns affected by the statistic. Whether the index is clustered or disabled...

Do you need to: Move databases from one instance to another (for example, to move a performance-intensive database to a faster hard drive to speed up performance)? Copy databases from one instance to another or on the same instance. Migrate databases while preserving the associated data files and maintaining the associated logins. Relocate the data files for a database to a different storage device while keeping...

We are pleased to announce the general availability (GA) of IDERA ER/Studio 17.0 ER/Studio 17.0 delivers significant new business process modeling capabilities in the Business Architect component. Performance and quality improvements have been made throughout the suite, as well as platform enhancements. What’s New in ER/Studio 17.0? Business and Enterprise Architecture The new release of ER/Studio...

We are pleased to announce the general availability of SQL Diagnostic Manager 10.2.1. Existing users may upgrade to this version through the Idera Customer Portal . New users may download the trial version from the Idera Website . This release includes the following features: What’s New in Diagnostic Manager 10.2.1? This release adds the capability previously added in SQL Diagnostic Manager 10.2 to the browser...

Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes. View the fragmentation level of indexes.Filter the results by Filter the results by server, database, and table. Sort indexes based on the fragmentation level, size, and name. Hide small and disabled indexes. Reorganize or rebuild indexes. With the Quick Reindex tool of SQL Admin...

Take Oracle, SQL, Sybase, and DB2 performance to the next level

Determine the health of instances by collecting real-time statistics (including backup devices, databases, error logs, locks, logins, performance counters, processes, and agent errors). With the Server Statistics tool of SQL Admin Toolset , display a comprehensive list of real-time statistics for instances of SQL Server. This is how easy it is: Connect to one or more instances. Display the statistics of the...