Thanks for the reply.

There is a pool of app servers and there are also db servers connecting to it as well. It is pretty random as to which the...

Right. To snapshot in replication, even though the users dont get disconnected in a hard way, the tables in snapshot get dropped though for initialization.

I've tried initialization from backup...

Thanks, Jeff and Steve.

We are using standard edition right now. My manager is not quite willing to pay 4x the cost for enterprise, unless it is fully justified.

We...

Thanks for taking the time to reply to my post. I did a search before posting, unfortuantely I only got 4 instead of 90 links back and none of them...

Over the weekend, I set the max memory for sql at 13.5 GB. Paging increased (avg 200/sec) compared with max memory at 13GB (avg 20/sec). But still a lot less...

I actually set max memory for sql to 13GB, and have been seeing memory available on the server being 1.5GB, should I give more memory back to sql server?

That makes sense. I will try it. Thanks!

Yes, sql 2005 standard. The max memory for sql is set to be 14.5GB.

It is 64 bit, 16GB RAM.

I just found out that the vb application running on the server runs every minute and it opens and closes lots of connections to the db. I know its expensive...

To add to my thread, two counters I monitored yesterday:

buffer cache hit ratio -- between 95%-100%

sql buffer manager:page life expectancy-- 1800 seconds

neither of them seem to indicate a memory issue....

Also, I also made page file the same size as memory (16GB), half on one drive and half on the other drive.

Thanks! I think what you suggested might work. I will give it a try.

Currently in the asp code, its using two connection strings, one, which is used to select the records out of, and the other one, is used to do the insert...

Yes. openrowset is not ideal either.