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.

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

 

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

We all experience how the number of database instances keep growing (especially SQL Servers) in the last few years.

Topics: database monitoring, sqlmonitoring, databaseoperations

Managing large database farms requires a different mind-set and a different set of tools than what you need when you only have a handful of instances to look after.

Topics: sqlmonitoring, databaseoperations, webcasts, events

The secret to monitoring data is about finding the perfect balance. Too much data and you’re drowning, not enough and an ailing instance may slip under your radar. The perfect mix will track your instance’s vital signs, putting your finger on the databases’ pulse. With these vital signs, you can quickly find out if the database is healthy, while being able to track and understand any irregularities.

Topics: database monitoring, sqlmonitoring, productivity

 

Topics: database automation, database operations, sqlmanager, sqlmonitoring, databaseoperations

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?

Topics: scalability, sqlmonitor, sqlserver, sqlmonitoring

dbWatch Enterprise Manager 12

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

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.

Topics: scalability, sqlserver, sqlmonitoring

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

Topics: sqlserver, sqlmonitoring