Stack Overflow
Stack Overflow

Questions tagged [alwayson]

High-Availability and Disaster Recovery functionality, for SQL Server 2012 and later. A primary read/write database and up to 4 secondary database for reporting or disaster recover. There are several fail over and configuration options

196 questions
13
votes
3 answers

Is it possible to enable Always On for Azure websites through management/resource management APIs?

I am writing some code for automatic deployment of Azure websites (including the creation of the website in Azure). I'm using the Azure Management Libraries and Azure Resource Management Libraries available in Nuget. Most of it is in place, however…
Hallgeir
  • 1,213
  • 1
  • 14
  • 29
11
votes
1 answer

Select from sequence with SqlCommand.ExecuteScalar() returns NULL when high disk usage

I encounter that SqlCommand.ExecuteScalar() returns NULL sometimes in production environment. I've crossed a lot of similar questions here, the most close one is: SqlCommand.ExecuteScalar returns null but raw SQL does not. But the advice given is…
flam3
  • 1,897
  • 2
  • 19
  • 26
10
votes
2 answers

Encryption with an AlwaysOn cluster

I have a database that was moved off of an old SQL Server 2008R2 instance and into a SQL Server 2012 AlwaysOn cluster. There are several fields within the database that are encrypted using SQL Servers built-in encryption features (master key, cert,…
dparsons
  • 2,812
  • 5
  • 28
  • 44
9
votes
1 answer

SQL Server 2012 AlwaysOn synchronous replica is not actually synchronous for reading

I'm trying to read data from synchronous secondary replica just after writing data to primary replica. But my data is not present on secondary. There is a latency about 100-500ms before data appears on secondary. Is it possible to make secondary…
Dmitriy Startsev
  • 1,442
  • 10
  • 19
8
votes
1 answer

How to show current position of a slider over the thumb always

How to show a slider control with a tooltip/label under the thumb showing the value (timespan) always while it moves with/without user dragging. I tried AutoToolTipPlacement="BottomRight" AutoToolTipPrecision="3" on my slider. But Tooltip gets…
newbie14
  • 85
  • 1
  • 5
7
votes
1 answer

AlwaysOn Availability Group Listener access

This question is about the correct way of accessing an Availability Group Listener? Assume I have two AlwaysOn Availability Groups with the following AG's: AG1 and AG2. I also have 2 listeners called LISTENER1 (on AG1) and LISTENER2 (on AG2). I have…
zurebe-pieter
  • 3,246
  • 21
  • 38
7
votes
1 answer

Using ApplicationIntent=ReadOnly with stored procedures which insert data to temp tables

I'm using SQL Server 2012 AlwaysOn listener and I want to use a connection with ApplicationIntent=ReadOnly parameter for calling some stored procedures, and this is my question: stored procedures which insert data into temp table can use connection…
Masoumeh Karvar
  • 791
  • 1
  • 14
  • 32
6
votes
1 answer

Microsoft AlwaysOn failover solution and Delphi

I'm trying to make a Delphi application to work with AlwaysOn solution. I found on Google that I have to use MultiSubnetFailover=True in the connection string. Application is compiled in Delphi XE3 and uses TADOConnection. If I use Provider=SQLOLEDB…
Tiberius Cocarlea
  • 63
  • 4
5
votes
1 answer

Dirty Reads in SQL Server AlwaysOn

I have a pair of SQL Server 2014 databases set up as a synchronous AlwaysOn availability group. Both servers are set to the Synchronous commit availability mode, with a session timeout of 50 seconds. The secondary is set to be a Read-intent only…
Paul
  • 16,285
  • 13
  • 41
  • 52
4
votes
1 answer

Connecting to read only instance of Always On availability group

Good day, I have a performance related question with regard to reading from a read-only instance of an availability group. To my understanding (sorry I'm not very knowledgeable with Always On(AO)) you can connect to the read-only instance in two…
D. Jonker
  • 103
  • 1
  • 7
3
votes
2 answers

Trap SQL Failover Exceptions

I am utilizing the NuGet package Polly to implement retry logic that traps Failover SQL Exceptions. I have a SQL Server Always On High Availability set up in Azure. Rather than trap all SQL Exceptions (which would be incorrect), I want to trap…
Bert
  • 31
  • 2
3
votes
1 answer

Performance impact on primary instance when querying read-only replica

I am currently working on an application that continuously queries a database for real time data to be displayed. In order to have minimal impact on systems which are writing to database, which are essential to the business operation, I am…
D. Jonker
  • 103
  • 1
  • 7
3
votes
1 answer

How to programmatically add a database to an existing Always On Availability Group (AOAG)?

I'd like to programmatically (T-SQL scripts) create a new database, and then add it to an existing Always On Availability Group (AOAG). So far, I'm ok with creating the database, creating a full back-up (which is a pre-requisite for adding a…
Alex Sanséau
  • 8,250
  • 5
  • 20
  • 25
3
votes
1 answer

AlwaysOn AG does not failvover on restart of SQL Server Windows service

I am trying to test the SQL Server AlwaysOn availability group behavior of my application database. I have created the availability group and able to simulate a failo ver from cluster manager, or from SQL Server studio correctly. The failover will…
Dhawalk
  • 1,257
  • 13
  • 28
3
votes
1 answer

MSDTC in Always On Availability Groups

The company I work for would like to use Always on availability groups architecture in our SQL Server supported application. we have 3 databases straight off of installation and one of those is partitioned by configuration, we currently use MSDTC to…
DorD
  • 153
  • 2
  • 12
1
2 3
…
13 14