There are some recommended size for page file. I think it is one and a half time the total size of your RAM.

I am reaching that magic figure of 1000. But that does not mean I know anything. But I try to learn from reading the solutions to different problems others have...

Tara,

I misunderstood your question. I thought you were running it on two DB and not two clients. That is why I raised the Blocking issue and IO issue.

Are both clients...

Please use GSquareds idea. It is way more efficient than mine. I stand corrected. 🙂

Thanks Wayne.... And Thanks GSquared for clearing it up for me.. You put it better than how I could explain it. 🙂

You can always set up a Profiler Trace and write them into a table. You can then query the details from that table. That is the easiest thing that comes...

First you have to do couple of things...

1. Make sure you have updated the statistics on both the DB

2. Check the execution plan and see if there is a difference...

You can use windows Authentication. Just make sure that the user name that is created for the WebService matches the same username in the DB server and the password also...

Go through the article and set up a test db and show them the performance issues due to this. Or give them the article.

You could try to restore the DB and tell the snapshot agent not to initialize the data. That means no Snapshot. it works with transactional replication, But I dont know...

Replication is not the best way to go for DR plan. Especially if you have Identity Columns and TimeStamp columns. If your DB does not have those kind of things,...

Is this a Snapshot replication or Transactional Replication or Merge replication you are using? If it is Snapshot replication, I would say it is better not to use replication at...

Using the Object qualifier. Not just in Select statements but also when you are executing a Stored proc as well.

I did write an article regarding this[/url].

Calling attention to myself.......

What I would suggest is to try to set it up in a test environment with the UI and then Script all your Publications.

Then go through the script and...

Insert needs an Exclusive lock and the Select might be dead locking with this insert or vice versa... (Atleast that is what I know)