If you are a Senior developer, you probably have a lot of things on your plate. From mentoring junior developers to taking on large amounts of web development work, sometimes it might seem like you don’t even have the time to do anything else – however, the monitoring of databases is something that bothers every senior developer at least once in their career – they might ask questions like how do we do that? When? What tools do we use? 

Monitoring database instances manually can be very tedious and time-consuming – especially if you have a lot of database servers to take care of. However, don’t fret because there is a solution – with dbWatch, you can monitor all kinds of database instances from Oracle and Sybase to MySQL, MSSQL, MariaDB, and PostgreSQL. 

 

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

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

If you have found yourself in the shoes of a database administrator or even a very database-savvy developer or a system administrator, you probably know a thing or two about databases. Chances are that you have probably heard about database locks as well – a database lock is usually used to make only one session able to update a particular set of data, and it’s a pretty usual thing in the world of database administration.

However, what you might not have heard about are deadlocks – a deadlock in the database world usually refers to a situation where two or more transactions are in the process of waiting for each other to end, but neither ever does. What do you do in such a scenario and how do you tackle such a problem? Thankfully, you have dbWatch. 

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

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

If you are a database administrator, you are probably already keeping an eye out on your database instances as it is. You probably already know how important it is to monitor the performance of your database instances; you know how to optimize your database instances for high availability, security, performance, you know how to deal with capacity issues too. 

However, what’s also worth discussing is the actual size of your database instances: do you know what data your database instances hold? How much of it is necessary? How much of it isn’t? 

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

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

If you have every worked with databases, you are probably already familiar with a couple of concepts including SQL queries, performance, and also sessions. Today we will provide a little more information regarding their monitoring in dbWatch. 

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

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

If you’re a MySQL DBA, you probably already know a thing or two about storage engines in MySQL. If you dug into MySQL or MariaDB here or there, you probably already know that both MySQL and MariaDB offers numerous storage engines (one of those is InnoDB, there also is MyISAM, MEMORY, CSV, etc.) – MySQL even has a storage engine called a “black hole”, no joke. 

 

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

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

If you are a developer that finds himself frequently using MySQL for database administration, you probably already know a thing or two about it. You might know what CRUD (Create Read Update Delete) queries are, and you might know a thing or two about MySQL or MariaDB storage engines, database design, the kinds of indexes MySQL and MariaDB offers, also partitions. If you have ever dug deeper into MySQL or MariaDB, you might have also noticed that it has a limit of connections that it permits. 

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

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

If you have ever developed something, whether an application or a website, you probably know how critical uptime is. Uptime is not talked about since it’s frequently found to be imperative for most companies to complete their daily operations. Once our services are down, we are doing everything we can to make them available again because the longer they are down, the more issues will be caused. 

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

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

Monitoring the status of database instances is the daily task of every database administrator or even a developer. Database monitoring these days can be incredibly complex and time-consuming if performed manually: thankfully, there are tools like dbWatch that can help you in time of need. If you are a user of dbWatch, you have noticed that it has a thing called “job statuses”: this blog post should provide some insight into it. 

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

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

If you are a frequent reader of the dbWatch blog, you might have noticed that this blog has discussed SQL instance management and database farm management in the past. The previous blog on SQL instance management versus database farm management discussed the core differences between managing SQL instances and database farms – look at this blog post as an extension of it. 

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

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