Mark Breen
marklbreen at gmail.com
Sun Jul 3 12:16:53 CDT 2011
Hello John, With a memory of a gold fish these days, I was reluctant to mention the simple recovery mode in case we had already discussed it in detail. But I would have expected that if you have simple more enabled, your logs would never grow too large - is that the case? That was my main reason for asking, however, I read your following emails with green envy - I love your setup. Thanks Mark On 2 July 2011 15:28, jwcolby <jwcolby at colbyconsulting.com> wrote: > Mark, > > > > Just curious, what prompted your question? > > When I got into this business I bought a 16 port Areca RAID controller and > a bunch of 1 TB drives. I built big arrays and RAID06 volumes for maximum > reliability and as much speed as I could muster. I created 2 tb partitions > and placed my data files on one and my log files on another. Awhile back I > bought a pair of SSDs > > http://www.newegg.com/Product/**Product.aspx?Item=**N82E16820227590<http://www.newegg.com/Product/Product.aspx?Item=N82E16820227590> > > And made a 220 GB RAID 0 array and placed a set of three databases (my > "central" databases) on there for speed. > > This last week I was doing some Update / Append operations on some of these > databases and ended up with "disk full" - stopped me cold!!! Luckily I was > able to move the logs off to rotating media and let them complete their > operations and then finish up what I was doing. Anyway... > > > I upgraded the server last night. I added a very reasonably priced (and > reasonably powerful) RAID expansion card called the ASUS PIKE 1068E raid > controller. It only supports Raid 0 and 1 but that is perfect for this > application since I am using Raid 0 for these volumes. It also has no write > cache so it is not appropriate for high write applications. > > http://www.newegg.com/Product/**Product.aspx?Item=**N82E16816110042<http://www.newegg.com/Product/Product.aspx?Item=N82E16816110042>ASUS PIKE > > and four new SSDs to hold the central database files I work with: > > Mushkin Enhanced Callisto Deluxe MKNSSDCL120GB-DX > > http://www.newegg.com/Product/**Product.aspx?Item=**N82E16820226152<http://www.newegg.com/Product/Product.aspx?Item=N82E16820226152> > > > > Just curious, what prompted your question? > > What I was trying to discover was when log files are used in order to > discover how much room I needed to give them. I had all of the databases > and their log files on a single RAID0. I was doing some appends / updates > and the log files filled up the disk, which is what prompted the expansion. > > In the end I decided to put the data files on a new RAID0 created from the > 4 new SSDs (~440 GB) and leave the log files on the old RAID0 using the old > two SSDs (~220 GB). > > I really only write to these files roughly once per month, but I ended up > doing some processing unrelated to the monthly thing. > > ATM the data disk has 160 GB used (280 GB free) and the log file disk has > 18 GB used (204 GB free). That should hold me for awhile, but I still have > 4 more SATA ports on the Pike controller if I need them. > > > John W. Colby > www.ColbyConsulting.com > > On 7/2/2011 6:25 AM, Mark Breen wrote: > >> Hello John, >> >> Just curious, what prompted your question? >> >> Mark >> >> >> >> >> On 2 July 2011 00:16, Francisco Tapia<fhtapia at gmail.com> wrote: >> >> It's for updates and inserts only, read operations may use the tempdb >>> depending on how you constructed the select... >>> >>> Sent from my mobile >>> >>> On Jul 1, 2011, at 4:04 PM, jwcolby<jwcolby@**colbyconsulting.com<jwcolby at colbyconsulting.com>> >>> wrote: >>> >>> Are log files used for read operations or only data modifications? >>>> >>>> -- >>>> John W. Colby >>>> www.ColbyConsulting.com >>>> ______________________________**_________________ >>>> dba-SQLServer mailing list >>>> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >>>> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >>>> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >>>> >>>> ______________________________**_________________ >>> dba-SQLServer mailing list >>> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >>> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >>> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >>> >>> >>> ______________________________**_________________ >> dba-SQLServer mailing list >> dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> >> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >> >> >> ______________________________**_________________ > dba-SQLServer mailing list > dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> > http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> > http://www.databaseadvisors.**com <http://www.databaseadvisors.com> > >