-
Replication(Preparation) in Sql Server 2000
Morning Guys,
If one was preparing to Replicate a database and need to know how much more size would be needed to accomadate the distribution database and its transaction logs etc... what performance counters would you set to gather this information and or tools...?
How to go about finding the average tranaction size.... number of transactions per day.... via profiler.... perfmon....
any suggestions or good sites for replication would be greatly appreciated...
thanks,
thanks,
Jonathan Marshall
-
You can get number of transactions in perfmon, may need check your apps for transaction size. By the way, sql saves sql statements to apply on subscriber in distribution db. It doesn't take much space.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|