der kører mange jobs som arbejder med meget store datamængder - og disken bliver ofte fyldt. 'En gang imellem' betyder vel at den kører når den så småt bliver presset?
Automatic Checkpoints SQL Server 2000 always generates automatic checkpoints. The interval between automatic checkpoints is based on the number of records in the log, not time. The time interval between automatic checkpoints can be highly variable. The time interval between automatic checkpoints is long if few modifications are made in the database. Automatic checkpoints occur frequently if a lot of data is modified.
The interval between automatic checkpoints is calculated from the recovery interval server configuration option. This option specifies the maximum time SQL Server should use to recover a database during a system restart. SQL Server estimates how many log records it can process in the recovery interval during a recovery operation. The interval between automatic checkpoints also depends on whether or not the database is using the simple recovery model.
If the database is using either the full or bulk-logged recovery model, an automatic checkpoint is generated whenever the number of log records reaches the number SQL Server estimates it can process during the time specified in the recovery interval option.
If the database is using the simple recovery model, an automatic checkpoint is generated whenever the number of log records reaches the lesser of these two values: The log becomes 70 percent full.
The number of log records reaches the number SQL Server estimates it can process during the time specified in the recovery interval option. Automatic checkpoints truncate the unused portion of the transaction log if the database is using the simple recovery model. The log is not truncated by automatic checkpoints if the database is using the full or bulk-logged recovery models. For more information, see Truncating the Transaction Log.
problemet er at 1 SQL sætning = 1 transaktion = alle de data klumper som ændres skal gemmes i loggen
Hvis du kan leve uden kravet om atomicitet kan du ændre 1 DELETE til f.eks. 10 DELETE med noget ekstra på din WHERE og på den måde klare dig med 1/10 log plads.
ja, ok det kan man jo også... (det er bare hurtigere at sætte et nyt job op istedet for at modificere alle eksisterende ;-)) - men det er jo nok den 'pæneste' løsning. Det undrer mig bare at man ikke helt kan disable den log
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.