Replication Monitor: In replication monitor from the list of all subscriptions just double click on the desired subscription. There we find three tabs. Publisher to Distributor History Distributor to Subscriber History Undistributed commands
What are the agents in replication? Ans: Snapshot Agent: Copy Schema+Data to snapshot folder on distributer. Used in all types of replication. Log reader Agent: Sends transactions from Publisher to Distributor. Used in transactional replication Distribution...
What are the main events and columns helpful in troubleshooting performance issues using profiler? Ans: Events: Event Group: Performance Event: ShowPlan_ALL (BinaryData column must be selected) Event: ShowPlan_XML Event Group: T-SQL Event: SQL:BatchStarted...
What are the main events and columns helpful in troubleshooting performance issues using profiler? Ans: Events: Event Group: Performance Event: ShowPlan_ALL (BinaryData column must be selected) Event: ShowPlan_XML Event Group: T-SQL Event: SQL:BatchStarted...
How to change the sql server service account in a cluster environment? Ans: Method 1: (No failover required) 1. Freeze the service group on active node from cluster administrator and then restart the service. Method2: 1. Offline the SQL resources 2. Update...
How to change the sql server service account in a cluster environment? Ans: Method 1: (No failover required) 1. Freeze the service group on active node from cluster administrator and then restart the service. Method2: 1. Offline the SQL resources 2. Update...
Q. How to change the sql server service account in a cluster environment? Ans: Method 1: (No failover required) 1. Freeze the service group on active node from cluster administrator and then restart the service. Method2: 1. Offline the SQL resources 2....
How do you know how much memory has been allocated to sql server using AWE? Ans: We can use DBCC MEMORYSTSTUS command to know the memory allocation information. But it’s trick to understand the results. We can use a DMV called “sys.DM_OS_Memory_Clerks”....
What is the option ”Lock Pages in Memory”? Ans: Lock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not to swap out SQL Server memory to disk. By default, this setting is turned off on 64-bit systems,...
Can we install SQL Server using a configure file? Ans: Yes! We can prepare a configuration file. While installing SQL Server the path to the configuration file is specified in the “Ready to Install” page in the configuration file path section. Cancel...
