{"id":12441,"date":"2019-06-12T20:59:57","date_gmt":"2019-06-12T20:59:57","guid":{"rendered":"https:\/\/dbtut.com\/?p=12441"},"modified":"2019-06-12T20:59:58","modified_gmt":"2019-06-12T20:59:58","slug":"how-to-check-vlf-counts-in-the-databases-using-policy-based-management","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/","title":{"rendered":"How To Check VLF Counts in the Databases Using Policy Based Management"},"content":{"rendered":"

Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to set our standards and to make our controls automatically. For example, we can create a policy for control purposes so that the names of our stored procedures do not start with a number or database recovery models are not simple.<\/p>\n

Before reading this article, I recommend that you read the article “Vlf(Virtual Log File) Count<\/a>” to understand the answer to the question of what means the VLF Count and what should not be.<\/p>\n

To comprehend Policy Based Management (PBM), you need to understand some concepts.<\/p>\n

Facet<\/h2>\n

A feature that can be managed by PBM. For example, there is a facet called Database. And you can use this facet to create a policy that checks the vlf count in the log file in the database.<\/p>\n

You can access all facets via SSMS as follows. To access the facet details, you must double-click on it.<\/p>\n

\"\"<\/p>\n

Condition<\/h2>\n

Checks whether the sub-property of the related facets provide the specified condition.<\/p>\n

Let’s create a policy to check the vlf count in the database.<\/p>\n

Right click Policies tab as follows from the Management> Policy tab and click New Policy.<\/p>\n

\"\"<\/p>\n

We give a name to Policy on the screen that appears. We need to create a condition from Check Condition.<\/p>\n

We’re clicking on New Condition.<\/p>\n

\"\"<\/p>\n

We give a name to the condition from the screen that appears.<\/p>\n

From the Facet section, we select the Database facet because we will check the vlf count of the log file in the database.<\/p>\n

Click on “…” in the Expression section to paste the following script into the Cell Value section.<\/p>\n

ExecuteSql('Numeric', '--variables to hold each ''iteration''  \ndeclare @query varchar(100)  \ndeclare @dbname sysname  \ndeclare @vlfs int  \n  \n--table variable used to ''loop'' over databases  \ndeclare @databases table (dbname sysname)  \ninsert into @databases  \n--only choose online databases  \nselect name from sys.databases where state = 0  \n  \n--table variable to hold results  \ndeclare @vlfcounts table  \n    (dbname sysname,  \n    vlfcount int)  \n  \n \n \n--table variable to capture DBCC loginfo output  \n--changes in the output of DBCC loginfo from SQL2012 mean we have to determine the version \n \ndeclare @MajorVersion tinyint  \nset @MajorVersion = LEFT(CAST(SERVERPROPERTY(''ProductVersion'') AS nvarchar(max)),CHARINDEX(''.'',CAST(SERVERPROPERTY(''ProductVersion'') AS nvarchar(max)))-1) \n\nif @MajorVersion < 11 -- pre-SQL2012 \nbegin \n    declare @dbccloginfo table  \n    (  \n        fileid smallint,  \n        file_size bigint,  \n        start_offset bigint,  \n        fseqno int,  \n        [status] tinyint,  \n        parity tinyint,  \n        create_lsn numeric(25,0)  \n    )  \n  \n    while exists(select top 1 dbname from @databases)  \n    begin  \n  \n        set @dbname = (select top 1 dbname from @databases)  \n        set @query = ''dbcc loginfo ('' + '''''''' + @dbname + '''''') ''  \n  \n        insert into @dbccloginfo  \n        exec (@query)  \n  \n        set @vlfs = @@rowcount  \n  \n        insert @vlfcounts  \n        values(@dbname, @vlfs)  \n  \n        delete from @databases where dbname = @dbname  \n  \n    end --while \nend \nelse \nbegin \n    declare @dbccloginfo2012 table  \n    (  \n        RecoveryUnitId int, \n        fileid smallint,  \n        file_size bigint,  \n        start_offset bigint,  \n        fseqno int,  \n        [status] tinyint,  \n        parity tinyint,  \n        create_lsn numeric(25,0)  \n    )  \n  \n    while exists(select top 1 dbname from @databases)  \n    begin  \n  \n        set @dbname = (select top 1 dbname from @databases)  \n        set @query = ''dbcc loginfo ('' + '''''''' + @dbname + '''''') ''  \n  \n        insert into @dbccloginfo2012  \n        exec (@query)  \n  \n        set @vlfs = @@rowcount  \n  \n        insert @vlfcounts  \n        values(@dbname, @vlfs)  \n  \n        delete from @databases where dbname = @dbname  \n  \n    end --while \nend \n  \n--output the full list  \nselect vlfcount  \nfrom @vlfcounts  \norder by dbname\n')\n<\/pre>\n
\"\"<\/p>\n
And since we want the vlf number to be less than 1000, we set it to “<1000”. The number 1000 is not an appropriate value for every database. Therefore, you should read the article I mentioned at the beginning of the article.<\/p>\n
\"\"<\/p>\n
By selecting On Schedule from the Evaluation Mode, we select the interval at which the policy will be checked and then click the Enable check box.<\/p>\n
If we choose On Demand, it only checks when we execute policy.<\/p>\n
If you have a server-based condition, you can create a server-based condition from the server restriction section.<\/p>\n
\"\"<\/p>\n
If you want it to be checked automatically at certain intervals, click New in the Schedule section and determine the frequency that the policy will check the condition. We set it up to work once every day at 12: 00: 000 PM.<\/p>\n
\"\"<\/p>\n
We created our policy. We click Evaluate as below to run it manually.<\/p>\n
\"\"<\/p>\n
Since we use script instead of Facet property, we received a warning like the following. Policy says it contains scripts and we should only run it from a trusted source.<\/p>\n
The policy: ‘VLFCount’ contains scripts. You should only run policies from a trustworthy source.<\/em><\/span><\/p>\n
\"\"<\/p>\n
We press the Evaluate button at the bottom right to run the policy despite the warning.<\/p>\n
When I perform this operation in my local, I get a result like the following. As you can see, none of the databases have more than 1000 vlfs. You can find out the current vlf count by clicking View.<\/p>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n
With Policy Based Management, you can check many things on SQL Server. And I think a professional database manager should use this feature that SQL Server offers us. You can find more articles on Policy Based Management at the following links.<\/p>\n
“How To Check the Compatibility Level of Databases Using Policy Based Management<\/a>“,<\/p>\n
“How To Check Recovery Model of All Databases Using Policy Based Management<\/a>“,<\/p>\n
“How To Check Stored Procedure Names Using Policy Based Management<\/a>“,<\/p>\n
“How To Check SQL Logins That Password Policy Enforced or Password Expiration Enabled Using Policy Based Management”,<\/p>\n
“How To Check Disabled Audits Using Policy Based Management”,<\/p>\n
“How To Check Auto Shrink Option of Databases Using Policy Based Management”,<\/p>\n
“How To Check Whether Availability Groups is Ready To Failover Using Policy Based Management”,<\/p>\n
“How To Check Availability Group’s Backup Preference Using Policy Based Management”,<\/p>\n
“How To Check Availability Group Automatic Failover Settings Using Policy Based Management”,<\/p>\n
“How To Check Whether Readable Secondary is Enabled on Availability Groups Using Policy Based Management”,<\/p>\n
“How To Check Whether Data File Sizes is Reached a Specific Size Using Policy Based Management”,<\/p>\n
“How To Check Auto Close Option of Databases Using Policy Based Management”,<\/p>\n
“How To Check Last Log Backup Time Using Policy Based Management”,<\/p>\n
“How To Check Page Verify Option of Databases Using Policy Based Management”<\/p>\n\n
 <\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to set our standards and to make our controls automatically. For example, we can create a policy for control purposes so that the names of our stored procedures do not start …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":12466,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[4550,4553,4552,4549,4551],"class_list":["post-12441","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-check-vlf-count-in-a-database","tag-executesql","tag-script-in-pbm","tag-the-policy-contains-scripts-you-should-only-run-policies-from-a-trustworthy-source","tag-use-sql-script-in-policy-based-management"],"aioseo_notices":[],"yoast_head":"\nHow To Check VLF Counts in the Databases Using Policy Based Management - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Check VLF Counts in the Databases Using Policy Based Management\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Check VLF Counts in the Databases Using Policy Based Management - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Check VLF Counts in the Databases Using Policy Based Management\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-12T20:59:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-12T20:59:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"664\" \/>\n\t<meta property=\"og:image:height\" content=\"363\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Check VLF Counts in the Databases Using Policy Based Management\",\"datePublished\":\"2019-06-12T20:59:57+00:00\",\"dateModified\":\"2019-06-12T20:59:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/\"},\"wordCount\":764,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-2.png\",\"keywords\":[\"check vlf count in a database\",\"ExecuteSQL\",\"script in pbm\",\"The policy contains scripts. You should only run policies from a trustworthy source.\",\"use sql script in policy based management\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/\",\"name\":\"How To Check VLF Counts in the Databases Using Policy Based Management - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-2.png\",\"datePublished\":\"2019-06-12T20:59:57+00:00\",\"dateModified\":\"2019-06-12T20:59:58+00:00\",\"description\":\"How To Check VLF Counts in the Databases Using Policy Based Management\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-2.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-2.png\",\"width\":664,\"height\":363},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Check VLF Counts in the Databases Using Policy Based Management\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Check VLF Counts in the Databases Using Policy Based Management - Database Tutorials","description":"How To Check VLF Counts in the Databases Using Policy Based Management","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/","og_locale":"en_US","og_type":"article","og_title":"How To Check VLF Counts in the Databases Using Policy Based Management - Database Tutorials","og_description":"How To Check VLF Counts in the Databases Using Policy Based Management","og_url":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/","og_site_name":"Database Tutorials","article_published_time":"2019-06-12T20:59:57+00:00","article_modified_time":"2019-06-12T20:59:58+00:00","og_image":[{"width":664,"height":363,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-2.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Check VLF Counts in the Databases Using Policy Based Management","datePublished":"2019-06-12T20:59:57+00:00","dateModified":"2019-06-12T20:59:58+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/"},"wordCount":764,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-2.png","keywords":["check vlf count in a database","ExecuteSQL","script in pbm","The policy contains scripts. You should only run policies from a trustworthy source.","use sql script in policy based management"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/","url":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/","name":"How To Check VLF Counts in the Databases Using Policy Based Management - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-2.png","datePublished":"2019-06-12T20:59:57+00:00","dateModified":"2019-06-12T20:59:58+00:00","description":"How To Check VLF Counts in the Databases Using Policy Based Management","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-2.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/06\/Ads\u0131z-2.png","width":664,"height":363},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/how-to-check-vlf-counts-in-the-databases-using-policy-based-management\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Check VLF Counts in the Databases Using Policy Based Management"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12441","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=12441"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12441\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12466"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}