Database Snapshots of Mirrored databases affect performance of Principal database?
- by yrushka
I have 2 servers set in Mirroring High-safety. One is Principal and another in Mirror.
Currently I have 2 snapshots of a Production database (100 GB size) created on Principal server (for no_lock purpose of massive select processes) and 2 snapshots on the mirror server for the same database for reporting purposes.
I know snapshots reduce performance of source databases but I am not sure if snapshots from mirror server have any impact on principal server's performance.
thanks,