[How Can I find if DAG secondary is serving the read requests]

Thanks Meccaneck,

 

I am not that great with SQL querries, Any way i tried running the above command given by you it gave me Syntax error.

Can you please write the steps so that a novice like me can get the job done.

 

again i thank you for taking time out and replying

[How Can I find if DAG secondary is serving the read requests]

Hi all

 

As Title suggests I have configured a DAG (High on availability group) and which has 2 secondary DB. Can Some one help me to find out that

1) Read requests are served by secondary

2) Which request is routed to which secondary.

 

Any help on this is greatly appreciated

 

Thanks and Regards

vaibhav

[Problem Event Name: CLR20r3]

Hi

 

I am facing a problem while running a query on SQL server. SQL is crashing giving programs needs to be closed.

 

Here are the error details:

 

Description:

Stopped working

Problem signature:

Problem Event Name: CLR20r3

Problem Signature 01: ssms.exe

Problem Signature 02: 2009.100.1600.1

Problem Signature 03: 4bb679e7

Problem Signature 04: System.Windows.Forms

Problem Signature 05: 2.0.0.0

Problem Signature 06: 520b1a71

Problem Signature 07: 16cd

Problem Signature 08: 159

Problem Signature 09: System.ComponentModel.Win32

OS Version: 6.3.9600.2.0.0.256.4

Locale ID: 16393

Read our privacy statement online:

http://go.microsoft.com/fwlink/?linkid=280262

If the online privacy statement is not available, please read our privacy statement offline:

C:\Windows\system32\en-GB\erofflps.txt

Please help me ,

PS : .Net framework installed on windows 8.1 is 2 ,3.5 and 4.5.