SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


High Log flush time???


High Log flush time???

Author
Message
klnsuddu
klnsuddu
SSChasing Mays
SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)

Group: General Forum Members
Points: 604 Visits: 757
Hi,
We are using Spot light for Monitoring SQL Server 2005 and we are getting the below error frequently.
What this error referencing to? What is the corrective action to get rid of this? Is this a serious issue? We are getting this for all most all databases
Time Connection Action Details Severity Alarm
05/20/2009 4:01:32 PM ABC Alarm raised the database Search_DB has a high Log Flush Wait time (515 ms). Low Databases - Log Flush Wait Time Alarm.
maechismo_8514
maechismo_8514
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1902 Visits: 2228
klnsuddu (5/21/2009)
Hi,
We are using Spot light for Monitoring SQL Server 2005 and we are getting the below error frequently.
What this error referencing to? What is the corrective action to get rid of this? Is this a serious issue? We are getting this for all most all databases
Time Connection Action Details Severity Alarm
05/20/2009 4:01:32 PM ABC Alarm raised the database Search_DB has a high Log Flush Wait time (515 ms). Low Databases - Log Flush Wait Time Alarm.


This means SQL server cannot write the log files onto the disk in a timely manner. Do you have DB mirroring set up by any chance to this database?

What is your physical disk layout and also could I ask you what is the frequency of your tlog backups?
TRACEY-320982
TRACEY-320982
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1360 Visits: 1014
Is it share point by any chance and they are rebuilding indexes this could take for ages.....
klnsuddu
klnsuddu
SSChasing Mays
SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)

Group: General Forum Members
Points: 604 Visits: 757
Yes, these are share point databases and we have log backups twice a day. It is in pre-production, later we will change the log backup schedule to every 1 hour.

This error is because of not having frequent log backups?
TRACEY-320982
TRACEY-320982
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1360 Visits: 1014
No shouldn't be because of lack of backups...1 hours is good..or could do 15 minutes if they are very big logs to keep them down a bit when backing them up. Ask the sharepoint guys if they are doing search indexes and if they are on MOSS which i think is the latest version of sharepoint.
Also ask them if they are doing rebuilds on the app side or setting up new search indexs on the apps.

Thread i found looks interesting.
http://sqlcat.com/technicalnotes/archive/2008/12/09/diagnosing-transaction-log-performance-issues-and-limits-of-the-log-manager.aspx
klnsuddu
klnsuddu
SSChasing Mays
SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)SSChasing Mays (604 reputation)

Group: General Forum Members
Points: 604 Visits: 757
Hi,

We have share point databases in sql server 2005 EE x64 and we do NOT have mirroing setup.

and No Index rebuilds and Integrity checks happening. But Still we are frequently getting the high Log flush wait itme alarms? is this a critical to databases?

how to rectify the cause of this alarm?
TRACEY-320982
TRACEY-320982
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1360 Visits: 1014
Put on profiler and capture what is running at this time.
jasonlorraine1999
jasonlorraine1999
Valued Member
Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)

Group: General Forum Members
Points: 52 Visits: 1060
I know this thread is old (very old but it may help someone else)
But with a high log flush I would look at the autogrowth settings. SQL 2008 has sensable growth defaults but SQL 2000 and 2005 use 10% growth settings.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search