CODEWITHSUNDEEP
sql-serverazureazure-sql-database
Poku
Poku

Reputation: 3188

Azure SQL: Keep alive option

Is it possible to enable and set the KeepAlive property on a Azure SQL database? I can't find it when i'm using Microsoft SQL Management Studio on the Azure database.

Upvotes: 1

Views: 4366

Answers (1)

Herve Roggero
Herve Roggero

Reputation: 5249

Sorry; that's not really an option. The keepalive option is really a TCP configuration setting that impacts the behavior of database connections; you do not have access to any machine/network configuration options in SQL Azure.

However SQL Azure already provides a built-in feature that automatically kills idle connections and long-running transactions; this should provide a similar outcome.

Upvotes: 1

Related Questions