<div dir="ltr"><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-kerning:none">The AAF has a subscriber with a 4 node IdP cluster (v3.3.1) connected to a Microsoft SQL server database (also clustered - MS SQL Server 2012). We're hoping to get advice on a problem that has occurred under increased load due to start of semester usage.</span></div><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal;min-height:14px"><span style="font-kerning:none"></span><br></div><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-kerning:none">All IdP instances are reporting "Transaction (Process ID 165) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.". These errors result in failed authentications ("Process ID X" values do differ, it is not always 165).</span></div><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal;min-height:14px"><span style="font-kerning:none"></span><br></div><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-kerning:none">Having troubleshooted this issue we believe the error is related to the eduPersonTargetedID attribute which is obtained through a "StoredId data connector". This connects to the database using a Container Managed Connection. Changing the method to obtain the value to "ComputedId" has allowed the IdPs to successfully manage the load as an interim solution, i.e. no more deadlocks. </span></div><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal;min-height:14px"><span style="font-kerning:none"></span><br></div><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-kerning:none">During this time PersistentNameIDGeneration remained enabled but only a minimal amount of services are requesting this, thus the increased load is not such a factor here.</span></div><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal;min-height:14px"><span style="font-kerning:none"></span><br></div><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-kerning:none">Any advice from administrators that may have a similar deployment on fine tuning configurations to both eliminate deadlocks and reinstating the "StoredId data connector" would be very helpful.</span></div><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-kerning:none"><br></span></div><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-kerning:none">Thanks,</span></div><div style="color:rgb(33,33,33);font-size:13px;margin:0px;font-stretch:normal;line-height:normal"><span style="font-kerning:none">Terry.</span></div></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><p class="MsoNormal"><b style="font-family:sans-serif"><span style="font-size:8pt;font-family:Arial,sans-serif;color:rgb(227,108,10)">Terry Smith</span></b><span style="font-family:Arial,sans-serif;font-size:8pt;color:rgb(126,126,126)"> </span><font color="#808080" face="Arial, sans-serif"><span style="font-size:8pt">| </span><span style="font-size:10.6667px">Technical Engagement and Support Manager </span><span style="font-size:8pt">|  Australian Access Federation Inc</span></font></p><p class="MsoNormal" style="font-family:sans-serif"><span style="font-size:8pt;font-family:Arial,sans-serif;color:gray"><b>Mob: </b><a href="tel:0402%20918%20566" value="+61402918566" target="_blank">0414 692 424</a> | <b>Email</b></span><b><span style="font-size:8pt;font-family:Arial,sans-serif;color:rgb(79,98,40)">: t.smith</span></b><a href="mailto:elleina.filippi@aaf.edu.au" target="_blank"><span style="font-size:8pt;font-family:Arial,sans-serif">@aaf.edu.au</span></a><span style="font-size:8pt;font-family:Arial,sans-serif;color:gray"> | <b>Address</b>: </span><span lang="EN-US" style="font-size:7.5pt;font-family:Arial,sans-serif;color:gray"><a href="https://maps.google.com/?q=Lvl+21,+179+Turbot+St,+Brisbane+QLD+4000&entry=gmail&source=g">Lvl 21, 179 Turbot St, Brisbane QLD 4000</a> |</span></p><p class="MsoNormal" style="font-family:sans-serif"><b><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:gray">Web:</span></b><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:gray"> </span><a href="http://www.aaf.edu.au/" target="_blank"><span style="font-size:7.5pt;font-family:Arial,sans-serif">www.aaf.edu.au</span></a><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(54,95,145)"> |</span><b><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:gray"> Support:</span></b><b><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(54,95,145)"> </span></b><a href="http://support.aaf.edu.au/" target="_blank"><span style="font-size:7.5pt;font-family:Arial,sans-serif">support.aaf.edu.au</span></a><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(54,95,145)"> </span><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:gray">|</span><span style="color:gray"> </span><b><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:gray">Twitter:</span></b><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:gray"> </span><span style="font-size:7.5pt;font-family:Arial,sans-serif"><a href="http://twitter.com/ausaccessfed" target="_blank">twitter.com/ausaccessfed</a></span></p></div></div>