August 19, 2009 at 11:51 am
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.
August 19, 2009 at 11:53 am
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
August 19, 2009 at 12:01 pm
ok thanks.........
shall i add the space to logfile.
how to add the space?
August 19, 2009 at 12:47 pm
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
August 19, 2009 at 1:29 pm
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/
August 19, 2009 at 2:04 pm
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 19, 2009 at 3:13 pm
thanks...........
August 19, 2009 at 3:19 pm
Curious, base on other posts I am wondering what your position is with your company? Mind letting us know?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply