MS SQL Server - Table update issue

Author

Table update issue

cyrstalclear

2006-12-12, 5:17 am

Hi,
We are running Sql Server 2005 SP1 on a windows 2003 server. The
server has quad processor with 8 GB ram. We have also enabled the 3 GB
switch on the windows. This server is also running Veritas backup with
its own sql express instance.

We have currently 6 databases that are running on this instance. Each
of these database are identical only diff being that they are used for
different clients. each one of the databases are enabled for merge
replication.

We are facing a typical issue with 2 of the databases on a table which
is under replication. No of records is maximum of 400 in this table.
But a normal update/delete statement on this table takes around 45 secs
to execute. the same setup except the veritas backup on a much lower
configuration does not give this problem.

We are not able to lock down on the problem, any inputs on the same
would be appreciated.

Thanks and Regards,
Santosh

cyrstalclear

2006-12-12, 5:17 am

Hi,
Further investigation in to the issues, we have found the probelm
seems to be the replication on that table. When we disable the
replication and excute the same query it excutes within secs. So we
believe the triggers created by the replication are causing some
problem. Intersting point to note is that once we enable the
replication the perfomane degradation does not happen immediately

Thanks and Regards,
Santosh

cyrstalclear wrote:
> Hi,
> We are running Sql Server 2005 SP1 on a windows 2003 server. The
> server has quad processor with 8 GB ram. We have also enabled the 3 GB
> switch on the windows. This server is also running Veritas backup with
> its own sql express instance.
>
> We have currently 6 databases that are running on this instance. Each
> of these database are identical only diff being that they are used for
> different clients. each one of the databases are enabled for merge
> replication.
>
> We are facing a typical issue with 2 of the databases on a table which
> is under replication. No of records is maximum of 400 in this table.
> But a normal update/delete statement on this table takes around 45 secs
> to execute. the same setup except the veritas backup on a much lower
> configuration does not give this problem.
>
> We are not able to lock down on the problem, any inputs on the same
> would be appreciated.
>
> Thanks and Regards,
> Santosh

Sponsored Links