Suggested MSSQL Monitoring Configuration

Products

• CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

While working with MSSQL DBA team it was asked inernally which configuration is best to use:  Instance Name or Listener Name.

When we use listener name with additional parameter "ApplicationIntent=readonly"  it will use the secondary replica instead of primary.

In this way it will put less load on the Primary database.

Please suggest which is the recommended way of configuration.

Resolution

Typically you would just connect to the listener not listener\instance.

As you can span different named instances as replicas when you failover, you would break the connection string.

There is also no warranty that a patch also won’t break the functionality.

 

For safety always use the listener -- don’t over complicate things.