Hardware issues for database mirroring

Hi guys, can I know for mirroring, is it both principal and mirror server's hardware spec needed to be same in order to best performance during mirroring? I am just curious about it. Thx.

Best Regards,

Hans

NO, they don't have to be

Although you might want them to be, as the mirror server should be capable enough to be your primary server when needed

Plus, you can set them up identically, or try different settings to see how performance changes

It's likd RAID, you don't necessarily need same brand, same model, same size HDDs, but people always recommends it

|||Also, depending on the version of SQL2005, only the enterprise edition supports "high-performance" in asynchronous mode for mirroring. The standard edition only supports synchronous - so a gigabit or fibre channel is recommended. The speed between servers should also be considered for best mirroring performance, depending on your situation.

Hardware configuration

Hi i'm doing mirroring on 2 servers

each has 6 disks.

what is the recommended configuration for each server?

Option 1: 2 disks (mirror) for OS and 4 disks (RAID5) for SQL

Option 2: 2 disks (mirror) for OS, 2 disks (mirror) for SQL & Data, 2 disks (mirror) for SQL Logs.

or maybe other suggestion ? maybe some logical partitions ... (TempDB ...)

thanks,

I'd say definitely option 2

every article I read suggests log/temp db on separate physical DRIVE (not partition) than data

|||

It is recommended that you separate log from data and other activities.

It all depends upon the throughput of your disks and the response requirements of your application.