Monitoring SQL Server error logs

Posted by Chad Pabalan on May 5, 2020 3:00:09 PM
As a data platform expert who manages and maintains hundreds or maybe thousands of database instances, you may be thinking of a better way in managing these number of servers more efficiently. An environment this huge with a lot of vital applications relying on those databases can be quite difficult to keep track of. Especially …

Assigning user roles in dbWatch

Posted by Chad Pabalan on Apr 4, 2020 4:00:58 PM
As a busy database administrator managing and monitoring tens or hundreds of database instances, you are plenty busy enough as it is. While you’re busy with your daily routine, sometimes your manager or developers would ask for your assistance regarding the status of a certain database you’re in charged with. As they were experiencing slow running queries, blocking sessions or deadlocks within the staging environment.   Normally you would have to drop what you are doing in order to help them out, before you can resume with your …

Performance alerts configuration with dbWatch

Posted by Chad Pabalan on Mar 3, 2020 2:16:30 PM
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 …

Database monitoring in complex networks

Posted by Andreas Hope on Apr 4, 2019 2:11:05 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 …

Vision for the Future: dbWatch Enterprise Manager 12

Posted by Andreas Hope on Apr 4, 2019 2:03:33 PM
dbWatch Enterprise Manager 12 At dbWatch we believe that DBAs should be able to manage their databases using a single solution. We understand your pains because we experience them, we work through our own bugs before going into beta-testing. Because we use our own software to monitor databases, we have learned firsthand the improvements needed. …

Security considerations in database operations

Posted by Andreas Hope on Jul 7, 2018 3:25:28 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 …

What is meant by horizontal and vertical database scalability?

Posted by Andreas Hope on Nov 11, 2017 9:55:33 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 …

Optimizing Oracle and SQL Server licensing cost with dbWatch

Posted by Andreas Hope on May 5, 2017 8:55:03 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, …

Optimizing Sql Server Operations First Steps

Posted by Marek Jablonski on Jan 1, 2017 8:51:21 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 …

Most Popular

Posts by Tag