Implementing Stretch Database.

  • Deepak Prasad Sahu

    Ten Centuries

    Points: 1091

    Comments posted to this topic are about the item Implementing Stretch Database.

  • doodlingdba

    Hall of Fame

    Points: 3120

    Wow! Interesting. Anyone using this?

    Doodles

  • daniel_marques

    SSC Enthusiast

    Points: 150

    Micorosoft in the beginning 😉

  • Br. Kenneth Igiri

    SSCarpal Tunnel

    Points: 4471

    Thanks for the article, Deepak.

    I may have missed this in the article but what determines what rows stay on prem and what rows stay in the cloud by default.

    And based on experience, can anyone estimate to what extent performance is impacted by a poor Internet connection when querying rows in the cloud? 

    Br. Kenneth Igiri
    www.scribblingsage.com
    All nations come to my light, all kings to the brightness of my rising

  • Deepak Prasad Sahu

    Ten Centuries

    Points: 1091

    Welcome Ken!

    I think by default,table data is separated into Hot Data(that is frequently accessed) & Cold Data(rarely or almost never accessed data).So hot data stay on prem and cold data is moved to Azure.
    From performance perspective, I have not encountered any issues as mainly dealt with the historic data on cloud.
    Thanks,
    Deepak.

  • Br. Kenneth Igiri

    SSCarpal Tunnel

    Points: 4471

    Deepak Sahu - Wednesday, January 16, 2019 6:25 AM

    Welcome Ken!

    I think by default,table data is separated into Hot Data(that is frequently accessed) & Cold Data(rarely or almost never accessed data).So hot data stay on prem and cold data is moved to Azure.
    From performance perspective, I have not encountered any issues as mainly dealt with the historic data on cloud.
    Thanks,
    Deepak.

    Thanks. Makes sense.

    Br. Kenneth Igiri
    www.scribblingsage.com
    All nations come to my light, all kings to the brightness of my rising

  • Sreekanth B

    SSCertifiable

    Points: 6122

    Good write up Deepak. Never knew it's that simple to implement. Any pitfalls/limitations and GOTCHAs to be aware of based on your experience?

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

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