From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Introduction to activity monitoring

Introduction to activity monitoring - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Introduction to activity monitoring

“

- [Instructor] The sequel server activity monitor gathers information about the monitored instance and displays the data in a series of collapsible panes. To take a look at it, let's first generate a small amount of activity in a new database that I'll call Activity Monitor DB. I'm going to create a simple table called DBO dot products, it'll just have two columns in it. Then I'm going to go down and we're going to insert 500 records, actually 15 hundred records, so 500 times the three values down here and we're going to insert all of those into our table Products. Then I'll scroll down a little bit more and we'll run this select statement against those product. Now we've performed a couple of tasks in our database, it's time to start up the activity monitor. You can find it on the tool bar with this icon here with the little graph. Go ahead and click on it and the activity monitor will start up. And the activity monitor is split up into a couple of different panes. Have the Overview,…

Contents