Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results for vlf
3
votes
2answers
I have been using Brent Ozar's sp_blitz script to review our database setup and have found that the VLF count is high (13562!) on the primary DB since changing to Full recovery model. I ran a full … index rebuild at the weekend during which the log file swelled to about 32GB on a 46GB data file with 10MB log autogrowth which I imagine has caused the high VLF count. From what I understand I should …
asked Apr 16 '13 by mizzle
1
vote
2answers
We currently have a transaction log thats been growing incrementally and has too many VLF files. I am going to follow a process of shrinking and then re-growing the log file to a suitable size to …
asked Sep 30 '14 by Tom
2
votes
2answers
If there are lot number of VLF then it will effect the performance of the queries. I saw that solution is to shrink the log file. But shrinking the file is also bad. So how to take control of whole thing? What is the optimal number of VLF in a database? …
asked Aug 23 '13 by IT researcher
4
votes
1answer
Is there a way to find the T-SQL statement that is part of the active transaction that is blocking the reuse of the transaction log file VLFs? I am performing tlog backups on every 15 minutes, but so …
asked Sep 12 '14 by gotqn
2
votes
1answer
I've inherited this huge SQL Server 2000 prod database and suddenly the transaction log ran out of space. The transaction log gets backed up every hour but I think over the weekend some existing jobs …
asked Sep 29 '13 by user27810
0
votes
2answers
I have a database that has log file of around 64 GB and the VLF count for the same is 500+. Almost all of them are active. I checked the open transactions and the oldest transaction on that database …
asked Oct 20 '16 by karun_r
5
votes
3answers
Is it possible to find the number of VLFs in a database's transaction log without running DBCC LOGINFO? DBCC LOGINFO seems a little heavy and verbose when count is the only information my t-sql script …
asked Jul 29 '11 by sh-beta
6
votes
4answers
I have a database with 160 VLFs. How do I determine whether the VLFs are fragmented? Further, how do I find the percentage of fragmentation? Another thing that I want to confirm: Are the following …
asked Jun 26 '14 by AA.SC
1
vote
1answer
autogrow to the same size over time? Background of my question: I face very high (>10K) VLF counts on several Log files of different live DBs with full recovery that are sized around 100 GB. While … testing strategies to get this fixed, I resized a Log file to 16 MB having 4 VLFs and let it grow to 40960 MB then with an AUTOGROW setting of 100 MB. Afterwards I had 20 VLF in the file. My expectation …
asked Jan 26 '17 by Magier
0
votes
2answers
(SQL 2014 Ent Ed.) - do I need to break my Availability Group if I need to reduce the number of VLFs in a database that is participating in an AG? Does anyone have the process documented? I am think …
asked Nov 15 '17 by Jim Vogler
5
votes
2answers
Recently ran into a situation where after a log backup and shrinkfile, the LDF file remained the same size. DBCC LOGINFO clearly showed only one active VLF and SSMS said that 99% of the space in the … that after every SHRINKFILE, another VLF became active. I decided to run a test of a new database. CREATE DATABASE logs_test USE logs_test -- first look at the VLFs for the logs_test database DBCC …
asked Aug 22 '13 by Craig Efrein
6
votes
3answers
I have a database of size 840 GB which has 948 VLF's. On other hand there is one with size of 1.6 TB having 320 VLF's. Does that indicate the smaller database with that high count of VLF's is actually …
asked Jul 18 '17 by BeginnerDBA
1
vote
0answers
is a VLF (Virtual Log File) that is marked as active (status 2) and needs to be backed up. Step 4-5 are not resolving this. This VLF seems to be related to the Availability Group and is kept there for … the secondary replica is my guess. Reference: Removing TDE Lazy Log Truncation – Clearing of SQL transaction log VLF status deferred How can I clear the VLF status and shrink the log file? …
asked Jun 12 '17 by pesi
3
votes
1answer
Is it true that a transaction log backup made on the secondary database is clearing the inactive VLFs on the tlog file on the primary database (in case of Availability Groups)? I was not able to find …
asked Sep 19 '14 by gotqn
3
votes
1answer
determine log space usage and the active portion of the VLF : USE BASE2 dbcc loginfo GO USE BASE3 dbcc loginfo GO DBCC SQLPERF(LOGSPACE) So in my opinion there is plenty of space that I can … around 250 MO. So why my firt query did not shrink the log files to the requested value 512 MO ? Indeed, There was no active VLF at the end of file and still a lot of unused space. …
asked Sep 15 '16 by Mickael

15 30 50 per page