Menu

Error while installing SqlServer on a ramdisk

bernard
2016-11-24
2016-11-25
  • bernard

    bernard - 2016-11-24

    Hello,
    For performance evaluation, i tried to install an SQL Server 2008 R2 on a ramdisk made with last version of ImDisk (https://sourceforge.net/projects/imdisk-toolkit/files/20161120/ImDiskTk-x64.exe) in Windows7 64bits.
    The SQL Server installation stops with an error about a handle that is not found.
    Any idea ?
    Thanks a lot !

     
  • v77

    v77 - 2016-11-24

    Perhaps your virtualization software requires to have the guest installed only on a volume handled by the disk manager.
    In this case, there is Arsenal Image Mounter, from the same author than the imdisk driver. Unlike imdisk that only creates simple volumes, it emulates full SCSI disks. Install the driver from here (requires .NET 4.0), and retrieve the command line tool here.

    aim_ll.exe has a syntax similar to imdisk.exe. For example, you can create a 2GB ramdisk with:
    aim_ll -a -s 2G
    A partition will be automatically created and a drive letter assigned to it.

     
  • bernard

    bernard - 2016-11-25

    Thanks a lot for your softwares, they are very useful. And thanks also for your fast answer !

    I managed to make a ramdisk with aim_ll, you may just add that the command line needs to be launched with admin rights :-) It was directly on the physical computer, not on a VM.
    After that, SQl server could be installed without problem, it was THE trick ! Thanks

    I may just add that the perf of ramdisk with aim_ll are divided by 2 compared to ImDisk ramdisk, from the point of view of a simple disk performance test. The full scsi emulation is taking its part :-)

    May i suggest to add inside ImDisk a simple function that prints the options of the command line that should be used to recreate the same ramdisk ? Just an idea to help command line usage !

     
    • v77

      v77 - 2016-11-25

      May i suggest to add inside ImDisk a simple function that prints the options of the command line that should be used to recreate the same ramdisk ? Just an idea to help command line usage !

      Do you mean with the RamDisk Configuration Tool? At the very beginning, RamDiskUI was indeed a simple "frontend" (see here). Now, it's far to be the case. Even with the use of imdisk.exe, mounting the ramdisk takes more than 200 lines of code (with a rather compact style). Services may need to be created or removed, RamDyn has its own command line and is started from inside a service, formatting may requires to create a temporary drive letter if a folder is used as mount point, and so on...
      So giving one or even several command lines would be very difficult.

      For AIM, currently the only GUI able to create ramdisks is this one, but it seems no longer maintained. That's why I suggested a command line.

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.