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,262 reads

Blogs

Using Visual Studio Code

By

I’m a creature of habit. I have my routine when I get to my...

Docker Containers and Persistent Data

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Cursor Dynamic SQL

By

Today was working on SQL Server cursor standard cursor deification would be like this:...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Suspended session

By IMary

Hi, Application service is going to hung state and when we check the database,...

Does blocking has affect on High DTU utilization ?

By ebooklub

Hi, Does blocking has affect on High DTU utilization ?  (some people advocate that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers