IDERA Community
Search
User
Site
Search
User
Home
Blog
Performance Monitoring & Tuning
SQL Diagnostic Manager for SQL Server
SQL Defrag Manager
SQL Diagnostic Manager for MySQL
SQL Doctor
SQL Query Tuner for SQL Server
SQL Workload Analysis for SQL Server
Precise
Uptime Infrastructure Monitor
Database Administration
SQL Admin Toolset
SQL Enterprise Job Manager
SQL Inventory Manager
SQL Safe Backup
Database Security
SQL Compliance Manager
SQL Secure
Data Modeling
ER/Studio Business Architect
ER/Studio Data Architect
ER/Studio Team Server
Database Development & Management
Aqua Data Studio
DB PowerStudio
PowerShell
Power Tips
Ask the Experts
Using PowerShell
Video Library
Script Library
Module Library
Events
Geek Syncs
Live Demos
Free Tools
More
Cancel
Database Tools
More
Blog
New
General Availability of Aqua Data Studio 21.1
We added support for the new serverless platform, Amazon Athena!
ER/Studio Named Best Database Management Software
ER/Studio Data Architect was included in Digital.com's list of the Best Database Management Software…
The Bottom-Line Benefits of SQL Server Monitoring
With SQL Server performance monitoring, your business can avoid the risks of costly downtime.
Be Prepared for Regulatory Changes in the New Year
Compliance is a moving target as new laws are passed and existing standards evolve.
Previous
Feature 0
Feature 1
Feature 2
Feature 3
Feature 4
Next
Options
Browse by Tag
announcements
Aqua Data Studio
cloud
data architecture
data governance
data modeling
data modeling & architecture
database
database administration
database monitoring
database performance
database tools
DBA
DBArtisan
diagnostics
ER/Studio
ER/Studio Enterprise Team Edition
events
how to
IDERA
Microsoft SQL Server
monitoring
Monyog
MySQL
MySQL Monitor
MySQL Monitoring
MySQL query
MySQL server monitoring
new version
news
performance
Precise
product updates
releases
security
SQL
SQL Compliance Manager
SQL Diagnostic Manager
SQL Diagnostic Manager for MySQL
SQL Diagnostic Manager for SQL Server
SQL DM for MySQL
SQL Safe Backup
SQL Secure
SQL Server
Uptime Infrastructure Monitor
Latest Posts
By date
By view count
By comment count
Descending
Ascending
How to monitor and diagnose SQL query performance
Peter V.
Executing resource-intensive SQL queries requires a significant amount of processor time, memory, and bandwidth, and storage. Resource-intensive SQL queries prevent other SQL queries from using these resources. This can eventually lead to blocking. C...
17 May 2022
Four unique features of ER/Studio Data Architect
Peter V.
Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models, propagate changes from one model to the other in both directions, create database scripts, and reverse-enginee...
16 May 2022
How to tune the performance of SQL Server, Azure SQL Database and Amazon RDS
Peter V.
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 ...
13 May 2022
How to ensure that databases are backed up regularly
Peter V.
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 backu...
12 May 2022
How to analyze the health of database indexes
Peter V.
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 upda...
11 May 2022
How to migrate databases and data files
Peter V.
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. Migra...
10 May 2022
Announcing the General Availability of SQL Secure 4.0
Elan Kol
We are pleased to announce the general availability of SQL Secure 4.0 SQL Secure is the industry-leading, state of the art auditing and security solution for SQL Servers that helps identify vulnerabilities with SQL Server configurations and access, e...
9 May 2022
How to ensure that databases do not have fragmented indexes
Peter V.
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 in...
9 May 2022
How to monitor the health of database instances
Peter V.
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 Tool...
6 May 2022
Discover 10 lesser-known capabilities of SQL Diagnostic Manager
Peter V.
Introduction This blog post describes ten lesser-known features of SQL Diagnostic Manager with links to short how-to videos and additional resources. Learn how to add custom counters and custom SQL scripts, capture deadlocks, integrate with SCOM, mon...
5 May 2022
Combine PowerShell and SQL Diagnostic Manager to automate SQL Server monitoring
Peter V.
Run new and existing PowerShell scripts with
SQL Diagnostic Manager
and utilize the vast power of PowerShell via the customizable monitoring environment. Run scripts to automatically react to problems detected by the monitoring environment,...
4 May 2022
Keep track of database performance with Uptime Infrastructure Monitor
Peter V.
Uptime Infrastructure Monitor
Uptime Infrastructure Monitor (UIM)
is an enterprise tool that provides a unified view for Information Technology systems monitoring. Although comprehensive and scalable, UIM is also easy to use and deploys in minut...
3 May 2022
How can SQL Workload Analysis help you?
Peter V.
To find the key points of how
SQL Workload Analysis
can help you, look for the ducks
throughout this blog post! What Is SQL Workload Analysis? It is an add-on to
SQL Diagnostic Manager
and a component of the IDERA Dashb...
2 May 2022
Discover how cardinality affects performance
Peter V.
Cardinality is a term from set theory that deals with the size of a set. Data cardinality can affect query plans and performance. Minimize the effects of cardinality adjustments. Create efficient SQL queries in low cardinality environments. Read the ...
29 Apr 2022
Make SQL Server performance easy
Peter V.
Every database administrator hates to wake up at midnight just to learn there is an emergency with their database. Sometimes, even though their hardware specifications are above par and they know everything was working fine earlier that day, database...
28 Apr 2022
Enable customer business intelligence via data catalogs, business glossaries, and data governance
Peter V.
For over three decades, organizations have relied on data warehouses to support business information consumers’ needs for descriptive analytics to help inform about the current state and to help influence ongoing business decisions. People augm...
27 Apr 2022
Cut SQL Server licensing costs
Peter V.
SQL Server resellers often send true-up forms to their customers more frequently than Microsoft requires. Some customers receive them every month. They may feel compelled to fill them out each time. However, Microsoft only requires one true-up each y...
26 Apr 2022
Improve database performance by 400%
Peter V.
A large enterprise telecommunications company that provides wireless services and internet services in the United States of America uses a third-party application to gather configuration and performance data on their servers. However, a batch job tha...
25 Apr 2022
Understand the role of data architects in data governance
Peter V.
Effective data governance programs are partnerships between the business and technical parts of the organization. Often, organizations focus more on one side of the house than on the other, when in reality, governance-like activities are already taki...
25 Apr 2022
Decide between agent-based versus agentless monitoring
Peter V.
Monitoring applications, networks, and servers (physical, virtual, and cloud) across multiple platforms has become essential, making smart server monitoring software critical for building a successful Information Technology department. However, with ...
22 Apr 2022
Measure database performance under pressure
Peter V.
Today’s complex applications execute hundreds of SQL procedures and maybe thousands of SQL statements during a typical workload. Database administrators and developers can use load testing to verify that the system can handle the workload with ...
22 Apr 2022
Compare four leading database IDE tools
Peter V.
Today, many roles within an organization often work with the ever-growing amounts of data in databases. No longer are databases the purview of just the information technology professionals, such as application developers and database administrators. ...
22 Apr 2022
Make, not break, SQL Server performance
Peter V.
One of the beautiful things about SQL Server is how accessible it is. It is about as difficult to install as, say, Microsoft Office. This is great if you want a sandbox, or a database to support just a handful of users. The problem is that in order f...
21 Apr 2022
Announcing the General Availability of SQL Compliance Manager 5.9
Elan Kol
We are excited to announce the release of SQL Compliance Manager 5.9 SQL Compliance Manager is the industry leading SQL Server auditing solution that dramatically lowers the cost for companies to maintain database compliance standards ...
20 Apr 2022
>