I'm new to replication, as I've been mostly an old school ETL type person. I have a SQL SERVER database that runs a front end web presence. There's alot of data there.
I have been tasked to perform analytics on the web database. However, in order to do so, I must send an extreme number of queries to the database. This is making the db sluggish.
WHen speaking with another analyst about my problem, they stated that in the past they solved this by creating another instance on another server and set replication so I can use the Replication database and not put the pressure on the web instance.
My question is the type of replication. When researching types of replication, I see Transactional, Merge, etc....
Is there a specific type of replication that I need for this case? If I know what I'm hunting for, I can get the steps from there.