S. Srivathsani

Dynamic Management Views and Functions in SQL Server 2005

DBAs have always been warned against using system tables in their code, but often there has been no other way to get information about the server. In SQL Server 2004, Dynamic Management Views have been provided that give you insight into almost every aspect of SQL Server. S. Srivathsani brings us a look at some of the DMVs and functions you can use.

4.54 (13)

2008-03-18 (first published: )

17,268 reads

Blogs

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs

Forums

Error switch partition

By samirca007

hello Good morning all I want to switch the partition from one table to...

SQL Patching implementation date

By WhiteLotus

Hi I am looking at the script to get SQL Patching implementation date ....

TDE / SQL server Database / SSIS

By hurricaneDBA

Dear Everyone We have implemented a data warehouse on-premises using SQL server 2019 enterprise...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers