From the course: Microsoft SQL Server 2016 Essential Training

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Monitor Stretch Database

Monitor Stretch Database - SQL Server Tutorial

From the course: Microsoft SQL Server 2016 Essential Training

Start my 1-month free trial

Monitor Stretch Database

“

- [Course Instructor] In this section we're going to look at monitoring and managing the stretch database. So for WideworldImporters, I right click, go to task, go to Stretch, it will give me the option to monitor. And that will pull up a little graphical interface with a green arrow pointing between my local database and the cloud database. If I scroll down I see that one table is being stretched, 518 of the rows are being stored locally, and 443 rows are being stored in Azure. So when we set this up, we created a little function to cause the older rows to be moved to Azure, but the newer rows would stay local. And from here we can see exactly how many rows were moved and how many rows stayed. If we open up the WorldwideImporters database, open up Tables, go to Application.People, and then Application.People_Archive, that's the table that we are stretching. If we right click and go to Stretch, we'll see the option to pause the transfer of rows. And also an option to disable. When we…

Contents