{"id":3217,"date":"2009-07-20T21:03:08","date_gmt":"2009-07-20T19:03:08","guid":{"rendered":"http:\/\/www.glorf.it\/blog\/?p=3217"},"modified":"2009-07-20T21:03:08","modified_gmt":"2009-07-20T19:03:08","slug":"verschiedene-timeouts-bei-der-abfrageausfuehrung","status":"publish","type":"post","link":"http:\/\/www.glorf.it\/blog\/2009\/07\/20\/sql-talk\/sql-server\/verschiedene-timeouts-bei-der-abfrageausfuehrung","title":{"rendered":"verschiedene Timeouts bei der Abfrageausf&#252;hrung"},"content":{"rendered":"<p>Anl&#228;sslich einer aktuellen Frage fand ich dern Artikel &quot;<a href=\"http:\/\/vyaskn.tripod.com\/watch_your_timeouts.htm\">DBAs quick guide to timeouts &#8211; Watch your timeouts<\/a>&quot;. Hier werden die verschiedenen Time-Outs beschrieben, die bei der Ausf&#252;hrung einer SQL-Abfrage am SQL-Server auftreten k&#246;nnen:<\/p>\n<ul>\n<li>ASP Script Timeout<\/li>\n<li>COM+ Transaction Timeout<\/li>\n<li>ADO Connection Timeout<\/li>\n<li>ADO Command Timeout<\/li>\n<li>SQL \u2013 Query Governor cost limit reached<\/li>\n<li>SQL &#8211; Lock Timeout<\/li>\n<li>SQL \u2013 Query Wait<\/li>\n<\/ul>\n<p>Das fand ich richtig n&#252;tzlich.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anl&#228;sslich einer aktuellen Frage fand ich dern Artikel &quot;DBAs quick guide to timeouts &#8211; Watch your timeouts&quot;. Hier werden die verschiedenen Time-Outs beschrieben, die bei der Ausf&#252;hrung einer SQL-Abfrage am SQL-Server auftreten k&#246;nnen: ASP Script Timeout COM+ Transaction Timeout ADO Connection Timeout ADO Command Timeout SQL \u2013 Query Governor cost limit reached SQL &#8211; Lock [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[16],"tags":[535],"_links":{"self":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts\/3217"}],"collection":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/comments?post=3217"}],"version-history":[{"count":3,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts\/3217\/revisions"}],"predecessor-version":[{"id":3222,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/posts\/3217\/revisions\/3222"}],"wp:attachment":[{"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/media?parent=3217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/categories?post=3217"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.glorf.it\/blog\/wp-json\/wp\/v2\/tags?post=3217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}