Showing posts with label annoyances. Show all posts
Showing posts with label annoyances. Show all posts

Sunday, 12 April 2009

Log Growth despite db being in simple mode

My database is in Simple mode but the log won't stop growing!

On the box I am seeing this on, the system cannot keep up. Checkpoint conditions (to control the log) are simply not happening fast enough. After some reading, I've found this is because it is a high volume import system. The constant importing means the sql is not issuing a checkpoint to control log size :(

Why is my log autogrowing? >
http://sqlblog.com/blogs/linchi_shea/archive/2009/04/12/a-race-condition-in-the-simple-recovery-mode-why-is-my-log-autogrowing.aspx

Manually issuing a checkpoint >
http://sqlblog.com/blogs/kalen_delaney/archive/2008/08/29/specifying-checkpoint-duration.aspx

Thursday, 29 June 2006

Disabling the annoying system beep!

The system beep is unaffected by windows volume control / sound card settings. If you're working late@ night and dont want to upset the missus, here is how to disable it >

Go to the dos prompt (START > RUN > type 'CMD' {Enter]
Run these 2 commands >
net stop beep [ENTER]
sc config beep start= disabled [ENTER]

Personally, i pasted those two command lines into a batch file and ran it on my machines (physical and virtual).