Cluster Service: The Cluster Service controls cluster activities and performs such tasks as 1. Coordinating event notification, 2. Facilitating communication between cluster components, 3. Handling failover operations 4. Managing the configuration. Heartbeat:...
Differences between active-active and active-passive cluster Active-active Setup: Two active Servers are configured as companion servers, each with independent workloads. These companions run on the primary and secondary nodes, respectively, as individual...
Is it possible to configure resource governor with T-SQL? Yes, here is the code for it with explanation in between. Step 0: Here we are assuming that there are separate login accounts for Reporting server and OLTP server. 1 2 3 4 5 6 7 /*-----------------------------------------------...
What will be the real world example of need of resource governor? Scenario 1: A server which is running OLTP workload and various resource intensive reports on the same server. The ideal situation is where there are two servers which are data synced with...
Resource Governor 1. What is Resource governor? A: Resource Governor is a feature which can manage SQL Server Workload and System Resource Consumption. We can limit the amount of CPU and memory consumption by limiting /governing /throttling on the SQL...
SQL Server 2014 Upgrade Advisor Prerequisites, Download and Installation What is SQL Server Upgrade Advisor? Microsoft has provided a free tool to analyse existing SQL Server Instance, database, its components, features and configurations and generates...
As a part of SQL Server migration we need to migrate all the logins and passwords from one SQL Server instance to other SQL Server instance or you can also transfer specific login and password to other instance for that we will use microsoft knowledge...
Migrating a database is very critical and time bound process, if anything goes wrong then its very difficult to rollback things and move back to existing environment again. So its very important to prepare a checklist before migrating a database and also...
AS DBA Checklist The role of Database Administrator is very critical and important and DBA has to perform lots of activities and monitoring is one of the important task. A good DBA always tries to minimize his routine activities by automating tasks. The...
SQL Server 2012 AlwaysOn One of the better-known features in the release of SQL Server 2012 Enterprise Edition is AlwaysOn. This has been designed to meet the ever-increasing need for ‘High Availability’ (HA). AlwaysOn does not use entirely new technologies...
