Yea Sir. DNS server is accessible from Node where Failover cluster is installed.

Yes sir i have used iSCSI storage devices. I have separate SAN windows. During cluster validation, there is no single warning related to SAN storage drives. I will generate cluster...

Dear Sir,

I have attached the snapshot of Ip configuration of Node1 , Node2 and DC.

Node1 and Node2 has both private and Public ip.

Now i have recreated cluster and reinstalled Active...

Yes Sir, I have already installed Windows Failover cluster. I have 2 Nodes windows failover cluster. I am going to install Sql server active active failover cluster using 2 node....

Thanks Sir for your kind information.

Could you please let me know how do i find which tables stats needs to be updated instead of whole table's stats.

So that i do not have to...

Thanks Sir for reply.

We have transaction replication to 2 other instance's databases. if something happens and main database server there will be loss of 1-2 second's records only.

We have...

Thanks for reply and suggestion Sir. As per our business requirement, we need to take only one time FULL database back up and transnational log backup . Could you please...

Could you please tell me why same query is performing slow in peak transaction hour. However same query performs faster in staging of same database size as well as less...

Thanks Sir, Answer given by you for question 1 and question 2 is sufficient answer for me.

Thank you.

Thanks Sir. That really helped.

By using operator, we can configure sending mail either in fail only or success only. is any possible to configure email using operator sending email not only in failure of...

Dear Sir thanks for reply.

one of the table referencing to primary key table has FK WITH NOCHECK. However another table which has FK reference to primary key table, have...

Database is in full recovery mode. Back up is scheduled at night time 12 AM for both FULL DB backup and log file(that time almost no transaction in our database).

DB...

We have real time replication.

we have 3 databases like below

Database A: for Read and Write

Database B: for Read only

Database C: for Disaster Recovery Purpose

Real time replication is done...