Posts Categorized: DMO

Lost In Translation

Lost in Translation – Deprecated System Tables – sysprotects

Posted by & filed under , , , .

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post. The compatibility view sysprotects returns rows for permissions within a database.  The view provides information on GRANT […]

LegoPieChart.jpg

Querying Performance Counters in SQL Server

Posted by & filed under , , , .

In a previous post, there was a comparison between sysperfinfo and sys.dm_os_performance_counters which included the use of a simple query.  The query just returned the contents of the dynamic management view, but didn’t provide the data from the view in a manner that immediately useful for all performance counters. The reason the data isn’t entirely […]