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

Performance alerts configuration with dbWatch

Posted by Chad Pabalan on Mar 18, 2020 2:02:16 AM
In an enterprise with multiple systems across various departments, database administrators find not only multiple database platforms such as Oracle and SQL Server, MySQL, PostgreSQL but also different versions of each platform. DBA's usually manage tens to hundreds up to thousands of database instances of different platforms and versions within the company.

 

Each database platform and sometimes each version come with their own set of tools, it is a waste of time switching through multiple applications just to monitor and manage hundreds of database instances.

 

dbWatch is the perfect solution to monitor and track all your instances for you. The dbWatch alert module is powerful and flexible, so you can configure precisely how you receive alerts, what alerts you receive, who receives them and at what time of the day or week. In this way you can create alert rules to match work schedules with different alert schemes for office hours, nighttime and weekends.

See the example below.

Read More

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

Database monitoring in complex networks

Posted by Andreas Hope on Apr 11, 2019 2:11:00 PM

Monitoring databases in large,  distributed or hybrid environments

Monitoring database or SQL servers can in itself be a complex task - as we discuss in SQL Monitoring - 5 steps to full control. But what if you have a really complex environment, with multiple locations, restricted networks behind firewalls, high number of servers or a hybrid solution with some on-premise and some in a cloud? What are the issues, and how can you resolve them?

Read More

Topics: scalability, sqlmonitor, sqlserver, sqlmonitoring

Vision for the Future: dbWatch Enterprise Manager 12

Posted by Andreas Hope on Apr 11, 2019 2:03:21 PM

dbWatch Enterprise Manager 12

Read More

Topics: security, sqlmonitor, sqlperformance, sqlserver, sqlmonitoring, databaseoperations

Security considerations in database operations

Posted by Andreas Hope on Jul 2, 2018 3:25:00 PM

As most DBAs know, security of data is one of the most difficult yet important tasks of maintaining a large estate of databases. It has kept more than one administrator up at night worrying about potential threats and pitfalls. With the growth of the information economy, not only is most information stored in databases, the value of that information has grown. As with anything with
value, the threats to security increases at a direct correlation to its worth.

Read More

Topics: security, sqlmonitor, sqlserver

What is meant by horizontal and vertical database scalability?

Posted by Andreas Hope on Nov 8, 2017 9:55:00 AM


Database server scalability is a common practice in use by IT departments today to help them cope with ever-growing databases and server requirements.

As data requirements grow, the number of server instances in use by businesses explodes, and the importance of stable and reliable IT systems increase, it’s no longer possible for businesses to cope with rigid, non-scalable systems and tools.

Read More

Topics: scalability, sqlserver, sqlmonitoring

Helping DBAs find Productivity: an Interview with dbWatch

Posted by Rebecca Harrisson (Guest) on Oct 4, 2017 8:28:00 AM

This is a guest post by Rebecca Harrisson, a writer from Oslo, Norway, focusing on science and technology subjects.  

Read More

Topics: sqlserver, sqlmonitoring

Optimizing Oracle and SQL Server licensing cost with dbWatch

Posted by Andreas Hope on May 16, 2017 8:55:00 AM

Want to lower the cost of your database operations? You might start by consolidating database servers and loads, reducing the number of servers or standardising software. Even if you’ve settled on a single database engine like Oracle, it’s common to have multiple different versions in use; out of all the organizations using our dbWatch tools, only one managed to converge on a single version of Oracle. But just as you need to see if you’re making the most of your hardware and software environment, you also need to check if you’re using your budget efficiently on what can be complex licensing decisions.

Read More

Topics: sqlserver, oracle, licensing

Optimizing SQL Server operations: First steps

Posted by Marek Jablonski on Jan 19, 2017 8:51:00 AM

When the number of SQL Servers begins to grow along with your business, it is often difficult to keep up. A lack of coordination or database administrators can exacerbate problems associated with this growth. Consolidating and optimizing your servers will go a long way toward reducing the cost and complexity of your database environment. This brief is the first in a series of articles on optimizing SQL Server environments and SQL Monitoring , describing the initial steps to take toward consolidation. 

Read More

Topics: sqlmonitor, sqlperformance, sqlserver