Prev: Database Queries with database views, that base on many database t
Next: Another Date conversion problem
From: someone on 10 Jun 2010 15:01 Hi, I noticed when deleting files in OS level(not related to database) caused application level data connection "time out". Is it related or I have IO problem? Please advice. Thanks.
From: Erland Sommarskog on 10 Jun 2010 16:31 (someone(a)js.com) writes: > I noticed when deleting files in OS level(not related to database) caused > application level data connection "time out". Is it related or I have IO > problem? Please advice. No the slightest idea. There is just too little information. On which machine are you deleting files? What kind of files? Many files? Big files? What times out? Queries? Connection attempts? -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
From: someone on 10 Jun 2010 17:35 Thanks Erland, is it a way to track client time out(connection timeout or operation time out, update, delete) events in sql log or DMV? "Erland Sommarskog" <esquel(a)sommarskog.se> wrote in message news:Xns9D93E50D81FF6Yazorman(a)127.0.0.1... > (someone(a)js.com) writes: > > I noticed when deleting files in OS level(not related to database) caused > > application level data connection "time out". Is it related or I have IO > > problem? Please advice. > > No the slightest idea. There is just too little information. On > which machine are you deleting files? What kind of files? Many files? > Big files? What times out? Queries? Connection attempts? > > > > -- > Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se > > Links for SQL Server Books Online: > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx > SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >
From: Erland Sommarskog on 10 Jun 2010 18:02
(someone(a)js.com) writes: > is it a way to track client time out(connection timeout or operation time > out, update, delete) events in sql log or DMV? You cannot track connection timeouts within SQL Server - since the client never logs in. Client timeouts on the other hand can be tracked by tracing for the event Error:Attention. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx |