From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Monitor current sessions - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Monitor current sessions
- [Instructor] As a database administrator, it's going to be important to know who is doing what with your databases for a couple of reasons. First, you need to get a feel for how users are actually using the system. Are they taxing the hardware by running complex queries, or maybe getting into situations where they're blocking each other from accessing the data that they need? Second, by identifying peak periods of activity, you can better schedule routine maintenance tasks so that they minimize their impact on the users. And third, having a feel for a baseline, or normal amount of activity, will allow you to better recognize abnormal activities that should be investigated. Understanding user behavior begins with looking at the sessions and the logins of the server. The easiest way to do that is to execute a system-stored procedure called sp_who. Let's first switch into the worldwide-importers database, and then we can execute it by running this line on Line Six. The results show all…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.