About the Author:  Chad Pabalan is a Pre-Sales Engineer for dbWatch and a DBA specializing in SQLServer high availability setups and disaster recovery planning and configurations. He is an AWS Certified Solutions Architect Professional, a cloud enthusiast specializing in architecture and designing scalable, high available, and fault-tolerant systems on AWS Cloud.  As a DBA, infrastructure admin, or manager, you may have encountered a scenario where you are tasked to lead, plan and execute a server migration project for reasons such as: …

Continue reading "The 5 R’s in Server Migration Planning"

About the Author: Chad is a Pre-sales Engineer for dbWatch and a DBA who specializes in SQLServer high availability setups and disaster recovery planning and configurations. He is an AWS Certified Solutions Architect Associate, a cloud enthusiast who specializes in architecture and designing scalable, high available, and fault-tolerant systems on AWS. As a database administrator managing many different database instances on various platforms, it can be difficult for you to track various aspects of your performance within your database farm. You …

Continue reading "Create A Customized Database Performance View In Dbwatch"

About the Author: Chad Pabalan is a Pre-sales Engineer for dbWatch and a DBA who specializes in SQLServer high availability setups and disaster recovery planning and configurations. He is an AWS Certified Solutions Architect Associate, a cloud enthusiast who specializes in architecture and designing scalable, high available, and fault-tolerant systems on AWS Introduction to Database Farms  Companies use different database management systems to store large amounts of data for processing and analysis; some companies have massive data warehouses (OLAP) for analytics …

Continue reading "dbWatch Control Center for managing Database Farms"

Problem You are hired for a new job as a Senior DBA but the previous DBA who just left the company didn’t provide the complete documentation of the existing database instances. You need to get a full overview of all instances, retrieve and document all the database instances available within the enterprise network. How could …

Continue reading "Learn how to discover all database instances available within your enterprise network"

In this blog, I will discuss SQL Servers’ database compatibility level. By using dbWatch, we will check the proper setting and configure the right compatibility level based on the version you are using.   Each new version of SQL Server introduces new functionalities and performance benefits. These are identified by compatibility level and cardinality estimators.  d As you can see each database version is associated with a compatibility level, so if you want to utilize the newest features available …

Continue reading "Track your SQLServer database compatibility level with Control Center"

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. For example, your …

Continue reading "Tips On How You Can Achieve A Cost Efficient Database Farm With Dbwatch12"

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 …

Continue reading "Monitoring SQL Server error logs"

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 …

Continue reading "Assigning user roles in dbWatch"

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 …

Continue reading "Performance alerts configuration with dbWatch"

Problem I want to view the performance of my SQL Server indexes across the database farm and determine the top instances by index disk usage. I also want to look for servers which encountered problems when running the update index statistic job. Solution dbWatch is capable of monitoring your server’s index usage rate and perform …

Continue reading "Analyzing SQL Server Indexes with dbWatch"