Ayende @ Rahienhttp://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Ayende Rahien commented on What were you doing with last year logs?SQLAdmin, I am actually talking about the logs table for Subtext, not the DB logs http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment12http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment12Fri, 29 Apr 2011 17:39:07 GMTSQLAdmin commented on What were you doing with last year logs?Shrinking database might affect performance since the sql engine requires empty space to work efficiently So a maintenance over data and log files when server load is minimum or minimized to leave enough space for database engine not to extend datafiles within day time is important. http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment11http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment11Fri, 29 Apr 2011 12:57:06 GMTEli Weinstock-Herman commented on What were you doing with last year logs?I agree the default settings for a new MS SQL Server DB leave a lot to be desired, although I think the reason they leave it unbounded by default is because they are trying to provide a situation that works in all environments. Personally I would put the max size at 10MB and force implementers to define a max size and growth strategy, with some easy cookie cutter options (like blogging) for users that don't need to spend the time learning a whole DB system just to turn on something basic. It isn't difficult to add bounds (database properties, files, change autogrowth settings) or if you want to limit the amount of growth you can switch the database's recovery model to Simple mode (somewhere else in properties - in Simple it only uses the transaction log for in process transactions so it won't grow the database log file unless you execute a transaction that is enormous enough). This should also solve the fragmentation issue as long as the log file size is large enough to handle your current transaction sizes (as it won't need to autogrow and won't need to be shrunk). http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment10http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment10Mon, 25 Apr 2011 18:35:36 GMTGian Maria Ricci commented on What were you doing with last year logs?With Sql server usually it is best keeping logs in another filegroup stored on different physical file, you can avoid backing up logs each day, and the main file, with important data suffer less for fragmentation. http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment9http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment9Wed, 20 Apr 2011 07:34:19 GMTAyende Rahien commented on What were you doing with last year logs?RickRock, We actually do handle log trimming http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment8http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment8Wed, 20 Apr 2011 07:34:08 GMTRickRock commented on What were you doing with last year logs?LOL, Ayende, you which tool eats up 4 Gig for its logs in a breeze on my box and does not offer rolling logs (yet)? NHProf :-) See it as a feature suggestion. http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment7http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment7Wed, 20 Apr 2011 07:24:16 GMTAyende Rahien commented on What were you doing with last year logs?Frank, Just host RavenDB embedded. As for the rest, give me some time :-) http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment6http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment6Tue, 19 Apr 2011 19:29:59 GMTFrank Quednau commented on What were you doing with last year logs?Wayne, find me a host that hosts RavenDB at a price competitive to winhost, and I'll start writing a blog engine running off RavenDB :) http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment5http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment5Tue, 19 Apr 2011 18:45:53 GMTwayne-o commented on What were you doing with last year logs?You're using sql server? pfft ;) http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment4http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment4Tue, 19 Apr 2011 14:21:38 GMTtobi commented on What were you doing with last year logs?I hate deleting data. Who knows what information you could derive from those stats in the future? I recomment moving that table to an archive DB (delete from tab output into ArchiveDB.ArchiveTab) or a bcp file. http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment3http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment3Tue, 19 Apr 2011 11:00:03 GMTAyende Rahien commented on What were you doing with last year logs?Mark, When you remove 90% of the data, you probably need to do that anyway, since you already fragmented everything by removing the data. Also, this makes the size of backups much more managable http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment2http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment2Tue, 19 Apr 2011 10:48:47 GMTMark S. Rasmussen commented on What were you doing with last year logs?Do note that shrinking the database is one of the worst things you can do for performance, unless you ensure to defragment all of your indexes afterwards. Granted, with a 200MB database, you'll probably be fine as the dataset is so small. http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment1http://ayende.com/4816/what-were-you-doing-with-last-year-logs#comment1Tue, 19 Apr 2011 09:49:26 GMT