How to get the log file usedspace in 2005 ?

Question

Post reply

How to get the log file usedspace in 2005 ?

kumarreddy72

SSC Enthusiast

Points: 190
More actions
September 29, 2011 at 1:02 am

#245611

Here i need to get the log used space in sql 2005 , so that i can perform log used percentage in my project.
Thanks
Kumar

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

I'm sure there are a couple of ways how you can do it, but to me the simplest one would be this:

DBCC SQLPERF ( LOGSPACE )

[font="Verdana"]Markus Bohse[/font]

kumarreddy72 SSC Enthusiast Points: 190 More actions · Answer 2

kumarreddy72

SSC Enthusiast

Points: 190

September 29, 2011 at 2:45 am

#1388223

Thanks,

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

You can do this as well:

SELECT

DF.name,

size,

FILEPROPERTY(DF.name, 'spaceused') AS pages_used

FROM

sys.database_files AS DF

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

My 2 bits - I like to use the method that Jack showed.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

george sibbald SSC Guru Points: 104210 More actions · Answer 5

Jack Corbett (9/29/2011)
You can do this as well:
SELECT
DF.name,
size,
FILEPROPERTY(DF.name, 'spaceused') AS pages_used
FROM
sys.database_files AS DF

..but that wouldn't return percentage used..............

---------------------------------------------------------------------

Jack Corbett SSC Guru Points: 184394 More actions · Answer 6

george sibbald (9/29/2011)
Jack Corbett (9/29/2011)
You can do this as well:
SELECT
DF.name,
size,
FILEPROPERTY(DF.name, 'spaceused') AS pages_used
FROM
sys.database_files AS DF
..but that wouldn't return percentage used..............

Okay you got me there, although he didn't specifically ask for percentage used. Here's a query that includes pct used:

SELECT

DF.name,

size,

FILEPROPERTY(DF.name, 'spaceused') AS pages_used,

FILEPROPERTY(DF.name, 'spaceused') * 1.0/size * 100 AS pct_used

FROM

sys.database_files AS DF

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

george sibbald SSC Guru Points: 104210 More actions · Answer 7

wasn't meaning to have a go Jack, I just read it that the op was after a percentage.

---------------------------------------------------------------------

Jack Corbett SSC Guru Points: 184394 More actions · Answer 8

george sibbald (9/29/2011)
wasn't meaning to have a go Jack, I just read it that the op was after a percentage.

I know you weren't George. But you did get me. I read the OP as asking for how to get the space used so he could calculate the percentage later.

Unfortunately tone doesn't come across on when you type. I was trying to have some fun as well.:-P I should have used the smiley on the first post.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

george sibbald SSC Guru Points: 104210 More actions · Answer 9

thought you were probably ok with it but didn't want to take the chance, as you say hard to convey tone.

I don't know the emoticon for 'not trying to be a smart ar5e but...' otherwise I would have added that to my first post 🙂

I was also hoping for some extra freebie code!

and hey - 4000 points!

---------------------------------------------------------------------