Short for 'Storage Area Network', a SAN is a network for block level storage. One or more controllers present logical drives (called LUNs) to one or more hosts through a switched fabric.

learn more… | top users | synonyms

2
votes
0answers
72 views

What is the ideal disk allocation size using our Nimble SAN?

I have seen many recommendations to use 64K disk allocation size for data drives such as from the SQL Server Setup Checklist on BrentOzar.com. The best practice guide for using our Nimble SAN with ...
1
vote
0answers
46 views

ms/write on tempdb data files are dead slow

I don't know why writes on my tempdb data files are extremely slow. ms/write on each of the tempdb data files reaches to more than 800 ms!!! that's even after I moved the 8 equally sized (7GB) tempdb ...
1
vote
0answers
30 views

Is it possible to query the avg time in ms per read/write

I was wondering if it was possible to obtain the avg block read and avg block write in ms with a query in SQL Server. If SQL Server knows how many IO requests are made for a given wait type and how ...
0
votes
0answers
21 views

Combining SQL Failover cluster with availability groups and SAN replication

We are looking at implementing the following Windows cluster containing 4 node FCI (2 nodes per data centre) with SAN replication - our current setup. manual failover (storage first then SQL resource)...
0
votes
0answers
32 views

Correlating Disk Latency on Application side Vs. EMC SAN

Our OLTP databases have encountered several I/O issues. During those events: Avg disk sec read on the data file was 0.2 second or higher We found windows eventlog entries stating: "SQL Server has ...
0
votes
0answers
66 views

VM SQL Data and Log drives have one Block Size, SAN another. Issues?

Setting up a new SQL VM. What happens if VM data and log drives have 64K (recommended) block size but SAN (IBM DS3500 Express) was configured with a different block size? I want to avoid IO issues ...