Join Ron Davis for an in-depth discussion in this video Examining the Actvity Monitor, part of SQL Server 2014: Installation and Administration.
- Let's take a look at Activity Monitor, and that's started up on Server. So I'm going to select Server here, and I'll right click it. And here we are, Activity Monitor. Up she pops. And this'll look fairly familiar to you if you've ever used Task Manager, and gone into detailed view. So, I can set the Refresh interval, and currently I have it 1 second. I would not normally do that, but I'm collecting it here 1 second because we're just not doing anything with this database, so you know, I'm just trying to show any activity that we have.
And if we click Processes, you can see the process ID, how it's logged on, the database that we're using, and more information coming across. If I have anything that's doing waits for me right here it's going to show me my waits. And IOs, I'm not doing anything down here. I'm not doing any inputs. So, she's just not going to give me much information at all. As you see, there's my temps and the counts are all 00 as you come up and down.
Expensive Queries, this is anything that has happened. And if you'll notice, as we drill on down into, we're really looking at just queries that SQL runs internally. So if we generate a little activity, let's open a query. This is one we've used before. I'm going to open Large Execution Plan, and we'll just execute it to see what happens. She's done. And if we switch on over here and now we go into Processes, now I can come in and I see this process ID.
And if I right click it, and say Details, there's the query that I just ran in there. And because the query window is still open, I still have a connection into my database so I can see what happened there. I can right click it and kill it if I had a hang up of some type. I can take care of it there. And down here in the Recent Expensive Queries, down here, and now you see what's moved back up.
Now my query, which was recently expensive, has moved up to the top. Again, we just haven't done much so that's why we don't have much information in here, as far as if you were looking at a production database, you're going to see a much bigger bang in here. And of course, at that time, you'd want to change your gathering interval. So there's your Activity Monitor.
- Planning SQL Server installation
- Installing SQL Server 2014
- Using the tools: SQL Server Management Studio, PowerShell, and more
- Managing the databases
- Automating maintenance
- Performing backups and recovery
- Importing and exporting data
- Indexing databases
- Monitoring activity, performance, and events
- Implementing security