In Previous article, we discussed – Where Are various Replication Agent Jobs Running ? This is very important for quick troubleshooting of replication issues. In this article, we will try to understand various files created by Snapshot Agent when a Snapshot is created. If we go to snapshot folder (Check location in Publication Properties), we … Read more
We in the first post saw how capturing and analyzing wait statistics can help a SQL DBA to look for potential performance issue. In the second post we looked at some of the example and potential scenario of wait stats which were similar to a production environment. In this post, we will see how we … Read more
Issue: In an always on setup, CDC jobs should be created on all the replicas of always on availability group. Sometime you may find that CDC capture and cleanup job is running successful on some of replicas but failing on other replicas with below error: Error message:Executed as user: Domain\user. Invalid object name ‘msdb.dbo.cdc_jobs’. [SQLSTATE … Read more
Scenario: Consider we have a primary data center where we want to configure HA solution using Always On availability group and want to configure log shipping to DR site as a DR solution. In this post we will discuss on how to configure log shipping for a database involved in AG and some limitations and … Read more
Recently I worked on an interesting scenario where an incident was reported for very low PLE value. Very low PLE value indicates memory pressure on SQL server and should be fixed to ensure good SQL server performance. First lets check the definitions of PLE and BCHR as per Microsoft BOL: Page Life Expectancy: Indicates the … Read more
SQL server Replication is one of the most interesting topic. Transactional Replication is most widely used for various purposes. When any issue related to Transactional replication occurs, many DBAs face difficulty in identifying locations of Replication Agent Jobs. Snapshot Agent, Log Reader Agent & Distribution Agent are three main replication related jobs whose history need … Read more
Issue Description: While patching SQL server sometimes SQL services fails to come online post patching. It may be due to various reasons like any corruption in system databases, script level upgrade failure for system databases etc. In this post, we will talk about issues that may arise if you have SSISDB (SQL server integration services … Read more
In our last post, we started a journey for SQL Server DBAs so that they can establish an approach for performance tuning issue. We went through some of the basic wait types are and shared links for downloading queries to gather those. Now that you have gathered total wait statistics from a SQL Server instance, … Read more
As a SQL Server DBA one of the most important part of our job is to do performance tuning. But, as soon as some says performance tuning, most DBAs are clueless on how to start troubleshooting. There are many articles, blogs which focuses on key aspects of performance tuning. However, in this series, we will … Read more
Recovery Model is the most important concept in Microsoft SQL Server. Recovery model controls type of backups taken for a database. It can also control transactional log truncation and Point-in-Time Recovery of a database. On any full-fledged SQL server instance deployed on a physical server or a virtual machine, we can have various databases with … Read more