Questions tagged [san]
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.
54 questions
2
votes
1
answer
264
views
What disaster recovery solutions are available if my storage already does the replication?
The Business continuity and database recovery documentation lists all of the methods of disaster recovery in SQL Server. At a skim, I see the following Windows options:
Availability groups
Database ...
- 1,488
0
votes
0
answers
662
views
SQL Server and drive formatting (block size)
We are having major performance and latency issues with SQL Server 2019.
We are running on a "quiet" VMware instance connected to a vSAN.
According to MSFT documentation, best performance is ...
- 1
-2
votes
1
answer
1k
views
In a SAN based SQL server, where does the 64K allocation block size formatting need to occur?
I understand sql data and log file drive must be formatted 64K allocation block size.
In a SAN environment, there are physical disks which are part of the SAN storage pool; and from the storage pool ...
- 3,617
0
votes
1
answer
143
views
Db file and transaction log segregation in SAN
I understand that if we are using HDD then it will be advisable to store the data file and transaction log on different drives (which point to different disks).
However, if the server is using SAN, ...
-1
votes
2
answers
75
views
How is SQL Sever able to improve the performance using partitioned tables in a SAN storage environment?
Link: https://learn.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver15#:~:text=SQL%20Server%20supports%20table%20and,are%20mapped%20into%...
- 3,617
1
vote
0
answers
100
views
Is the recommendation to have different files on separate disks valid for SQL server in a SAN (RAID) network?
Link: https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-files-and-filegroups?view=sql-server-ver15#Recommendations
To maximize performance, create files or filegroups on ...
- 3,617
0
votes
1
answer
63
views
Whether there is any benefit of separating data/log files, setting fill factor, index rebuild/reorganize in a SAN storage?
Let's assume that my storage is a SAN. This means it contains multiple disks. Even though we have logical drives configured, essentially everything - including the OS, SQL Server, and applications - ...
- 3,617
1
vote
1
answer
294
views
Performance of temp db files on SAN
It is generally recommended to put the tempdb database on disks that differ from those that are used by user databases.
I have 4 databases on my sql server, ranging from 5GB to 300GB in size.
D: drive ...
- 3,617
0
votes
2
answers
224
views
MS SQL: SSD Trim after TRUNCATE / DROP?
I consider to use one of those fancy new SSD-only SAN systems for our new Microsoft SQL Server. "Fancy" means, that it supports / use stuff as block compression / deduplication / 0x00-...
- 885
0
votes
2
answers
1k
views
Why is it not important whether data and log files share the same disk or not in a SAN? [closed]
I have a hard disk. I create 3 drives on it. One for OS. One for sql data files. One for sql log files.
However I am reading that suppose my storage layer is not a hard disk, but a SAN based ...
- 3,617
2
votes
1
answer
156
views
Restore from local disk vs SAN on physical machine (SQL Server Linux)
I am new to Linux and our client decided to use SQL Server on Linux. As soon as we started testing, we ran into performance issues.
The server in question is a physical machine configured with a SSD ...
- 171
-1
votes
1
answer
105
views
RAID 0 for development [closed]
in your experiences does of real world testing of RAID5 come "close" or "far" behind RAID0 in terms of performance as the underlying storage for a heavy write OLTP workload? Please ...
2
votes
3
answers
1k
views
Will SQL Server go offline if it loses network connectivity to SAN where master and msdb system databases reside?
I have a setup where 3 servers combined into Availability Group
All 3 servers have local directly attached SSD drives, and user database files are hosted on these drives
But the system databases (...
- 6,290
6
votes
2
answers
4k
views
Slow checkpoint and 15 second I/O warnings on flash storage
Last couple of weeks we've been working on getting to the root cause of what could likely be the cause of the occurrence of these I/O issues and slowdown of the checkpoints.
At first glance it looks ...
- 507
0
votes
1
answer
214
views
Flash storage and auto-grow
Our databases files (data and log) of (a lot of) SQL Servers are hosted on flash storage (SAN), what would you use as auto-grow property for databases having size round 500GB (data) and 150Gb (log)?
...
- 33