I have a requirement here to replicate one of the database to SQL Server 2008 to offload the reporting users.
We have W2k3 server (publisher) with 2 processors( 4 core each ), RAM -8 GB, D Drive - 836 GB (Local).
SQL Server 2008 (publisher) : only 1 database--- Size-100GB, Memory - 1GB to 6 GB(Max) and mdf, ldf ,tempdb are on the same drive.
we want to do transaction replication (Push) on this database. I want to know how should we approach this if we want to use the same Server as Distributor also.
I mean for best result do we need to separate the Ldf and mdf. Is it possible to add more drive because existing drives are local to server.
As i Said it's most busiest database. Will making it distributor affect the performance of the App ? How replication going to affect the performance of the database ?