0
votes
0answers
54 views

Identical tables, different sizes?

I have transactional replication with updatable subscriptions going between a few SQL 2008 R2 servers (publisher is Enterprise, subscribers are Express). I need to add another subscriber, and come to ...
2
votes
1answer
52 views

Consolidating SQL Server

We have a number of SQL Server 2008 R2 standard servers, each for a single application that we'd like to consolidate into one physical server. Running perfmon on these servers they're not using a ...
0
votes
2answers
302 views

Is it possible to set up multiple named instances running on a SQl Server 2008 R2 Active/Passive Cluster?

I'm trying to plan a SQL Server 2008 R2 2 node Active/Passive failover cluster. Is it possible to set up multiple named instances running on the cluster? e.g. sqlcluster sqlcluster\demo ...
4
votes
1answer
357 views

SAN device storage config for SQL 2008 cluster

Windows Server 2008 R2 (clustered active/passive) - SQL Server 2008 Enterprise - Dell MD3200i PowerVault SAN 8 x 450GB 15k SAS drives (RAID 10) What is the best stripe unit size for this ...
0
votes
0answers
110 views

SAN device storage config for SQL 2008 cluster

Windows Server 2008 R2 (clustered active/passive) - SQL Server 2008 Enterprise - Dell MD3200i PowerVault SAN 8 x 450GB 15k SAS drives (RAID 10) What is the best stripe unit size for this ...
0
votes
3answers
2k views

Failover clustering: tempdb on SAN?

We are considering clustering our SQL Server 2008 EE instances. The storage is on SAN. Can we put tempdb data/log files on SAN? What are the pros and cons on this solution? For optimal performance, ...