question

David in Dakota avatar image
David in Dakota asked

Partitions and Replication

Our current database is using merge replication (with P2P). We have several tables that are heavily used on both servers and were considering data partitions that would keep data partitioned by the site/server it originated from. I am wondering if anyone has done data partitions on a replicated (P2P/Merge) sql server database and:

  1. Whether this offered benefits that outweighed the administrative costs.

  2. What issues, if any, popped up as a result.

replicationmergep2p
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

·
Fatherjack avatar image
Fatherjack answered

The databases are busy but are there performance issues? If not then it is got to be a well considered decision on whether the admin effort, down time and inherent risk involved are worth it. If the system is slow, do you know where the bottle neck is? Do you have the hardware to support the partitions to make best use of that configuration?

1 comment
10 |1200

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

As Fatherjack said, there are a lot of factors that go into whether data partitions are worth doing. http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx can give you a decent place to start in deciding.
0 Likes 0 ·

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.