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 th开发者_StackOverflow中文版e Azure database.
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.
精彩评论