Transactional Replication Impact on CPU performance

0

Hi All,

We are referring the below mentioned native import export backup and transactional replication for on prem to RDS data migration. https://aws.amazon.com/blogs/database/part-3-migrating-to-amazon-rds-for-sql-server-using-transactional-replication-with-native-backup-and-restore/

Here we are creating Transactional replication only (No snapshot), so we want to know how it will impact on Prod database CPU utilization.

Consider before transactional replication CPU utilization is 50% in prod, and now consider if we setup transactional replication then how will it impact on cpu utilization.

1개 답변
0

Hi,

I understand you want to know the impact transaction replication will have on the CPU utalization.

Kindly note that the CPUUtalization depends on the following factors:

  • The amount of Load on the source database.

This is the amount of load of the On-Premises database that you are planning on moving to the AWS RDS (Target), the cpuutilization is dependent on the load, therefore if your load gets higher, so will your cpu.

  • The number of transactional replication client that you create.

It is best practice to reduce load on the source database when exporting data from SQL Server databases.

After the migration has completed and you are still experiencing a very high irregular CPUUtilization, you can refer to RDS documentations for troubleshooting (Please take note of the engine types and refer to the documentation of the relevant engine).

I hope this helps.

Resources:-

[1] Importing and exporting SQL Server databases using native backup and restore: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html#SQLServer.Procedural.Importing.Native.Using.Restore

답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인