http://community.ugiss.org/blogs/sgovoni/archive/tags/Concurrency/default.aspxTags: ConcurrencyitCommunityServer 2007 SP2 (Debug Build: 20611.960)http://community.ugiss.org/blogs/sgovoni/archive/2011/03/01/from-sqlcat-concurrency-series-blog-posts.aspxTue, 01 Mar 2011 21:53:00 GMT696bf4df-f0eb-4942-9326-ff40615b13e5:8086sgovoni0http://community.ugiss.org/blogs/sgovoni/rsscomments.aspx?PostID=8086http://community.ugiss.org/blogs/sgovoni/commentapi.aspx?PostID=8086http://community.ugiss.org/blogs/sgovoni/archive/2011/03/01/from-sqlcat-concurrency-series-blog-posts.aspx#comments<p>Sunil Agarwal (Principal Program Manager in SQL Server Storage Engine Group) ha pubblicato, nel <a href="http://blogs.msdn.com/b/sqlcat/" target="_blank">blog SQLCAT</a>, alcuni interessanti articoli dedicati alla <a href="http://technet.microsoft.com/it-it/library/ms171845(SQL.90).aspx" target="_blank">Concorrenza</a> ovvero alla possibilità per più utenti di accedere ai dati contemporaneamente.</p> <p>La serie inizia con un post che spiega i diversi livelli di isolamento che una transazione può avere… fino ad arrivare ad una delle domande più comuni che formulano i clienti: La mia applicazione, fino a ieri aveva performance accettabili, oggi non più, perché ? Quale può essere il motivo ?</p> <p>Nell’ordine:</p> <p><a href="http://blogs.msdn.com/b/sqlcat/archive/2011/02/20/concurrency-series-basics-of-transaction-isolation-levels.aspx" target="_blank">Concurrency Series: Basics of Transaction Isolation Levels</a> </p> <p><a href="http://blogs.msdn.com/b/sqlcat/archive/2011/02/20/concurrency-series-why-do-i-get-blocking-when-i-use-read-uncommitted-isolation-level-or-use-nolock-hint.aspx" target="_blank">Concurrency Series: Why do I get blocking when I use Read Uncommitted isolation level or use NOLOCK hint?</a> </p> <p><a href="http://blogs.msdn.com/b/sqlcat/archive/2011/02/20/concurrency-series-why-do-i-get-block-when-no-one-has-locked-the-row-s-being-queried.aspx" target="_blank">Concurrency Series: Why do I get blocked when no one has locked the row(s) being queried?</a> </p> <p><a href="http://blogs.msdn.com/b/sqlcat/archive/2011/02/20/concurrency-series-minimizing-blocking-between-updaters.aspx" target="_blank">Concurrency Series: Minimizing blocking between updaters</a> </p> <p><a href="http://blogs.msdn.com/b/sqlcat/archive/2011/02/20/concurrency-series-my-application-was-running-fine-yesterday-buy-why-is-it-blocking-today.aspx" target="_blank">Concurrency Series: My application was running fine yesterday but why is it blocking today?</a> </p> <p>&nbsp;</p> <p>Buona lettura, in concorrenza <img src="http://community.ugiss.org/emoticons/emotion-1.gif" alt="Smile" />.</p><img src="http://community.ugiss.org/aggbug.aspx?PostID=8086" width="1" height="1">SQL ServerFAQLinksConcurrencySQLCAT