108 reputation
5
bio website andersrask.sharepointspace.co…
location Århus, Denmark
age 44
visits member for 3 years, 11 months
seen Jan 23 at 8:04

Sharepoint Solution Architect in ProActive. Situated in Århus Denmark


Apr
25
awarded  Student
Apr
25
asked Adding SSD boot disk to machine running RAID 10
Apr
19
awarded  Citizen Patrol
Mar
1
awarded  Scholar
Mar
1
accepted Minimizing SQL transaction log file size on developer box running simple recovery model
Feb
25
comment Minimizing SQL transaction log file size on developer box running simple recovery model
I just shrank all log files yesterday, and they are still nice and small. When running DBCC SQLPERF i found an avg of 59% usage with MIN being 21% and MAX being 91%. It has taken the log files 4 month of slow growing to reach almost 1 GB each for the SharePoint configuration databases, which is 8x the size of the database itself
Feb
25
awarded  Supporter
Feb
24
comment Minimizing SQL transaction log file size on developer box running simple recovery model
i already have a script for shrinking logfiles, this is what i do right now. But what i really want is guidance on setting proper logfile size (eg autogrow) for a development environment where transaction log files are useless and where i dont take backups.
Feb
24
comment Minimizing SQL transaction log file size on developer box running simple recovery model
should probably have mentioned that i already did this (i used log_reuse_wait_desc though). It say NOTHING. How ever i think i have a pretty good idea why Checkpoints arent reached (as mentioned), i am more interested in how to get a setting where i keep transaction log size at minimum without introducing other problems
Feb
24
comment Minimizing SQL transaction log file size on developer box running simple recovery model
as i said, i have simple logging enabled
Feb
24
asked Minimizing SQL transaction log file size on developer box running simple recovery model
Jul
30
awarded  Autobiographer