Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log Space Expand / Collapse
Author
Message
Posted Wednesday, August 19, 2009 11:51 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:20 AM
Points: 432, Visits: 1,073
i got the alert mail as (Log Space Used for attached database is more than 90%)
what is the meaning and wt will i do.
Post #773785
Posted Wednesday, August 19, 2009 11:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
It probably means that your log file is about to autogrow, or that it will need to be grown.

It probably also means that log backups aren't being done the way they should.

It might mean the database is in the wrong recovery mode.

It literally means that 90% of the allocated space for the log file is in use and only 10% remains for new transactions. What you need to do about that depends on what the database is for, how it's used, and what expectations are for growth and use in the future.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #773787
Posted Wednesday, August 19, 2009 12:01 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:20 AM
Points: 432, Visits: 1,073
ok thanks.........
shall i add the space to logfile.
how to add the space?
Post #773794
Posted Wednesday, August 19, 2009 12:47 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
First, you need to look at what recovery model the database is in. You can get that by looking at the Options tab in the properties. (Right-click the database in Management Studio to get to the properties.)

If it's in Full recovery mode, then you need to check on whether or not log backups are being done.

If it's in Simple recovery mode, then you need to look at long-running transactions that might be filling it up.

What you do from there depends on what you find.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #773829
Posted Wednesday, August 19, 2009 1:29 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 9:19 AM
Points: 1,307, Visits: 4,508
And when you've done what Gus suggests, it's worth reading Gail's article on managing the transaction log http://www.sqlservercentral.com/articles/64582/


Post #773862
Posted Wednesday, August 19, 2009 2:04 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:43 PM
Points: 40,411, Visits: 36,861
You can query sys.databases to see why the log space is not been reused. Check the log_reuse_wait_descr column.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #773884
Posted Wednesday, August 19, 2009 3:13 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:20 AM
Points: 432, Visits: 1,073
thanks...........
Post #773925
Posted Wednesday, August 19, 2009 3:19 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 20,801, Visits: 32,730
Curious, base on other posts I am wondering what your position is with your company? Mind letting us know?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #773927
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse