Top 10 SQL Server Always On Interview Questions

Top 10 SQL Server Always On Interview Questions

SQL THE ONE

Top 10 SQL Server Always On Interview Questions

There are total 93 questions are answered under SQL Server Always On category in the book “SQL THE ONE”. In this chapter we can see questions and answers on SQL Server Always On and scenarios. Below are the Top 10 SQL Server Always On Interview Questions:

1. What are the ALWAYSON improvements added in SQL Server 2014 and 2016?

2. How many read-write and read only databases replica can be configure in SQL Server 2012 and 2014?

3. What is the Difference between Asynchronous-commit mode and Synchronous commit mode?

4. How much network bandwidth is required for a successful Always On AG setup?

5. What’s the difference between Always On AGs in SQL 2012 and SQL 2014?

Continue reading

Posted in High Availability, Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , , , , , , | 3 Comments

Top 20 SQL Server Clustering Interview Questions

Top 20 SQL Server Clustering Interview Questions

SQL THE ONE

Top 20 SQL Server Clustering Interview Questions

There are total 79 questions are answered under SQL Server Clustering category in the book “SQL THE ONE”. In this chapter we can see questions and answers on SQL Server Fail-over Clustering and scenarios. Below are the Top 20 SQL Server Clustering Interview Questions:

1. What is Private Network in windows cluster?

2. What Quorum mode you recommend for a given cluster?

3. Can we change the Quorum settings after installing the windows cluster?

4. What is Node and Disk Majority model?

5. Let’s say a user is performing a transaction on a clustered server and failover has occurred. What will happen to the Transaction?

Continue reading

Posted in High Availability, Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , , , , , | Leave a comment

Top 10 SQL Server Replication Interview Questions

Top 10 SQL Server Replication Interview Questions

SQL THE ONE

Top 10 SQL Server Replication Interview Questions

There are total 67 questions are answered under SQL Server Replication category in the book “SQL THE ONE”. In this chapter we can see questions and answers on SQL Server Replication and scenarios. Below are the Top 10 SQL Server Replication Interview Questions:

1. How to monitor latency in replication?

2. Your customer given a business requirement and asked you to configure the replication topology. How do you suggest the correct replication topology?

3. Have you ever configured both log shipping / Database Mirroring and replication on same database? If yes can you tell me the things that we need to consider?

4. Which is the best way to monitor replication? Have you ever implemented automation in replication monitoring?

5. Scenario: Transnational replication configured on a database. A transaction failed on Publication. Does the failed transaction replicated to subscriber?

Continue reading

Posted in High Availability, Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , , | 3 Comments