header image

Dynamic Management Views

Posted by: | October 31, 2010 | No Comment |

I’ve used DMVs in PowerShell and SQL Server demos a few times but hadn’t really dug into them.  There isn’t a lot of information available on DMVs but that will change early next year when SQL Server DMVs in Action is published – http://www.manning.com/stirk/ 

I’ve recently read the early access version and it is well worth investing in a copy if you are responsible for administering SQL Server.

The book doesn’t say so but it is very easy to run the scripts in the book from PowerShell

under: SQL Server