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

Insert write delay Expand / Collapse
Author
Message
Posted Tuesday, March 10, 2009 6:07 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, January 12, 2010 5:06 AM
Points: 13, Visits: 98
SQL Server 2005 SP2
Database RecoveryModel Simple.
There occours a daily problem with insert records with very slow performance.
1 Record insert takes until 3 sec. this happens only between 03.00 - 04.00 in the nigth

Rest of the time we had no problems with the insert statments.
I found no error entries in the log at this time ...


Post #672323
Posted Tuesday, March 10, 2009 1:16 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: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
Check what jobs are running at that time.


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 #672723
Posted Tuesday, March 10, 2009 4:13 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 4:12 PM
Points: 758, Visits: 1,031
Backups? Virus scan? Database Maintenance?
Post #672843
Posted Wednesday, March 11, 2009 7:25 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, January 12, 2010 5:06 AM
Points: 13, Visits: 98
i changed today the backup jobs to an other time it was 1 Database transaction log backup at this time.
hoppefully this will help.
Post #673231
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse