Amin El-Zein
asked on
nas or san storage
Hello,
I have archiving system with 100tb that is work with mssql
I have hp g10 with 2x 500gb ssd harddisk that is work with Hyper-V and sql server will install on vm that it will be on storage
we plan to get a storage. the storage will have ssd hard disk for Hight performance or sas regarding the cost
the san with ssd from hp will be so much so we planed to work with qnap nas storage
do you agree with that ?
thanks.
I have archiving system with 100tb that is work with mssql
I have hp g10 with 2x 500gb ssd harddisk that is work with Hyper-V and sql server will install on vm that it will be on storage
we plan to get a storage. the storage will have ssd hard disk for Hight performance or sas regarding the cost
the san with ssd from hp will be so much so we planed to work with qnap nas storage
do you agree with that ?
thanks.
Main question, is the archive f files that are catalogued in mssql.
Mssql can not work on nas based storage usually.
San can function as nas for select purposes.
San presents storage resources. To systems via FC or iscsi as a local resource.
Only one system can access such LUNs at one time.
Direct attached storage (DAS) might be what ..
San is expandable in many cases.
Mssql can not work on nas based storage usually.
San can function as nas for select purposes.
San presents storage resources. To systems via FC or iscsi as a local resource.
Only one system can access such LUNs at one time.
Direct attached storage (DAS) might be what ..
San is expandable in many cases.
ASKER
Hello,
san with ssd It will be cost so much
the sql will work as vm as I told so I will use nas with iscsi.
the suggest nas from qnap is:
https://www.qnap.com/en/product/ts-2483xu-rp
https://www.qnap.com/en/product/tes-3085u
so what do you think ?
or just using san with sas ?
thanks.
san with ssd It will be cost so much
the sql will work as vm as I told so I will use nas with iscsi.
the suggest nas from qnap is:
https://www.qnap.com/en/product/ts-2483xu-rp
https://www.qnap.com/en/product/tes-3085u
so what do you think ?
or just using san with sas ?
thanks.
So you have 1 Server and need 100TB
If thats what you need you do not need a SAN (or a NAS ) just the ability to attach enough Disks to your server!
If you need High Availability, then yes you need a SAN, for two servers a SAS based one should be sufficient - but make sure it isnt a SPoF, so dual controllers, dual power (from different circuits) and RAID-6 or RAID10
If thats what you need you do not need a SAN (or a NAS ) just the ability to attach enough Disks to your server!
If you need High Availability, then yes you need a SAN, for two servers a SAS based one should be sufficient - but make sure it isnt a SPoF, so dual controllers, dual power (from different circuits) and RAID-6 or RAID10
ASKER
Hello,
as I mention I should have very highe performance and data access.
I will have a server with winows 2016 and vm for msql , data,dc
all vm will placed on san or nas.
nas or san will connect through the ducal controller to server to get 20gb bandwidth
raid will be raid0
does windows iscsi can read 100tb hard disk?
thanks.
as I mention I should have very highe performance and data access.
I will have a server with winows 2016 and vm for msql , data,dc
all vm will placed on san or nas.
nas or san will connect through the ducal controller to server to get 20gb bandwidth
raid will be raid0
does windows iscsi can read 100tb hard disk?
thanks.
RAID 0 provides absolutely no redundancy, a single failure results in total data loss.
RAID 6 or raid 10 provides tolerance for two failures.
RAID 6 or raid 10 provides tolerance for two failures.
ASKER
wich is better in my case raid 10 or raid 1
whats a bout iscsi limitation can i make disk volume with 100tb ?
whats a bout iscsi limitation can i make disk volume with 100tb ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
so what do you suggest for my case make the vhd that have a system on raid 1 and the vhd the contain the files or mdf files of mssql on raid 6 ?
thanks.
thanks.
As i said before a single server will be the Single Point of Failure (SPoF) if you want high availability you will need at least 2 servers
If you only have One Server you do not need the complexity of a SAN or NAS, just add disks to the server
Oh and please be aware that consumer disk are typically only rated at 70% duty cycles, not 24/7
If you only have One Server you do not need the complexity of a SAN or NAS, just add disks to the server
Oh and please be aware that consumer disk are typically only rated at 70% duty cycles, not 24/7
not sure what type of data you have in 100 TB
which g10 HP system do you have how many available do you have?
Which type of raid controller does your system have?
at 14Tb per disk (non-ssd) raid 1 for OS, 8 disk for data.
What confuses me is your reference to MS SQL, which means it is best to have a RAID 10 if all the data is databases
Server is "fairly" easier to replace than the data
Though with such large data quantity, a backup process/system must exist even with redundancies, things fail. (people) erroneously deleting the wrong thing, dropping the wrong table, making changes to the wrong data......
which g10 HP system do you have how many available do you have?
Which type of raid controller does your system have?
at 14Tb per disk (non-ssd) raid 1 for OS, 8 disk for data.
What confuses me is your reference to MS SQL, which means it is best to have a RAID 10 if all the data is databases
Server is "fairly" easier to replace than the data
Though with such large data quantity, a backup process/system must exist even with redundancies, things fail. (people) erroneously deleting the wrong thing, dropping the wrong table, making changes to the wrong data......
when the storage is used for backup and archive data you can you a san.
when you're running servers with connected drives to storage with sql server then use a san, better performance and reliability on you're
data