90ae5287   
   From: esquel@sommarskog.se   
      
   SmartbizAustralia (tom@smartbiz.com.au) writes:   
   > One of my clients is getting locking on a very small, but regularly   
   > updated table.   
   > Funny enough this uses stored procs all the way to read from or delete/   
   > insert into.   
   > So the total number of rows in this table will be anywhere between 10   
   > to 50 at any time.   
   >   
   > It seems to happen when FalconStor Snapshot agent is running.   
   >   
   > The client runs this every 2 hours on all their databases. Most having   
   > much larger tables.   
   >   
   > Could it be that this database is in simple recovery mode or the way   
   > the FalconStor is configured? Having no experience of this   
   > product...wondering if anyone else has had any experience?   
      
   Nor I have head of FalconStor Snapshot agent, but it seems to me that   
   using Profiler to see what this guy is up to is a good start.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)