I checked the explain plans.
Why would the update run from sql analyzer fine , but not from within the proc?
The problem is reproducable.
It happens every time.
It is definitely the 1 update in there that is causing the problem, because when I comment that...
I have a remote update that runs in under 1 second, hitting exactly on a clustered index on the remote table.
I read what the counter was before I posted this.
I am telling you that there is no way 43,000,000 transactions are started a day for our database.
Our sqlserver shows an average of 500/1000 transactions/sec .
Can anyone tell me what exactly this counter measures?
This number does not even seem...
max server memory (MB)4214748364780908090
min server memory (MB)0214748364780908090
set working set size0100
based on the above, we have sql...
I have been wrestling with very high page faults (20,000/sec) since migrating
from 32 bit to 64.
They look to be coming from the mssearch process,...
we are replicating data between 32 and 64 using procedures both ways.
Not full blown replication, though.
I have a similar setup and am getting very good performance while averaging 1000 transactions/second
you should be able to insert into both tables using the DTS.
If you don't like that route,
you could put an insert trigger on...
you can try something like this if you can map your tables to this format.
delete from productlogistics
where pingid in (select pingid
assuming you have a unique id column on the tables with colA in my example being the id column
insert into Database_A_Hist (colA, colB,...
database A supports ecommerce site with 200,000+ page views daily.
database B is central admin database where orders get fed into from the 3 frontend...
network packet size is 4096
could you guide me where to look for this ?
I use updates like this to keep data updated every night on certain tables across databases.
set A.description = b.description,...
Separate names with a comma.