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

What’s the Size of Your Database Instances? MySQL Edition

Posted by Lukas Vileikis on Oct 13, 2021 8:47:00 AM

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? 

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

Read More

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

Sessions in Databases: To Monitor or Not to Monitor?

Posted by Lukas Vileikis on Oct 6, 2021 8:27:00 AM

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. 

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

Read More

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

Optimizing MySQL Engines with dbWatch

Posted by Lukas Vileikis on Sep 29, 2021 8:07:00 AM

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. 

 

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

Read More

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

MySQL Connections

Posted by Lukas Vileikis on Sep 22, 2021 10:00:00 AM

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. 

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

Read More

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

Database Uptime 101

Posted by Lukas Vileikis on Sep 15, 2021 9:00:00 AM

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. 

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

Read More

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

Database Security with dbWatch: A Guide

Posted by Lukas Vileikis on Sep 8, 2021 5:59:00 AM

If you find yourself frequently working with any applications, you already know how important security is: if you are a web developer, the security of your website is obviously one of the most important topics related to it, if you are a database administrator dealing with any kinds of database instances (be it MySQL, MariaDB, Percona Server, Oracle, MongoDB or any other databases), security should be on the table as well. 

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

Read More

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

Job Statuses in dbWatch - the How, Why and When

Posted by Lukas Vileikis on Aug 31, 2021 7:00:00 AM

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. 

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

Read More

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

Managing Database Farms vs. Managing Single Database Instances with dbWatch

Posted by Lukas Vileikis on Aug 24, 2021 7:00:00 AM

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. 

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

Read More

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

Monitoring SQL Server Collations in dbWatch

Posted by Lukas Vileikis on Aug 18, 2021 7:30:00 AM

If you are a database administrator, you already know how important database design, indexes, partitions, and other things are. However, what is equally important are the character sets and collations that are in use on your database instances. In this blog post we will tell you what you need to know to monitor collations in SQL Server with dbWatch. 

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

Read More

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

SQL Server and Hard Drives with dbWatch

Posted by Lukas Vileikis on Aug 11, 2021 7:00:00 AM
 
If you are a developer or a database administrator, you already know how important it is to keep an eye on your hard drives. 
 
By keeping an eye on the drives associated with your database instance, you can constantly monitor their capacity – if you use scalable hosting providers, it is not unheard of that they allow you to add or remove disk drives as desired. To do so though, you first need to make sure what problems your hard drives are facing – what is their capacity? What amount of space do they use on the disk? How much space does each database instance consume? etc. 

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

Read More

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