jwcolby
jwcolby at colbyconsulting.com
Sun Jul 3 13:08:28 CDT 2011
> That was my main reason for asking, however, I read your following emails with green envy - I love your setup. My envy is folks who have the knowledge to do things right instead of throwing hardware at it. But we all get what we get. It is a nice server. Imagine what it could do with one of our DBAs at the helm. ;) Hardware really is cheap though. I fully expect to just blow it out with 128 GB of RAM and another processor. Basically if I can keep the entire pair of tables in cache... It is strange to think about keeping 50 gb tables entirely in RAM. I keep getting more business though and the reason (I believe) is that I can get it done quickly. John W. Colby www.ColbyConsulting.com On 7/3/2011 1:16 PM, Mark Breen wrote: > 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> >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >