1
vote
1answer
107 views

How to make clustered storage available from SAN to Hyper-V for two node cluster

I want to make a 2 node SQL Server 2012 cluster. Both nodes are virtual machines running Windows Server 2012 on Hyper-V. I have a physical SAN available which I can use for clustered storage so I was ...
5
votes
5answers
515 views

Using SAN Replication/Snapshots for SQL Server disaster recovery?

We have a web application that utilizes SQL Server 2008 on a single database server. All storage is local. For the past year we have been trying to get any form of SQL Server Replication to work ...
0
votes
1answer
81 views

Shared volume for data (multiple MDF) and another shared volume for logs (multiple LDF)

I have 3 instances of SQL Server 2008, each on different machines with multiple databases on each instance. I have 2 separate LUNS on my SAN for MDF and LDF files. The NDX and TempDB files run on the ...
3
votes
2answers
555 views

RAID10 volume write latency on Windows on ESXi 5

I have a VMware ESXi 5 environment running on Fujitsu BX922S2 blade servers, connecting to a Fujitsu DX90 SAN. I've had no problem with RAID5 volumes, but RAID10 volumes (for MSSQL) are exhibiting ...
2
votes
3answers
201 views

Replication or?

Recently, we have been hammered by Google Bots and all kinds of other bots( 60% of the website traffic that we experience on an average are from Bots. We are trying to segment out the Google Bot ...
4
votes
1answer
355 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 ...
4
votes
4answers
742 views

Should SQL Server MDF/LDF files always be on separate physical disks, even on databases that are barely used?

I'm trying to plan the SQL data and log file locations within a new SAN. I have a few databases that are hardly used at all. They are mainly metadata repositories for applications that run once or ...
0
votes
1answer
178 views

Can sql server scalable shared databases work with a vmware (ESX server) shared disc?

I've recently found out about sql server scalable shared database technology and I'd like to test it out in a vmware environment. Our production environment is SAN based but we don't have a test ...
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, ...
0
votes
1answer
300 views

Installing SQL Server on a VM (ESX) on a SAN

I've got a an ESX VM and the storage is provided by a decent SAN. On a physical server, I would ordinary install SQL Server across 3 drives; one for the OS + SQL, one for data, and a third for log ...
1
vote
7answers
3k views

Which SQL files benefit the most from RAID 10 vs RAID 5?

Assuming I can't put everything on RAID10, which parts of SQL (Data files, log files, TempDB, Backups, etc) benefit the most from being on RAID 10 instead of RAID5? Does it depend on the type of ...
0
votes
4answers
157 views

SQL Server: Shared disk cabinet performance

Our server admin has hatched a plan to move all storage to a central disk cabinet, and have every server use that. We have a central SQL Server that is heavily use (200+ concurrent users) and I am ...
2
votes
2answers
1k views

SQLServer Split Database File and FileGroups

I'm a software developer, but this month I've to do some db admin tasks. I've some knowledge gaps about how to split the database, here my first aproach: FileGroup for a tables FileGroup for a ...
0
votes
2answers
837 views

Splitting a shared pool of disks in a SAN into numerous LUNS

We use a dedicated HP EVA SAN to host the SQL backend for our application. I believe the disks are in a large shared pool (24 disks RAID10). The SAN is split into several LUNs which hold the SQL ...
1
vote
1answer
551 views

Benefit of Defragging SQL Server Data files located on a SAN

In the past, I have used contig.exe to remove physical fragmentation from SQL Server data files. They have always been on locally attached storage. Is there any benefit to running this on a data file ...
1
vote
4answers
606 views

SQL Server DR Strategies with virtualisation & multi sites

I'm looking for advice on the best HA/DR strategies for SQL Server. Currently I'm using Express edition with backups being copied over a the WAN to a remote site and being restored. The SQL Express ...
2
votes
3answers
614 views

What optimizations can be performed on SQL Server with SAN?

This question is a bit general since I am not exposed to SAN (Storage Area Network). Are there any optimizations or configuration changes that can be performed with SAN to improve SQL Server ...
32
votes
5answers
1k views

Pay no attention to that SAN behind the curtain

Once upon a time, I built my own SQL servers, and had control over drive configuration, RAID levels, etc. The traditional advice of separation of data, logs, tempdb, backups, (depending on budget!) ...
3
votes
3answers
6k views

How does the LeftHand SAN perform in a Production environment?

I previously asked this ServerFault question: Does anyone have experience with lefthands VSA SAN The general consensus looks like it does not perform well enough for a production SQL server even at ...
0
votes
3answers
508 views

Why is SQL Server slow on IBM Shark hardware

I have a performance problem with a SQL Server data warehouse solution on a blade connected to an IBM Shark. Disk I/O performance seems to be pathologically slow with excessive page latch wait times. ...
25
votes
7answers
7k views

SQL Server disk design on an ISCSI SAN

Its standard practice to separate log and data files to separate disks away from the OS (tempdb, backups and swap file also) Does this logic still make sense when your drives are all SAN based and ...