enrique_aeo
asked on
LOG FILE - 90GB
I'm taking Backup of the LOG every 15 minutes, but which LOG has created up to 90GB.
While it is true every time you get a BK Full or LOG truncates the LOG, but this has grown a lot, as you can calculate how much is needed for transactions LOG and not grow as much, as in this case.
This is for several BD that you have.
While it is true every time you get a BK Full or LOG truncates the LOG, but this has grown a lot, as you can calculate how much is needed for transactions LOG and not grow as much, as in this case.
This is for several BD that you have.
you may have to shrink the log file during a maintenance period. How large is individual log files, if its pretty big, you need to investigate what the issue is.
ASKER
you may have to shrink the log file during a maintenance period. What do you mean, what should I do?
How large is individual log files, if its pretty big, you need to investigate what the issue is. Where do I begin?
How large is individual log files, if its pretty big, you need to investigate what the issue is. Where do I begin?
dbcc shrinkfile is the statement to shrink the log file.
How many transaction are you processing / second ? do you have any background job that runs on sql server ? You said pretty big, are they more than 1GB ? Page Splits can cause the log growth, here is an article that can help you
https://www.sqlskills.com/blogs/jonathan/tracking-problematic-pages-splits-in-sql-server-2012-extended-events-no-really-this-time/
How many transaction are you processing / second ? do you have any background job that runs on sql server ? You said pretty big, are they more than 1GB ? Page Splits can cause the log growth, here is an article that can help you
https://www.sqlskills.com/blogs/jonathan/tracking-problematic-pages-splits-in-sql-server-2012-extended-events-no-really-this-time/
>> While it is true every time you get a BK Full or LOG truncates the LOG, but this has grown a lot
Log files can't be reused in certain scenarios when you have Active Log as listed below even if you have Log backups configured once every 15 minutes.
* Replication
* Long Running Transactions
To identify why the Log file is growing when it is growing, run the below command. Once that process is completed, you will be able to shrink your log file as Aneesh mentioned above..
Log files can't be reused in certain scenarios when you have Active Log as listed below even if you have Log backups configured once every 15 minutes.
* Replication
* Long Running Transactions
To identify why the Log file is growing when it is growing, run the below command. Once that process is completed, you will be able to shrink your log file as Aneesh mentioned above..
Use ur_db_name
GO
select log_reuse_wait_desc
from sys.databases
where name = db_name()
ASKER
in all the BD that I have executed the query it shows me the value "NOTHING"
whats the mean?
whats the mean?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.