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
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
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
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
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
Database maintenance is an important aspect of database management. As a DBA, you need to check for any hardware malfunction and network connectivity anomalies. Aside from physical maintenance, you are also tasked to check database integrity and patches. Sounds a lot, huh?
Read More
Performance tuning in Oracle is a repetitive process of searching for and identifying bottlenecks in your Oracle database. After identifying the culprit of the Oracle performance issue, you resolve it by modifying and optimizing the problematic query or adding indexes, if is necessary.
Read More
Topics:
database monitoring,
sqlmonitor,
sqlperformance,
sqlmonitoring,
indexmaintenance
About the Author:
Chad Pabalan is a Pre-Sales Engineer for dbWatch and a DBA specializing in SQLServer high availability setups and disaster recovery planning and configurations. He is an AWS Certified Solutions Architect Professional, a cloud enthusiast specializing in architecture and designing scalable, high available, and fault-tolerant systems on AWS Cloud.
Read More
Topics:
database monitoring,
sqlmonitor,
sqlperformance,
sqlmonitoring,
indexmaintenance
Everyone has heard of MySQL. Well, probably not everyone – say, everyone in the development and database monitoring space. Do you ever wonder why? MySQL is everywhere. The industries that use MySQL as their primary database management system include the automobile industry (think Volvo, BMW, etc.), the fashion industry (think SheIn and the like), the finance industry uses it heavily, it’s prevalent in the education industry.
----------------------------------------------------------------------------------------------
Read More
Topics:
database dashboard,
database operations,
sql server monitoring,
sql monitoring tools,
database monitoring,
sqlmonitor,
sqlperformance,
sqlmanager,
database farm,
farmmanagement
If you’ve been around the world of development at least for a little while, you will know – automation is everywhere. We mean, it’s 2022: one can find companies automating robotization processes, there are specialized houses with automated processes instead of keys, etc.
The software sector is not an exception to this rule, either – automation, especially database automation, in the software sector is rampant as well. Some of the processes that are being increasingly automated are related to databases, database monitoring, and database farm management: by automating database processes, people find themselves at ease when working with all kinds of database flavors.
----------------------------------------------------------------------------------------------
Read More
Topics:
database dashboard,
database operations,
sql server monitoring,
sql monitoring tools,
database monitoring,
sqlmonitor,
sqlperformance,
sqlmanager,
database farm,
farmmanagement