<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=204641&amp;fmt=gif">

Analyzing your Oracle database performance with dbWatch Control Center

Posted by Chad Pabalan on Sep 28, 2022 1:27:06 AM
 
 
Read More

Topics: database monitoring, sqlmonitor, sqlperformance, sqlmonitoring, indexmaintenance

  Multiplatform database farm monitoring, management solution, and inventory management with dbWatch Control Center for Oracle, MySQL, SQL Server, and PostgreSQL

Posted by Chad Pabalan on Sep 8, 2022 9:30:00 AM
 
The DBA needs a dedicated solution to support him in his day-to-day work monitoring and managing the whole database farm. His customized scripts for a few servers that he was using back then might not be as effective in tracking or handling the current database farm he manages currently.   
 
 
 
 
Read More

Topics: database monitoring, sqlmonitor, sqlperformance, sqlmonitoring, indexmaintenance

Avoid firefighting and start fire prevention with dbWatch Control Center

Posted by Chad Pabalan on Sep 5, 2022 9:00:00 AM
 
Being a Database Administrator (DBA) is a tough job whether you’re an Oracle DBA, SQL DBA or MySQL DBA; as a DBA, you oversee every aspect of database monitoring, database management, data manipulation and transformation to ensuring the integrity and accessibility of your data while securing it from unauthorized access.   
 
 
 
 
Read More

Topics: database monitoring, sqlmonitor, sqlperformance, sqlmonitoring, indexmaintenance

Be proactive and productive with dbWatch Control Center

Posted by Chad Pabalan on Sep 1, 2022 8:00:00 AM
 
DBAs are IT professionals responsible for performing diverse activities in managing and maintaining an enterprise's database environment. He/She is crucial to the success of your organization, as data is essential in successfully navigating your business in a very competitive market, from server provisioning through database monitoring, tuning, troubleshooting, fire-fighting, upgrades, etc.
 
 
 

Read More

Topics: database monitoring, sqlmonitor, sqlperformance, sqlmonitoring, indexmaintenance

Stored Objects in Database Architectures

Posted by Lukas Vileikis on Aug 29, 2022 1:11:00 AM

At some point in your career as a DBA, you might want to dive deeper into databases and their architecture to fiddle with interesting things. One of those interesting things are stored objects – those things refer to objects created with a CREATE PROCEDURE statement and they’re usually stored inside of the server until they’re called for use by the user using a CALL statement. 

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

Properly Matching Character Sets and Collations in MySQL

Posted by Lukas Vileikis on Aug 26, 2022 8:45:00 AM

Have you ever come across a scenario where your data looks good until you import it into MySQL? The data you’ve imported into MySQL is suddenly displayed as “???”, letting you wonder what’s wrong in your database configuration. The reason of this problem is a character set or collation mismatch – when worked with properly, character sets and collations can make our work with MySQL a dream, or a nightmare. 

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

Enterprise Backups Won’t Save You

Posted by Lukas Vileikis on Aug 24, 2022 12:46:33 AM

All database administrators back up their data – that’s a given. Not all backups are created equal, though – as time passes, many database administrators find themselves switching between their variations – for example, MySQL has mysqldump, Percona XtraBackup, SQLBak, and a couple of others, PostgreSQL can be backed up with pg_dump, Barman (Backup and Recovery Manager for PostgreSQL), or a couple of other tools, while Oracle Recovery Manager is a fit to backup an Oracle database infrastructure. 

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

Common Issues Between Database Management Solutions and PHP Developers

Posted by Lukas Vileikis on Aug 18, 2022 10:00:00 AM

All developers come across at least a couple of issues while they find themselves developing applications for the web. That’s exactly why sites like Stack Overflow, Stack Exchange, and the like exist – that’s developers helping other developers in trouble. 

If you’re a frequent visitor of Stack Overflow though, you will notice that most of the issues related to software engineering have something to do with databases as well – new questions are also posted minutes ago, literally. And the given example only pertains to MySQL – can you imagine how many new questions are posted day-by-day targeting other database management systems? Thousands. 

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

Alternative Storage Engines in MySQL

Posted by Lukas Vileikis on Aug 14, 2022 10:46:55 PM

If you’ve been a frequent user of MySQL now or in the past, you know for a fact that there are multiple storage engines MySQL allows us to choose from. The most frequent one is InnoDB which is known as a “high performance” storage engine meaning that if optimized properly via the parameters provided by MySQL in my.cnf, the storage engine can do wonders – MyISAM is considered more obsolete though, but it has its own use cases including providing an exact count of the rows in a specific table and storing database files in a recoverable format since the files provided by MyISAM are not bound to any other files such as ibdata1 provided by InnoDB. 

----------------------------------------------------------------------------------------------

Read More

Topics: database dashboard, database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager, database farm, farmmanagement

A DBA's guide to monitoring Oracle database performance

Posted by Chad Pabalan on Jun 7, 2022 4:51:42 AM
Performance tuning in Oracle is a repetitive process of searching for and identifying bottlenecks in your Oracle database.
After you identify the culprit of the performance issue, you can fix it by optimizing the problem query or adding indexes.
 
 
UPDATE: Since we published this blog, we have added new advanced performance tools to dbWatch Control Center.
 
You can find out more about these in this blog: 
 
 
 
 
 
 
Read More

Topics: database monitoring, sqlmonitor, sqlperformance, sqlmonitoring, indexmaintenance

control-center-cta