locked
StorSimple for SQL server RRS feed

  • Question

  • Dear all,

    I would like to move all the data files and log files from an on premise SQL to a StorSimple storage.

    There will be any problem in performance?

    Could I take backups (local and clous) and clones from StorSimple?

    Wednesday, April 27, 2016 11:41 AM

All replies

  • Hi,

    If you plan to use the latest hardware Storsimple appliance, it should be ok if your database is not too big and if its IOPS demands is normal

    Source: https://blogs.technet.microsoft.com/server-cloud/2015/12/16/microsoft-targets-new-workloads-and-smaller-enterprises-with-expanded-storsimple-offerings/
    "StorSimple 8000 Series Update 2 introduces local volumes and a new StorSimple Cloud Appliance that delivers higher performance. Local volumes enable primary storage to be stored within the local tier of the StorSimple 8000 series physical array or the StorSimple Virtual Array, without the data being tiered to Azure to provide the performance needed for applications that cannot tolerate cloud latencies. A local volume is ideal for on-premises workloads that have high IO requirements, such as SQL Server, and storage for Microsoft Hyper-V and VMware virtual machines. For such applications, customers can continue to leverage Azure for data protection and location independent disaster recovery."

    StorSimple performances limits
    https://azure.microsoft.com/en-us/documentation/articles/storsimple-limits/
    You will find here maximum storage possible and also IOPS limits  for HDD, SSD and Cloud Tiers


    Stanislas Quastana, Microsoft France http://blogs.technet.com/stanislas

    Wednesday, April 27, 2016 12:20 PM