blog Archives

How to Tune the Performance of SQL Server, Azure SQL Database and Amazon RDS

SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect...

Will the Traditional DBA Role be Eliminated with Cloud?

by Former Member

The cloud is all the buzz lately. New features like Automatic Tuning and Active Geo-replication are now being offered by AzureDB with the majority...

Monyog MySQL Monitor v8.2.0: Introducing same Y-axis scaling for dashboard charts

by Ritesh

This release includes some GUI improvements and also fixes a few (also mostly GUI-related) bugs. Additionally, we have upgraded most libraries used...

How to Ensure That Databases Are Backed Up On a Regular Basis

by Peter

Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases....

How to Analyze the Health of Database Indexes

by Peter

To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases. For this purpose,...

Use SQL Safe Backup’s Monitor Only Policies with customized backup operations

by Tep Chantra

In my previous blog post, I wrote about how customized backup/restore solutions can be accomplished through the use of SQL Safe Backup's command...

A complete MySQL monitoring system with early-warning mechanisms: Liam Terblanche, CTO, Airvantage

by bbiker

Airvantage is a Value Added Service Provider for mobile telecommunication networks. Airvantage offers various gaming platforms, and subscriber...

How to Migrate Databases and Data Files

by Peter

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

How to Ensure that Databases Do Not Have Fragmented Indexes

by Peter

Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes. View the fragmentation...

Guilty Until Proven Innocent

by billellis

Every DBA knows that they are guilty until proven innocent when performance problems arise. You are one of the usual suspects and it makes...

Oracle, SQL, Sybase, DB2 Performance

by billellis

Every DBA knows that they are guilty until proven innocent when performance problems arise. You are one of the usual suspects and it makes...

How to Monitor the Health of Database Instances

by Peter

Determine the health of instances by collecting real-time statistics (including backup devices, databases, error logs, locks, logins, performance...

Become an IDERA ACE Today!

by Former Member

Applications for the 2017 IDERA ACEs are now open! The search has begun for the 2017 IDERA ACEs. Do you have a passion in helping the community and...

Setting up an Apache Web Server in Debian using Google Cloud

by Anil M

Setting up an Apache Web Server in Debian using Google Cloud Howdy! In the...

Fireproof Your DBA Career in our Next Twitter Chat!

by Former Member

Is your DBA career fireproof? Let’s discuss the things that can get you fired and make sure you’re not doing them. Our next #SQLChat...

Setting up a Linux VM using Google Cloud

by Anil M

Howdy! In this blog post, I will be showing you all on how to setup a new Linux VM in Google Cloud. If you are new to Google Cloud, I would...

RDS/Aurora OS monitoring with Monyog v8.1.0

by bbiker

With this Monyog release, we will provide monitoring capabilities for RDS/Aurora OS metrics along with an emphasis on the User Experience in several...