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

Running SQL Queries with Tools – dbWatch Control Center Edition

Posted by Lukas Vileikis on Dec 13, 2021 7:55:00 AM

If you find yourself developing any kinds of applications focused more towards the web or even mobile applications, it is inevitable that sometimes you might find yourself running a couple of SQL queries – you need to interact with your database systems anyway, don’t you? 

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

Read More

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

SQL Server Uptime - When Do You Restart Your SQL Server Instances?

Posted by Lukas Vileikis on Nov 30, 2021 7:38:00 AM

If you are a database-savvy developer or even a database administrator, you probably know how important it is to always keep an eye out on your database servers. Some database servers might need more of your attention and upkeep than others, of course, but after all, even if they are facing some sorts of issues, none of them should be neglected – when your database instances are facing issues, one of the things you might want to keep an eye out on is uptime – your database instances might also have the need to be restarted. 

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

Read More

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

Obsolete Indexes - dbWatch to the rescue

Posted by Lukas Vileikis on Nov 23, 2021 7:29:00 AM

If you are a database developer or a database-savvy software engineer, you have probably heard a thing or two about indexes – indexes are usually used to find values matching a given query quickly, but the downside of them is that they require space, so essentially you trade-off space for speed. 

With that being said, not all database indexes are very useful – if your indexes are obsolete, they would most likely do more harm than good. 

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

Read More

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

Inside of the Activity of SQL Server: Are You Monitoring It Right?

Posted by Lukas Vileikis on Nov 16, 2021 7:21:00 AM

If you have found yourself working with SQL Server or SQL Server Express for quite a while, you might have already noticed just how important the monitoring of such database instances can be. While there might be a dozen of database monitoring and management tools available for you to use (you may be using a SQL Server management studio or similar tools already), however, if you have tried one or a few of them, you might have noticed that only a couple of them are up to the task since monitoring also needs to be done in the right way. 

 

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

Read More

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

How is The Memory of Your SQL Server Doing?

Posted by Lukas Vileikis on Nov 10, 2021 7:05:00 AM

If you are a database administrator, especially if you find yourself being a Microsoft SQL Server DBA, you probably find yourself needing to take care of a lot of things: these things might include the availability, security, capacity, or performance of your database instances, but there might be a couple of smaller things you would need to take care of: one of these things would include keeping an eye out on the memory of your SQL Server instances. 

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

Read More

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

Databases for Senior Developers - Monitoring Databases with Tools

Posted by Lukas Vileikis on Nov 3, 2021 9:30:00 AM

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. 

 

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

Read More

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

Are your Database Locks Dead?

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

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. 

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

Read More

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

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