The query execution plan is a map of work which SQL Server is going to perform to execute a query. It provides a lot of useful information like operators, cost, estimated rows, actual rows, predicate details, parallelism, and much more information to troubleshoot the performance issue. During the troubleshooting of the performance issues, I would […]
Figuring out Time-Out Prone queries
Read more
Recently, I was helping one of the community attendees on the SQL Server Query Time-Out issue. Once we are done with troubleshooting, he asked a very excellent question; “I am dealing with very critical OLTP systems. As my company has been expanding the business, the data is rapidly growing. It is causing a lot of […]
Getting Query Execution Statistics
Read more
If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So, if you are SQL Developer and your query run slow, you would prefer to have query execution statistics so that you can figure out what causing the query to run slow. To get the query execution statistics, […]
Over-Indexing can hurt your SQL Server performance
Read more
Indexes are a vast subject and well documented elsewhere on the web. But, it is still a very commonly asked topic. In order to improve your queries (applications) and databases performance, we create indexes. But those created indexes may not be very useful over the period because of your application requirement changes, the queries against […]
SQL Replication SubscriptionStreams setting
Read more
In this blog, we will talk about improving distribution agent throughput by modifying the profile parameter – “SubscriptionStreams”. I will be discussing a few real time scenarios where I implemented the parameter to isolate latency issue between Distributor and Subscriber. Real Time Scenario Let’s think about; In your environment, you found that there are a few millions of […]
Extracting Deadlock information using SYSTEM_HEALTH Extended Events
Read more
Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health information of the SQL Server instance. Today, we are going to explore how quickly we can read the Deadlock information using Extended Event – “Without passing the default location of the extended events trace files” The system_health […]
What Immediate_sync means in Transactional Replication – Part1
Read more
In my previous two blogs – Capture Important Parameters of the SQL Server Replication and Add new articles to existing Transactional Replication without initializing old articles, I mentioned about one of the very critical parameters to consider is the immediate_sync in the Transactional Replication. Let’s understand both the options of the parameter. When you say; immediate_sync= true It […]
SQL Server 2017 – DMV – sys.dm_os_host_info
Read more
I always love to get my hands dirty with new features of SQL Server. I was exploring SQL Server on Linux, and at a point, I had to check the operating system details of the Linux system. Being lazy to figure out Linux OS command to check the operating system details, I started figuring out […]
Add new articles to existing Transactional Replication without initializing old articles
Read more
Suppose, you have Transactional Replication configured in your production environment. There is a business requirement to add a new article to the existing publication, and you would like to initialize only the newly added article instead of all articles in the publication. To achieve the above requirement, I will be using below-mentioned Publisher Server, Publication Database, and Subscriber […]
Capture Important Parameters of the SQL Server Replication
Read more
Whenever there is a business requirement to add a new article to an existing publication, you want to know how the publication is going to behave during the initialization. Basically, you start asking following questions to yourself; Will a new snapshot (running the snapshot agent of the publication) cause to initialize\reinitialize to all the articles […]