none
Local Storage in SQL Server 2012 (Fast Track Appliance)

    Question

  • Hello,

    Before procuring the Microsoft SQL Server 2012 Fast Track Appliance, we require additional information to satisfy the requirements from our infrastructure staff.  What type of data is stored in the local storage?  It seems that the local storage may be used for computations functionality only (temporary tables etc?); therefore, the only system backups that we may need to perform are for the main server and spare server which also contains all computation nodes (each SQL Server 2012 instance running on virtual machines?).  In fact, we probably don’t need any backups since the spare server provides a fail-over mechanism and allows for our engineers to “repair” any issues on the problem server? Also, If all of our data is already on a separate system outside of this data warehouse and can simply be exported back to the PDW system, then perhaps we don’t require backups? We simply use this data warehouse for analysis of the data (query and reporting).  The data collection and maintenance are permanently stored on a separate system.

    One last question, if required – could we remove the local storage and replace it with our enterprise SANs? – likely a performance hit; however, may still be better than having to integrate separate hardware components to try to replicate the fast track appliance and attempt to tune for performance.  Our infrastructure policy requires the use of enterprise SANs and reduction in local storage (possibly from new data center consolidation policies).

    Thank you for helping us to decide quickly and purchase this Fast Track Appliance expeditiously to meet our rapidly approaching deadline.  I have been unable to find answers to these questions from Microsoft pre-sales and tech support staff (without a support contract).

    Thank you,

    Vinh

    703-727-5377




    • Edited by Nguyen3 Monday, August 04, 2014 8:50 PM
    Sunday, August 03, 2014 7:43 PM

All replies

  • Hi Vinh,

    Thank you for your question. 

    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.

    Thank you for your understanding and support.

    Regards,


    Charlie Liao
    TechNet Community Support

    Wednesday, August 06, 2014 3:29 AM
  • Hello,

    Thank you for the question.

    If the data in the local storage can be extracted from the PDW again, we don't need to backup them.

    As for the storage replacement, technically speaking, you can replace the local storage with the different SANs. However, if you do so, you will lead the system to a nonsupport scenario.

    Please refer http://msdn.microsoft.com/en-us/library/hh918452.aspx for further information.

    If you cannot determine your answer here or on your own, consider opening a support case with us. Visit this link to see the various support options that are available to better meet your needs:

     http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

    Regards,

    Friday, August 08, 2014 1:20 AM