CPU was at 100% and memory
was at 97% before Replication was turned on.
The users was the data refreshed within seconds.:w00t:
So the Server needs beefed up.
Thanks for your advice.
Have a good day.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/