Try this:

UPDATE mytable SET A-NAME = CASE WHEN A-ID IS NULL THEN NULL ELSE A-NAME end,

...

Actually I stopped the Log shipping Backup job and also I disable the replication jobs but still every 10 minutes,slowness happens on SQL statments that run against SQL SERVER.It...

I checked and we do not have any SQL job on this machine.But this server act as a Publisher in Transactional Replication and there is a Job on distributor(which is...

Also,I notice this slowness happens every 10 minutes.

Do we have any indicator for Blocking?

Thanks for Replys.

This is dedicated Server for SQL SERVER and we do not have any other process on this machine.Also we have Transaction replication(The problematic machine acts as Publisher).

I attached the image that is more readable.

This is our wait list after running the script:

WaitType ...

Thanks for the script,should I run this after we ran our batch(that try to insert 1000 -2000 rows) or I should run them at the same time.

In our production environment(SQL SERVER 2008 R2) We have transactional replication,Recently we have added a process that try to insert large number of Records(1000-3000)in 2-3 second.When I run the profiler,I...

Is Batch Requests/Sec another counter in Performance monitor?where can I get that?

In may case the Insert itself is very fast,just after insert sometimes there is a delay from 10-400ms.

On weekend we have scheduled job that defragment all the Indexes.

For a table which has 40,000,000 rows ,we are trying to insert 3000 rows in a loop.

I copied the backup of production database to my local machine and ran the sql process(Having loop,which inside the loop we have that insert statment), and it ran pretty fast.The...

Thanks for your reply.

All the sql statments in SP runs very fast(0 ms).In SP I have two insert statment that these two also run fast ,but sometimes after their execution...

wtype wcounttotal_timesignal_time

NETWORK_IO 18 ...