azure - SQL Connection Issues... next steps -
we've released new game on facebook uses sql azure , we're getting intermittent connection timeouts.
i dealt earlier , implemented 'retry' solution seemed have dealt transient connection issues.
however, game out i'm seeing happen again. not often, happening. when happens, try logging sql azure management web portal , connection timeout there too. same trying ssms.
the query first 1 of game , it's simple select on table 4 records.
after 4 minutes, timeouts stop , day or two.
since these players around country, don't have direct contact users.
i'm looking advice on how can figure out what's going on.
thanks, tim
depending on how compute have in front of database put in limit on connection pools can created connection string.
trying setting if example have 2 compute in front of database.
max pool size=70;
sql database can handle 180 connections hard limit. can find example when hitting connection limit retry framework make matter worse try connecting period of time leading further downtime. might reason see several minutes compute retry frameworks give up.
http://msdn.microsoft.com/en-us/library/windowsazure/ff394114.aspx
have following:
-- monitor connections select e.connection_id, s.session_id, s.login_name, s.last_request_end_time, s.cpu_time sys.dm_exec_sessions s inner join sys.dm_exec_connections e on s.session_id = e.session_id go
you should try add cache application design, can reduce application on head on database , recommend practice sql azure. can have connection issues. have seen type of issue before , connection limits maybe worth investigating bit of time in direction see if causes. if not open ticket ms support.
hths, goodluck.
edit: premium database raise limits on connections worth of investigation quick fix issue , potentially long run one.
Comments
Post a Comment