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
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
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
Topics: security, sqlmonitor, sqlperformance, sqlserver, sqlmonitoring, databaseoperations
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.
Topics: security, sqlmonitor, sqlserver
Considering migrating your databases to Azure? A new report by our CTO Marek Jablonski has revealed some very surprising facts about the performance you can expect from an Azure database.
Topics: sqlmonitor, sqlmonitoring, databaseoperations, azure, cloudperformance
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.
Topics: sqlmonitor, sqlperformance, sqlserver
© 2020 dbWatch AS
