Blog Post

SQL Server Blog
2 MIN READ

Released: Public Preview for SQL Server Management Pack (2012-2019)

EbruErsan's avatar
EbruErsan
Icon for Microsoft rankMicrosoft
Nov 25, 2019
We are getting ready to release a new version of SQL Server Management Pack. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We appreciate the tim...
Published Nov 25, 2019
Version 1.0
sqlreleases
smilne's avatar
smilne
Copper Contributor
Nov 28, 2019

Crossposting from UserVoice:

 

When the Version Agnostic management pack attempts to collect VLF counts, it uses DBCC LOGINFO("dbname") to achieve this. Would it be possible to update this workflow to use sys.dm_db_log_info instead? This replaces DBCC LOGINFO as described in the below documentation:

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-log-info-transact-sql?view=sql-server-ver15#remarks

 

DBCC LOGINFO("model")

User 'DOMAIN\AgentAccount' does not have permission to run DBCC LOGINFO.

 

https://systemcenterom.uservoice.com/forums/293064-general-operations-manager-feedback/suggestions/39146965-update-db-virtual-log-file-workflow-to-use-sys-dm