From the course: SQL Server 2014 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understanding dynamic management views - SQL Server Tutorial
From the course: SQL Server 2014 Essential Training
Understanding dynamic management views
- Another group of tools to be aware of when monitoring SQL Server 2014, are the dynamic management views. These are a series of views, automatically included in every database, that provide data about the management, and performance of that database. So inside of AdventureWorks 2014, I'll open that up and I'll look at Views. And when we open up Views, we see a list of all of the user-defined views, that were created by users. But above that we have a folder for System Views. And if we open that up, we see lots and lots of views. The ones most commonly used are the ones that start with the letters s-y-s. For example, we have sys.all_columns. If I right click on that, and do Select Top 1000 Rows, it'll run a query for me that returns data about all of the columns in all of the tables in this database. As we scroll down through that, we see things that we clearly recognize as column names. Like ProductID, ListPrice, ModifiedDate. So this view contains information about all of the…
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.