Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cornelia
Starting Member
3 Posts |
 Posted - 2008-01-07 : 06:25:56
|
| so i have this problem: from time to time(once a week or 2 times per month) i get this message "DESCRIPTION: The SQL Server performance counter 'Percent Log Used' (instance 'DatabaseName') of object 'SQLServer:Databases' is now above the threshold of 90.00 (the current value is 99.00)". The alert comes between 04:00 and 06:00 a.m. and then everything is normal. i didn't make anything until now but it started to bother me.i don't know how to fix it so if you have any idea, please share. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 22:55:24
|
| It's about transaction log instead of error log. Is the db in full or bulk-logger recovery model? How often do you backup log then? |
 |
|
|
cornelia
Starting Member
3 Posts |
Posted - 2008-01-08 : 01:43:57
|
| it happen on sunday and again today... it's starting to be more often. the db is in full recovery model and it makes a backup log every 15 minutes. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-08 : 22:25:47
|
| Is there open transaction in the db? If not, it may because increased transactions in the db. Then need more log space or backup log more often. |
|
|
|
cornelia
Starting Member
3 Posts |
Posted - 2008-01-10 : 04:15:40
|
| 2 days ago we rebuild some indexes of the application and reset the machine. i wait to see if it will happen again. |
|
|
|
|
|
|
error Log above 90% used