question

Elysian avatar image
Elysian asked

Please help me to configure replication

We have a database of around 500 GB, now our client has decided to configure Transnational Replication. They have asked to determine total load on SQL server database and let them know the configuration of new SQL server(which will become subscriber). And based on this load we are going to decide how many load will be transfer to subscriber.

Please help me, how to find this load

replicationsql server 2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

You could try monitoring the performance counter SQLServer:SQL Statistics - Batch Requests/sec as this will give a general indication of the amount of workload that the server is being asked to do.
You may also need to tie it up with SQLServer:Databases - Transactions/sec to see which databases are then the busiest.

But neither of these give you a indication of how the resources are being used, so you'd also need to look at memory and CPU.

If you are wanting to move some workload to a replicated server, you'll also need to identify how you can define the boundaries between those workloads - is it certain customers, certain databases, certain functions - and then take that and map it onto the information from above.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.