Database locks have been a bane to most DBAs. They cause unnecessary problems to database and business processes. In this blog, we will examine what database locks are, issues that can arise from it, and provide ways on how to deal with it on SQLServer. Not only that, we will also implement it in dbWatch Control Center as an example.

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

IT planning within an enterprise is crucial, whether you are a startup company or a big enterprise that is undergoing major changes. You need the full cooperation from various teams within the company and work together to determine how to improve the business, when it comes to finances, infrastructure, new projects, etc.

Topics: cost-effective, database automation, database operations, sqlmonitor, databaseoperations, oraclelicensing, indexmaintenance

Future proofing is part and parcel of any business strategy. You need to plan for your business to succeed. A noteworthy solution is investing in a flexible and reliable database monitoring tool. By investing into it, your staff is equipped with the means to increase the productivity and your business adapts to the changing landscape of your IT infrastructure. However, the process of future proofing does not end with just getting the right tool. The application of the tool and how it can add value to your business will merit your business longevity and success.

Topics: database monitoring, sqlmonitor, sqlmonitoring

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 when you’re too busy with a lot of administration work, with little resources and time you might have difficulties prioritizing your daily tasks.

Topics: database monitoring, sqlmonitor, sqlserver, sqlmonitoring, databasemonitor, errorlog, SQLErrorLog, sqlerror

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.  

Topics: sqlmonitor, sqlserver, sqlmonitoring, databasesecurity, oracle, databasemonitor

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