locked
Data Streaming RRS feed

  • Question

  • hi

    Trying to understand how the file streaming in MS SQL Server helps or can enhance the data large object data allocations while fetching/inserting the data and also the optimum performance can be achieved

    There are sites like http://www.solarmovie.me  or even you tube which are running on the similar fundamentals , how can such architecture be achieved using MS SQL server as a backend database or any better alternatives available to do so ?

    I believe there must be some parameters which can be set/managed/monitored, it would be a great help if any knowledge can be shared for this.



    • Changed type Kanwar Nain Saturday, November 30, 2013 8:01 PM Database management
    • Edited by Kanwar Nain Friday, December 6, 2013 7:02 PM unable to open it
    • Changed type Fred Bao Monday, December 9, 2013 1:35 AM It is a question
    Saturday, November 30, 2013 8:01 PM

Answers

  • >>I believe there must be some parameters which can be set/managed/monitored,

    In my opinion, yes, it is. We can see that in SQLServer, there are many system table and due to these system table, file streaming in MS SQL Server can make effect.

    For the use of these system table, please check link below:

    http://technet.microsoft.com/en-us/library/aa260604(v=sql.80).aspx

    For file streaming:

    http://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx

    Regards. 


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    • Edited by Fred Bao Monday, December 2, 2013 6:41 AM
    • Marked as answer by Fred Bao Monday, December 9, 2013 1:35 AM
    Monday, December 2, 2013 6:34 AM

All replies

  • >>I believe there must be some parameters which can be set/managed/monitored,

    In my opinion, yes, it is. We can see that in SQLServer, there are many system table and due to these system table, file streaming in MS SQL Server can make effect.

    For the use of these system table, please check link below:

    http://technet.microsoft.com/en-us/library/aa260604(v=sql.80).aspx

    For file streaming:

    http://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx

    Regards. 


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    • Edited by Fred Bao Monday, December 2, 2013 6:41 AM
    • Marked as answer by Fred Bao Monday, December 9, 2013 1:35 AM
    Monday, December 2, 2013 6:34 AM
  • Yea did study the links , its the metadata that handles the streaming, I'm thinking to configure it in SQL FCI . Thanks!!

    Friday, December 6, 2013 7:03 PM