superbfestivalnerd-blog

[superbfestivalnerd-blog]

IDERA database management and optimization tools

IDERA offers tools for analyzing, monitoring and diagnosing database performance issues and increasing the performance of SQL code across the major relational databases.

In October 2015, IDERA acquired Embarcadero Technologies to enhance its existing database performance management and administrator tools portfolio. The company now offers a full spectrum of database, infrastructure and application management products for app developers and DBAs.

IDERA’s multi-platform monitoring tool, the Precise Application Performance Platform, is predominantly an application performance management tool, but it also provides database performance monitoring options for Oracle, DB2, SQL Server and SAP Adaptive Server Enterprise. A common interface enables a consistent user experience, regardless of the underlying database being accessed.

Using Precise, database administrators (DBAs) can implement 24/7 heterogeneous database monitoring to analyze behavior to find database objects and processes with performance issues such as high I/O rates or locking problems. Precise can identify potential bottlenecks and take corrective action before end users are adversely impacted. It can also be used to generate tuning recommendations, perform what-if analysis, and for capacity planning and management.

DB Optimizer can be used to optimize SQL code across the major relational DBMSes. It assists DBAs in tuning SQL statements via visual SQL tuning diagrams for explain plans and a SQL tuning wizard that provides automated performance optimization recommendations. The product’s database profiling capability simplifies tuning with wait-time analysis visualization, making performance problems easy to spot. It can also be used to simulate the production environment in test.

Rapid SQL can be used to assist developers as they write code to formulate high-performing SQL against heterogeneous DBMSes. The product offers a visual query builder; a code analyst for examining SQL code; and debugging aids for SQL statements, stored procedures and functions.

DBArtisan can optimize database objects across heterogeneous DBMSes as well as manage space, data and performance details with built-in analytics. DBAs can use DBArtisan across all supported platforms from a single product license. It can be used to view detailed performance metrics and identify performance, capacity planning and storage management issues before they become major problems. DBArtisan also offers a Process Monitor to identify connected users and their current activity and a job management function that integrates with Microsoft Windows Task Scheduler.

DBArtisan also provides performance analytics capabilities such as those listed above in the coverage of Precise. But DBArtisan is a desktop tool, licensed for each user, whereas Precise is licensed based on the application, technology or database management system that’s to be monitored.

IDERA’s heterogeneous database performance management tools support Oracle, IBM DB2, SQL Server and SAP Adaptive Server Enterprise.

[superbfestivalnerd-blog]

Tools for managing SQL Server

IDERA offers additional database performance management tools for managing SQL Server performance, including:

SQL Diagnostic Manager delivers physical and virtual performance monitoring with the ability to set up alerts on important database performance metrics; it can also be used to monitor and identify poorly performing SQL queries.

SQL Doctor provides expert recommendations and assistance with query plans. It can integrate with SQL Diagnostic Manager.

The SQL BI Manager monitors and manages the health and availability of Microsoft SQL Server Analysis Services, SQL Server Reporting Services and SQL Server Integration Services to optimize the performance of these business intelligence services.

The SQL Defrag Manager identifies database objects that require reorganization and helps the DBA schedule defragmentation jobs to repair hot spots, page splits, reset space and fill factor settings.

[superbfestivalnerd-blog]

Identifying and Solving Common SQL Server Performance Problems

Performance is always one of the DBA’s top priorities. The one thing that you know for certain is that if SQL Server isn’t performing up to the user’s expectations, you��ll hear about it. SQL Server is a complex system and there are a lot of factors that go into making it perform well and keeping it performing well.  In this webcast, join Michael Otey, senior contributing editor at SQLServerPro, as he dives into some of the performance problems that a lot of SQL Server instances run into as well as the recommended industry best practices from Microsoft, MVPs and other database experts on how to handle them. Some of the main areas that he will cover include:

Keeping the wrong default configuration values

Monitoring SQL Server instances in Azure and AWS

Handling Tempdb contention

Indexing mistakes

Identifying problem queries

Dealing with CPXPACKET waits

Detecting SQL Server memory pressure

Subsequently, Tep Chantra from IDERA will discuss IDERA’s powerful solution for performance tuning with expert commentations for SQL Server in the hybrid cloud. SQL Doctor retrieves all of the necessary information, analyzes the results, pinpoints potential problems, and determines the resolution in minutes rather than hours. SQL Doctor leverages proven industry best practices to analyze the performance and provide expert recommendations plus executable scripts. It targets SQL Server (on premise and cloud virtual machines), Azure SQL Database, and Amazon RDS. SQL Doctor makes daily tasks easier for novices and experts at performance tuning.

[superbfestivalnerd-blog]

The difference between VPS and Cloud

As technical as we may have of this title may seem, the concepts of VPS and Cloud can be explained easily by those who understand the subject. Basically, Cloud is a scalable (that is, flexible) environment that allows applications and data to run within a server with more than enough space for such applications. Yes, this is a robust feature that allows sites with large numbers of hits do not suffer with possible variations of visits; Large companies can resell products like the hosting itself (this is the case for many resellers, for example). This all requires dedication with regard to maintenance, and with regard to the very use of these systems.

The big difference between Cloud and VPS is this. We at KingHost, sell the Cloud as a package that guarantees not only the perfect environment for your applications, sites, data, etc. We also guarantee product height support. Professionals highly trained to ensure that any issues that may exist on servers that support cloud clients are resolved with the utmost urgency, making customers at the other end even feel that there has been any kind of downtime.

In the case of VPS, however much the client can access the virtual environment through a panel, everything that happens behind this panel is the responsibility of that same client. That is, in case some server that supports this VPS environment crashes, or any problem happens, the client will get involved with the problem. He will have to understand the reason for the problem to occur, as well as having to wait for the system to return as a whole.

The great confusion is made when the cloud is presented not only as a robust solution – that is. But it is also presented as something that only serves large companies. Instead, the cloud is for you to host your website, your application, your ER system, etc. With the security of having our support teams monitoring your environment 24 hours a day.

It is worth knowing more about the possibility of guaranteeing your company a more solid online presence and that guarantees confidence to its users.

[superbfestivalnerd-blog]

SQL Diagnostic Manager

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* Transactional SQL Server Application Monitoring with SQL Workload Analysis

Now available in the Pro version of SQL Diagnostic Manager

SQL Workload Analysis focuses on wait state and application transaction monitoring and analysis by continuously sampling queries and plans. It significantly upgrades the wait state analysis capabilities.

Combine the operational monitoring from SQL Diagnostic Manager and transactional monitoring with SQL Workload Analysis to view instance properties and alerts, receive prescriptive recommendations for operational diagnosis, analyze workloads for transactional diagnosis, and arrive at a comprehensive root cause analysis.

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.

Predictive Alerting

Avoid false alarms with adaptive alerting functionality and set alert thresholds based on built-in historical statistical analysis of your server performance data.

The system has embedded heuristic analysis of event trends and behaviors and presents a percentage of likelihood that various events could happen later in the day based on past behavior trends. This helps DBAs to be better prepared to diagnose, drill down, and resolve an issue quickly and effectively.

Mobile Access

Access SQL Diagnostic Manager from anywhere. Use any mobile device, such as iPhone, Android, Blackberry or Tablet to view real-time and historical SQL Server performance data. Plus, view or kill sessions, start/stop jobs and run queries to resolve or diagnose issues remotely while on-the-go.

View a demo of SQL Diagnostic Manager mobile.

Web Dashboard

Log in from anywhere and quickly check the status of monitored server instances to identify and diagnose issues. View the current status of monitored instances, drill down into single instance details, view the top occurrences of performance issues, and see a rollup of all active alerts. Customize your display with eighteen new widgets, enhanced heat map view, and query wait state visualizations. Create any number of individually configured dashboards to address the needs of the entire organization.

Integration with SCOM

The SQL Diagnostic Manager Management Pack provides easy integration with Microsoft’s System Center Operations Manager (SCOM). The Management Pack propagates the current status, health and events of all monitored instances up to Operations Manager, allowing the DBA and IT Operations staff to share data at a higher level across their enterprise. The management pack is easy to install and does not incur any additional monitoring overhead. Read the FAQ and watch a quick 5 minute video to learn more.

Source: https://www.idera.com/productssolutions/sqlserver/sqldiagnosticmanager

[superbfestivalnerd-blog]

SQL Inventory Manager

Discover all SQL Servers Across the Enterprise

Scan the network to find all your SQL Servers and databases including databases on AlwaysOn Availability Groups. Scan by domain, IP address ranges, and/or import your own server lists from excel or CSV files. Flexibly schedule discoveries to locate newly added servers daily, by specific days of the week &/or at particular times of day. In addition users can discover BI services (SSRS, SSIS, SSAS) running in their environment.

Get Complete Visibility

See all those servers lurking that you may not have known existed including SQL Express instances. Users can manually add or set auto-registration to add discovered instances to SIM for monitoring and get recommendations to bring the instances up to maintenance.

Monitor and Manage Inventory

Go beyond Microsoft’s Assessment Planning (MAP) toolkit for SQL Server inventory tracking. Automatic discovery and a Global Dashboard provide high-level visibility of all server inventory. Learn what you have, which servers are improperly configured and what actions might need to be taken for instances competing for memory and resources. Also compare your current SQL Server builds with the latest build from Microsoft to determine if you have the latest patches or versions.

Establish Tags to Group and Analyze Inventory

Create tags at the server, instance and database levels to organize by owner, location, function or other categories to suit different needs. You can even mark servers as “unmanaged” to revisit for follow-up later. A tag cloud displays on the Dashboard that groups the tags created to quickly visualize the size of those groups comparatively by prominence or importance.

Get Availability Alerts and Run Health Checks

Receive email alerts for key server indicators such as when servers are down, whether a database has ever been backed up or early warning when you are about to run out of space. Perform regular health checks on monitored servers to gage adherence to configuration best practices. Plus view the findings in a simple list with recommendations for improvement from SQL Server experts.

Deploy Quickly and Scale Out as Needed

Agentless, low impact design offers download, install and use in under 5 minutes with no other modules or installation necessary of anything on monitored servers. A stand-alone web application with no need for IIS provides a simple sign on to login and use remotely from anywhere. Plus it is designed to scale up as you grow, capable of monitoring and managing thousands of databases running on DEV, PROD, QA, TEST or SQL Express instances.

Source: https://www.idera.com/productssolutions/sqlserver/sql-elements

[superbfestivalnerd-blog]

SQL Doctor

Easily Improve the Performance of SQL Server, Azure and AWS Instances

For SQL Server, Azure SQL Database, and Amazon RDS SQL Server, analyze the performance of databases and receive tuning recommendations for resolving them in minutes as opposed to hours. Target some of the most common areas of performance problems, such as queries, server configuration, security, database objects, memory, wait statistics, query plans, and much more.

Instantly Locate Performance Issues with “Quick Findings”

Highlight where performance-threatening issues are occurring. “Quick Findings” provide real-time expert advice on how to fix an issue and tune your overall server performance, similar to recommendations. A rapid and therefore limited look at key performance metrics results in each finding. “Quick Findings” point you in the correct direction and give you crucial troubleshooting information when you need it most. However, to get a thorough review of your server performance, routinely perform a full analysis. See “Quick Findings” for these metrics: Queries, sessions, wait stats, and query plans. Display metrics in real-time for processes, network interface cards, processor, processor cache, memory, disk, and system information SQL .

Improve Performance with Updated Recommendations for SQL Server 2016, Azure SQL Database, and Amazon RDS

Leverage the latest proven industry best practices endorsed by SQL Server MVPs to analyze 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 were developed for SQL Server 2016, Azure SQL Database, and Amazon RDS SQL Server.

Generate Executable Scripts to Optimize Performance

Display the executable T-SQL script that can be used to enact the recommended change. Run the script directly from within SQL Doctor to initiate the optimization, or copy the T-SQL script to the Windows Clipboard to examine the code and research other options before making the change. Similarly, generate reverse scripts for quickly undoing any of the implemented optimization scripts.

View Trends from History of Analysis Recommendations

Store and easily retrieve historical data and recommendations for trending and comparison.

[superbfestivalnerd-blog]

SQL Defrag Manager

Identify Index Fragmentation

As index fragmentation increases over time, performance degrades, response times slow, and I/O suffers. SQL Defrag Manager performs an automated analysis of key metrics related to fragmentation to quickly pinpoint those areas where fragmentation is severely hindering performance, then triggers corrective measures.

Schedule Jobs

Manage the defragmentation process through scheduling of jobs at the most optimal time and based on the size of the index. Automate remediation and run the defragmentation utility immediately or during off-peak hours.

Avoid Contention

Check the utilization of key system indicators prior to execut­ing the defragmentation. This ensures that the policy is able to run as scheduled and avoid any potential system problems or application bottle­necks.

Manage Fill Factor

Most solutions don’t pay attention to the fill factor of tables, this can be a big drawback. With SQL Defrag Manager, users can manage index fill-factor settings and reduce splitting and shifting of pages as well as defrag job frequency.

Centralized management

The global dashboard displays all the SQL servers in your environment from one console, each database is color coded to reflect how much impact fragmentation is having on it, its databases, tables and indexes. You can easily sort to bring the items most in need of your attention to the forefront and take corrective action.

Sourch: https://www.idera.com/productssolutions/sqlserver/sqldefragmanager

[superbfestivalnerd-blog]

SQL BI Manager

Comprehensive Monitoring of the SQL Server BI Stack

Monitor the health and availability of your entire SQL Server BI environment including SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS). Ensure uptime and identify issues quickly.

Detailed SSAS Performance Metrics

Monitor a wealth of SSAS performance and processing metrics, query activity, cache, sessions, object utilization, and user activity – everything you need and more to keep your analysis services running at peak efficiency.

Tune Object Utilization for Cube and Tabular Models

See the performance of your analysis models as well as your analysis servers. Monitor formula and storage engine cache, memory utilization, and row activity for objects to help you tune both cube and tabular models.

Monitor Reporting Services and Integration Packages

View SSRS performance counters and report execution activity to monitor how long it takes for reports to run, which ones didn’t run, and the impact on server resources. View by user, by session, and by processing time. See SSIS activity to monitor integration package status, execution duration, and if there were errors.

Configurable Alerts

Set alerts and email notifications with configurable threshold levels to keep you informed of only the relevant information.

Web-based Dashboard

Log in from anywhere and quickly check the status of monitored SQL BI server instances. The customizable web dashboard provides at-a-glance status of top issues and alerts with easy drill down capabilities so you can identify and diagnose issues quickly.

Sourch: https://www.idera.com/productssolutions/sqlserver/sql-server-business-intelligence

[superbfestivalnerd-blog]

DB Optimizer

Streamline SQL Tuning Across Major DBMSs

Tune poorly performing SQL code on all major DBMSs (Oracle, SQL Server, DB2 and Sybase) from a single common interface. Reduce training requirements and streamline collaboration among teams across the organization.

Tune SQL Like a Pro!

The SQL tuning wizard automatically suggests solutions and provides essential context in tuning SQL code. Color-coded Index Analysis shows used, not used, or missing indexes and offers recommenda­tions for optimum performance. Case Generation is used to generate all possible cases and to find the best alternative to a given SQL statement by including SQL rewrites and hint injections.

Visually Tackle Complex SQL Queries

Unique in the industry, Visual SQL Tuning (VST) diagrams turn text-based SQL code into graphical SQL diagrams. This approach helps DBAs and developers understand the impact of SQL statements on the database. The VST diagram displays indexes and constraints on tables and views with table statistics, as well as the joins used in a SQL statement such as Cartesian joins, implied Cartesian joins and many-to-many relationships.

Identify Performance Bottlenecks Immediately

Database profiling provides a graphical visualization of wait-time anal­ysis, making the SQL that is causing poor database performance easy to pinpoint. Continuous profiling monitors an entire data source within a configurable span of time. Also, explain plans are provided for a better understanding of how SQL will be executed and the performance costs. Utilize reporting to allow sharing of information captured during the profiling process.

Simulate Production Environments

Load testing verifies performance of existing and alternative SQL queries against the database. Configure queries to run multiple times in parallel and see how they respond to your simulated production environment without the risk of actually testing in production.

Sourch: https://www.idera.com/dboptimizer-sql-database-optimization

[superbfestivalnerd-blog]

Precise Application Performance Platform

The Precise Platform is designed specifically to keep your Oracle environment available and performing at peak efficiency. It captures, measures, and analyzes performance metrics from all critical system components and helps you detect and correct the root causes of problems before end users are affected. The Precise Platform provides high-level visibility across multiple Oracle and Oracle RAC instances and provides alerting to problems, reports on collected data, and maintains a warehouse of Oracle database performance information.

See how Precise compares with Oracle Enterprise Manager (OEM) >>

24×7 Oracle Database Monitoring

The Precise Platform continuously analyzes database behavior to find the poorest performing objects or processes, including Heavy Statements, Heavy Objects, High I/O, RAC events, storage devices, and more. Historical statistics stored by instance, by user, and by program provide the necessary context to further help DBA in seeing the whole picture.

Simplified Problem Isolation

The Precise Platform quickly analyzes SQL statements, database objects, and Oracle instances to uncover specific causes of performance problems. It presents the Oracle access path in detailed steps and displays the statistics needed to understand each step so you can isolate problems fast.

Pinpoint Problem Root Cause

Once a performance problem is identified, The Precise Platform allows DBAs to drill down in context of the user transaction to pinpoint the problem’s root cause, whether it is a poorly designed SQL statement, program, database object, or even a bottleneck due to a resource shortage in the underlying operating system, virtualization infrastructure, or storage.

Proactive Tuning Recommendations

The Precise Platform provides DBAs with a library of knowledge and experience designed to help them tune their Oracle environment. Recommendations around SQL statement tuning, database object tuning, index tuning, and index cost are just a few examples of the many recommendations available.

Perform “What If” Analysis

The Precise Platform automatically identifies problem areas and provides actionable advice on how to address them. Before any change is made, DBAs can perform “what-if” analysis to predict the impact of proposed changes to remove the risk of accidentally making things worse.

Capacity Planning

Oracle databases are constantly growing and evolving. By connecting transaction performance with the infrastructure it touches, the Precise Platform makes it easier to align server and storage capacity with the growing needs of the business.

Sourch: https://www.idera.com/application-performance-monitoring/relational-database-performance/oracle-tools

[superbfestivalnerd-blog]

Workload Analysis for SAP HANA

Fast, granular and real-time database performance monitoring and analysis

Focus on database performance monitoring and analysis by continuously sampling SQL queries with high granularity.

Locate problematic SQL queries within the software stack

Locate problems within the software stack including which application instance, cluster or service. Further identify the location of the problem within applications, reducing the mean time to resolve issues.

Prevent problems to reduce the time between services failures

Detect problems early and prevent problems in the future. Consequently, reduce the mean time between failures of services.

Provide statistics for performance before and after a migration

Display statistics for performance both before and after migration to SAP HANA to reduce risk.

List heavily used components to optimize with SAP HANA

List heavily used components such as hosts, users, services, areas, and SQL statements. Also, display the likely performance gain that can be realized when optimizing with SAP HANA such heavily used components.

sourch: https://www.idera.com/sap-hana-monitoring

[superbfestivalnerd-blog]

SQL Safe Backup

NEW* Now with integrated SQL Virtual Database functionality for instant read and write access to databases directly from backup files.Advanced Backup Technologies

Backup faster, save space and protect backups. Advanced compression, disk-writing, and multi-threading technologies reduce backup time. IntelliCompress2™ samples system resources and adjusts compression levels. Use advanced encryption standard (AES) with minimal performance degradation.

Multiple Recovery Options

Choose from several recovery options. IntelliRestore™ provides point-in-time recovery. InstantRestore™ streams data from backups on-demand while restoring in the background. Virtual Database accesses data in backups instantly without restoring. Benefit from next-generation object level recovery (OLR).

Policy-based Management

Ensure organizational compliance. Policy-based management defines and automates backup, restore, and log shipping schedules across multiple databases, servers, and server groups. Eliminate scripts and overhead of native backup and recovery. Report exceptions for jobs that did not complete as planned.

Network Failure Resilience

Eliminate failures due to temporary network problems. When a temporary network problem occurs, pause the backup and restore processes. Then automatically resume once the network is back online.

Web-based Central Console

The web-based user interface is accessible from any web browser. It provides a central console with real-time and historical monitoring of backup and restore processes. Automatically receive alerts on the results of operations, and create comprehensive, customizable reports.

Sourch: https://www.idera.com/productssolutions/sqlserver/sqlsafebackup

[superbfestivalnerd-blog]

SQL Enterprise Job Manager

Comprehensive Job Monitoring

SQL Enterprise Job Manager provides comprehensive monitoring of SQL Server agent jobs across the entire SQL Server landscape. See what is scheduled to run and when and get up to the minute status information. View jobs by instance or drill down into specific jobs to see alert settings, upcoming jobs, and history details.

Familiar Calendar Layout

View jobs and status in a familiar calendar layout. Jobs are color-coded for quick identification of current, past, and upcoming scheduled jobs as well as jobs that have been manually run.

Job Chaining

Create sequences, or chains, of jobs that run automatically one after the other based on the status of a preceding job in the chain. Configure simple to complex chains of jobs that can run either in series or in parallel to each other. The software utilizes a drag and drop interface to schedule the execution order. Job chains can be defined on a single server or span across multiple SQL Server instances.

Multi-Instance Jobs

Create and manage jobs that run over multiple instances to simplify management of common tasks, ensure consistency, and save time. Once created, individual instances can be easily added or removed from the multi-instance job as your environment and needs change.

Configurable Notifications

Build email alerts to be notified of job status or potential issues. Establish alerts for indicators such as when jobs fail or restart, server instance connection failures or when job agents have stopped running.

Web-Based Architecture

SQL Enterprise Job Manager is a architected as a web-based management console for easy deployment across the enterprise. Users can login from anywhere with an internet connected PC to monitor and manage their SQL Server agent jobs.

IDERA Dashboard Integration

The IDERA Dashboard is a unified web interface for accessing individual IDERA SQL products together and includes a cross-product dashboard that provides integrated views of status, top issues, and alerts across all installed products. With a few clicks users can easily move between viewing server performance details, to job status information, and to backups depending upon which IDERA SQL products are installed. The integrated IDERA Dashboard provides a single view of important information across products to simplify management of your SQL Server environment.

Sourch: https://www.idera.com/productssolutions/sqlserver/sql-server-agent-job

[superbfestivalnerd-blog]

SQL Compliance Manager

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 with the integrated column search, 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 customize 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.

Generate reports

Design and export views from the web dashboard to easily create custom reports and choose from over 25 pre-defined compliance reports for detailed auditing. Pre-defined reports were developed in partnership with auditing experts to address critical 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 customized if needed.

Minimal Overhead

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.

Web-based Dashboard

The web dashboard provides easy access to audit and compliance information from any web browser. Explore audited SQL Servers, configure and manage alerts and event filters, view and search activity and change logs, access audit reports, import and export audit settings, and more. The activity report card and audited instances widgets provide at-a-glance summaries of top audit activities and concerns.

Sourch: https://www.idera.com/productssolutions/sqlserver/sqlcompliancemanager

[superbfestivalnerd-blog]

SQL Secure

Identify Vulnerabilities

Understand who has access to what and identify each user’s effective rights across all SQL Server and Azure SQL database 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 vul­nerabilities, security changes, and user entitlement over time.

Set Strong Security Policies

View a complete history of SQL Server security set­tings 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 databases and servers. Each security check is categorized as High, Medium, or Low Risk. You can drill into each security check to get more detail.

Analyze User Permissions

Analyze 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.

Security Templates

We’ve taken the security standards most companies are held accountable to and developed customizable templates to extract the information needed to satisfy a security auditor’s requirements. Choose from templates for PCI, HIPAA, and FERPA which leverage guidelines from STIG and CIS.

[superbfestivalnerd-blog]

SQL Job Manager – Free Tool

Management Console

View SQL Server jobs and scheduled jobs across your SQL enterprise from a single console. Manage jobs by simply dragging and dropping from within a single server or from one server to another. Print job schedules directly from the console.

Identify SQL Job Contention

See jobs and identify job contention across multiple servers. Maximize hardware resources and improve application performance by leveling jobs across available resources.

Level Job Workload

View jobs across the SQL Server infrastructure and more easily balance workloads via drag and drop of jobs across servers ensuring optimum use of system resources.

At a Glance View of Jobs

Quickly and easily see job status in the job tree and get comprehensive details about jobs, such as start time, run time and average run time, by hovering over the information icon of a specific job. This information will pinpoint areas where problems may exist, such as long running and runaway jobs.

Calendar View

Five calendar viewing options paired with four job status filter options mean complete flexibility to customize the view to see more granular schedules and quickly find the information most important to you. Frequently running jobs can be omitted from the calendar view to obtain a higher level understanding of job operations.

Connect to Cloud and Run in Cloud (Provisional)

Connect to database instances hosted in the cloud, such as SQL Server on Azure Virtual Machine (VM).

Run on virtual machines hosted in the cloud, such as Windows on Azure Virtual Machine (VM) and Windows on Amazon Elastic Compute Cloud (EC2).

Sourch: https://www.idera.com/productssolutions/freetools/sqljobmanager