Prev: Energy Saving Tips
Next: cheap chanel bags
From: SmartbizAustralia on 4 Jul 2010 23:37

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?
From: Erland Sommarskog on 5 Jul 2010 04:26
SmartbizAustralia (tom(a)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(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

 | 
Pages: 1
Prev: Energy Saving Tips
Next: cheap chanel bags