Based on my monitoring collection, i am having an issue while collecting info regarding how many VLF' i have for # of databases in SQL instance.
1st issue - Is there a single script which can be used from 2012 - 2019 SQL versions as standard to get the VLF info across all databases in an instance
2nd issue - how can i get 1st done with least privilege because login we use to collect info is not sysadmin and cant be. So how can i achieve this?
Much appreciated, thanks!