Query to Find Database and Log File Information

I have recently been dealing with a situation with a client where the transaction log has become an issue. Naturally during the research portion of trying to figure out what is wrong I wanted to find things like the size of the transaction log or wh...