Place data on another drive

  • Edvard Korsbæk

    SSCertifiable

    Points: 5808

    Hi all!

    I have had to  change from my good old dependable server to a local laptop.

    That gives some big challenges...

     

    One of my databases is app. 2GB, and that just cannot be on a laptop harddisk - At least not mine.

    In comes my Synology drives, 2 X 8 TB

     

    But how to set it up, to be able to use a not local drive.

     

    Just a link to the help would be great.

     

    Best regards

     

    Edvard Korsbæk

  • MVDBA (Mike Vessey)

    SSC-Insane

    Points: 21757

    as far as i'm aware it's possible

    https://ask.sqlservercentral.com/questions/33733/ms-sql-server-install-on-external-hard-drive-usb.html

    just don't expect it to be fast

    MVDBA

  • DinoRS

    SSCrazy

    Points: 2640

    Yeah definitely possible but you need to map a drive from your synology to your laptop first, afterwards you can use this drive for your DB. And as MVDBA pointed out it will be far from fast, network traffic usually clogs up one core and that's it I/O wise, an exception would be RDMA based access to a volume but that's unlikely from either Laptop and Synology side possible. If you can use big frames (> 8k Frame Size) that will lower your CPU usage on network traffic but it's not a magic wizard either.

    Not sure if you can use a shared folder from your Synology or if you'd have to map an iSCSI drive, most likely the latter will be necessary.

  • MVDBA (Mike Vessey)

    SSC-Insane

    Points: 21757

    DinoRS wrote:

    Yeah definitely possible but you need to map a drive from your synology to your laptop first, afterwards you can use this drive for your DB. And as MVDBA pointed out it will be far from fast, network traffic usually clogs up one core and that's it I/O wise, an exception would be RDMA based access to a volume but that's unlikely from either Laptop and Synology side possible. If you can use big frames (> 8k Frame Size) that will lower your CPU usage on network traffic but it's not a magic wizard either.

    Not sure if you can use a shared folder from your Synology or if you'd have to map an iSCSI drive, most likely the latter will be necessary.

    that would be an interesting read for an article, a lot of us don't know about RDMA and frame sizes... me personally I specialise in code.. but I like to learn.

    and this site always needs new articles

    MVDBA

  • DinoRS

    SSCrazy

    Points: 2640

    Well the issue with RDMA is you need specialized hardware in order to be able to use it (SFP+ / Infiniband cards capable of RDMA). I can see if I can get some cards and do some comparisons against iSCSI but that would be a timeline of a month or two before I'd have any readable results in. NFS would be a comparison for a later point in time as I don't have enough hosts for that available right now.

    Yes, I do feel limped being stuck to my 128 GB Desktop right now but the local storage should be good enough for iSCSI / RDMA comparison 😉

    If there is some interest I'll be happy to come up with something to read about.

    Usually I have things in place but my personal datacenter is being rebuilt at a different site so all my usual gear (and upgrades I've ordered at the same time, ofcourse!) is kinda offline right now.

  • Eddie Wuerch

    SSChampion

    Points: 12375

    Synology NAS devices support creating and exposing iSCSI LUNs, allowing you to map a local drive or mount a folder to the storage on the device. I have a little 4x2.5"one I bought many years ago I still use for clusters and databases in my home lab.

    [On the Synology device]

    Log in to DSM on the device and open 'iSCSI manager' from the menu (click the button on the top left).

    Create a new Target and a LUN large enough for your database files.

    [On your laptop]

    Hit Start, type 'iscsi',  and open the iSCSI Initiator app.

    If you get a message box reading 'The iSCSI Initiator service is not running..', choose 'Yes' and continue. When the iSCSI Initiator app starts, enter the IP address of the Synology device in the Target box and choose Quick Connect. Select the LUN you created and click 'Connect'.

    Open Disk Manager (Either [WindowsKey] + [x] then [k], or hit Start, type 'disk manag', and select 'Create and format hard disk partitions'). You can initialize and format the LUN you mounted as a hard drive there.

     

    Eddie Wuerch
    MCM: SQL

  • DinoRS

    SSCrazy

    Points: 2640

    Just for clarification: I wasn't questioning wether Synology can do iSCSI but I'm not sure if and how they've implemented SMB3 so you could use a Network Share (paired with an Emulex / Chelsio SFP+ Card which brings in RMDA) to host your SQL DB. I know my QNAP does miss some things from SMB3 to be able to use a Network Share for such things.

  • Lindsay

    Newbie

    Points: 9

    Move your libraries to a 2nd drive or partition

    Right-click the My Documents or Documents folder. Select Properties.

    Click the Location tab.

    Click the Move button.

    In the ensuing dialog box, go to your title folder in pressure D:, create a new folder internal it called files , and choose that.

    After you click OK, click Yes to cross your files.

    Then wait.

  • Edvard Korsbæk

    SSCertifiable

    Points: 5808

    Eddie Wuerch - Thanks for your help.

    Unfortunately my Synology is too cheap to support iSCSI.

     

    Its cheaper to get a bigger harddisk.

     

    Best regards

     

    Edvard

     

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply