Improve company productivity with a Business Account.Sign Up

x
?
Solved

How Full is the Logdevice?

Posted on 1998-12-14
1
Medium Priority
?
152 Views
Last Modified: 2010-03-19
Is there a stored procedure or command that shows how full the logdevice is?
sp_spaceused does not break it down by data and log, just total size.
Our data and logs are on separate logical devices.
0
Comment
Question by:snydero
1 Comment
 
LVL 1

Accepted Solution

by:
kponder earned 150 total points
ID: 1092264
DBCC SQLPERF(LOGSPACE)
0

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

585 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question