RE: Log file R drive- What is consuming it

SSC Guru

Points: 1003859

November 16, 2017 at 10:16 pm

#1968459

coolchaitu - Thursday, November 16, 2017 10:01 PM
Good Morning Experts.
We have a SQL Server instance. All the user databases log files are on R drive. We have been getting alerts that R drive is 99% full, 100% full. I am interested to know what is consuming the R drive. Could you please advise. Any script to check what is consuming the R drive?

How big is the drive and is anything else using the drive? Also, how often are you taking log file backups? And, what are the initial size and growth settings set to? And finally, do you have any form of log shipping or replication running?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)