Sign in to follow this  
tdwyer

1 Terabyte home pc advice

Recommended Posts

Guest russofris

For information on DSS performance, I recommend that you contact Tri Hua or Sean McGrath in the iDSS department at MS (If the dept still exists). They are blue badges, so no "v-" is necessary in their e-mail address. They do nightly cube builds off of multi TB databases and will have a much better idea of the time/IO/system requirements.

When I worked there, we were using quad proc Proliant 5500's (P3-800 Xeon? I forget). The SQL DB was 1 TB on a raid 5 array and took 8 hours to complete the OLAP transformation.

I did not depart on good terms, so it may be beneficial for you not to drop my name when contacting Tri. Sean is a a bit more technical and will be far more receptive to your questions. Just don't waste his time (ask specific questions, have a list, etc...).

iDSS was formerly known as Webstats.

Thank you for your time,

Frank Russo

Share this post


Link to post
Share on other sites

On the 3ware card.

I Looked thru the PDF file, Saw 64 Bit but no mention of 66MHz?

Just becase it fits into a 66Mhz Pci slot does not mean it's 66Mhz 8O

Share this post


Link to post
Share on other sites

I have had a nightmare since I started this upgrade and have finally

reached the pinnacle of situations.

Basically here goes.

Previosly I had the Coolermaster A200 vase with single A7m266 MB with

1ghz athlon. I just purchased as A7m266-D + 2*1900+ bundle from

overclockers.co.uk. Also I upgraded my PSU to the Enermax 450W.

I installed everything and found that the operating system did not

like the changes (.Net Standard Server) - although annoying this is

accepted, so I started reinstalling. however this did not go at all

well and left me with 56gb of data loss on the second drive - the

system kept rebooting and the install never completed - therefore the

data got corrupted and I had to refomat - anyway I finally got another

install working and running all day

I called overclockers support and he mentioned that my cpu's may be a

bit hot so check the thermal compound. I attempted to do this but

could not get the cooler off the chips so I reassembled the machine

and switched it on - BLACK SMOKE came pouring out of the machine - the

central pin on the enermax psu (the meduim size adapter) was fried -

and all the plastic had

melted away from the cable.

The kit is going back on an RMA.

Now for another depressing although pleasing to see a supplier being this good. I had contacted a company called Armari about quoting for a system - they did not get back to me so I went my own route - they now however have come back with a quote - and the thought that I could get this built for me and not have to get into the hardware myself is very appealing - I might even end up buying this system as a second terabyte !!

I have included the quote because people here may be interested and so far eveyone here has been really helpful.

Qty Description

1 Armari S30 Professional Dual Processor Workstation enclosure (dark grey)

8 x 5.25" External Drive Bays. supplied with 8 x 5.25" Drive Trays

Dimensions : 437mm (H) x 220mm (W) x 570mm (D)

300 Watt power supply (Twin redundant Power supplies available)

1 Tyan TigerMPX (S2466N-4M) / Dual AMD Athlon MP / DDR ECC / EATX Motherboard

Chipset: AMD 760MPX Chipset.

Special Features: Integrated 3COM 10/100 LAN (3Com 3C920 ASIC)

Special Features: new rev. with fixed on-board USB1.1 ports

CPU Support: Single or Dual AMD Athlon MP with 266/200MHz FSB

CPU Front Side Bus Speed(s): 266/200 (133/100 DDR)

Memory Support: PC2100/PC1600, DDR registered modules only, ECC optional.

Max memory: *4.0GB, in up to 4 memory modules.

Note:*The AMD-760 MPX requires a portion of memory to be reserved for PCI devices. Depending on

the adapter cards installed available memory may be reduced down to 3.8-3.5GB.

On-Board Sound: n/a

Slots:1 x AGP 4X, 2 x 64/32bit 66MHz(3.3v) PCI, 4 x 32bit 33MHz PCI - 7 Max

Disk Controllers: AMD-768 South Bridge

Disk Interface: 2 x UDMA 100/66/33MB/sec channels (4 devices)

RAID Interface: n/a

ATX Backplate: PS/2 Keyboard & Mouse, 2 x USB 1.1, 2 x 9pin Ser.,1 x Par. RJ45

ATX Backplate Audio: n/a

Motherboard I/O: 2 x IDE, 1 x Floppy

Motherboard Header plugs: 5 x FAN (2 x CPU,3 Case), 2 x USB, SMBUS

Motherboard Audio Headers: n/a

BIOS: PHOENIX ACPI BIOS.

PSU Requirements: Minumium 300Watt ATX/ATX12Volt

2 AMD Athlon MP 1500+ / 266MHz FSB Socket A CPU (1.33GHz)

Dual processor capable version for 760MP/MPX chipset motherboards only.

Features 384KB total on-die CPU cache. (64+64KB L1 & 256KB L2 Cache)

Athlon 4 Enhanced instructions support: 3DNOW,MMX and SSE.

2 512MB 133/266MHz ECC Registered DDR SDRAM (PC2100)

(Corsair CM73SD512R-2100 Single Bank module)

1 Gainward Geforce4 PowerPack! Pro/650 XP 'GS' 64MB AGP 4x Graphics Card

Interfaces: VGA, DVI, TV Video In / Video Out, nView Dual Monitor

Board featues: GS='Golden Sample' board design allows enhanced clock settings offering up to 15%

faster 3D performance. Gainward?s unique High-Performance/Wide-Bandwidth hardware design.

Graphics engine: 256bit nVidia GeForce4 MX460 GPU

Default clock speed: 300MHz Core / 275MHz (550MHz) DDR Memory

Card to PC Interface: AGP 4x/2x (1.5volt)

Memory: 64MB FastDDR. Bandwidth: 8.8GB/Sec. Memory Bus : 128Bit DDR

Fill Rate: 1.2 Billion Samples/Sec.

Special Features:

Integrated Transformation & Lighting (T&L)

2 x pixel pipelines, 2 x Texture units per pipeline, 2 x Textures in a single pass

Lightspeed Memory Architecture II

VPE - Hardware MPEG2 decoding engine

Accuview Antialiasing (AA)

nView Display Technology for enhanced Dual monitor configurations

Two independent 350 MHZ RAMDACs for chrisp high resolution Dual displays

High-definition video processor (HDVP)

Cube environment mapping

Software: nVidia unified driver support for Win95,98,Me,NT4,2000,XP & Linux

Hardware accleration of Microsoft DirectX D3D 8.1 & OpenGL 1.3

8 Western Digital Caviar 120GB 3.5" X 1" Hard Disk - Model no. WD1200JB

Spec: 40GB/Platter, 7,200rpm, 8MB Buffer, 8.9ms avg. seek

Interface: UDMA/100

Sustained Data transfer rate: 48.9MB - 29.2MB/sec (outer -to- inner cylinders W2K)

Warranty: 5 Years from manufacturer

1 3Ware Escalade 3W-7800 UDMA/100 32/64bit PCI RAID Controller.

Hardware RAID processor and on-board cache significantly reduces CPU overhead for RAID

operations. Intelligent management of drives. Remote management of Array through Web-based

management utility.

Supports 8 x UDMA/100 Drives each running on it's own dedicated UDMA/100 channel & cable,

delivering enhanced fault tollerance and stunning throughput.

Supports hardware RAID 0,1,5,10, JBOD with IDE Hot Swap on supported bays

Extensive Operating systems support including: Linux (Redhat , SUSE)

Windows NT & Windows 2000. Easy, user friendly Array setup and simple driver

installation.

(NOTE : This is an OEM card and will require ATA-100 HDD Ribbon Cables)

8 3Ware 24" ATA-66/100 Hard Drive Ribbon Cable

1 Pioneer DVD-106S DVD-ROM 16x + 40x E-IDE CD-ROM (Slot-Loading)

1 Sony MPF520 3.5" 1.44MB floppy diskette drive

1 1st year On-Site Hardware Maintenance ( Provided FREE with Complete System )

System subtotal : £3,195.00

VAT @ 17.5% : £559.13

System total : £3,754.13

Best Regards

Trevor

tdwyer@email.msn.com

Share this post


Link to post
Share on other sites

asymmetric

How is your CK-1100 case working out?

I'm thinking about buying the same case. I'm also thinking that I'll punch holes in the motherboard tray for routing cables to the other side. In the photo it looks like there are two holes in the middle of the dividing panel. If I make some holes in the removeable tray I should be able to pass some cables thru. Does that seem like a feasible idea? :?: :?:

Share this post


Link to post
Share on other sites

You may want to double check that Western Digital 5 year warranty, all IDE drives that I know of have a max of a 3 year warranty.

Also whilst I have had no problem running a dual AthlonXP 1.47 GHz machine on a 300W PSU, I did not have 8 hard drives attached. I fear you may need more.

Share this post


Link to post
Share on other sites
Thanks very much for the detailed reply - acutally a friend of mine wrote the Inside SQL 2000 books - Kalen Delany :) I get a mention in the preface and she used me as test data :)

You know Ms. Delany? Wonderful! Any chance for me to get an autographed 'Inside SQL Server 2000'? :wink: I actually grab the book and immediately flip to the preface and see your name mentioned on page 'xxx'.

Tell her that her book is one of the best tech book I've ever read. No kidding. It beats all those MCDBA books by far.

Share this post


Link to post
Share on other sites

3ware's got a 12channel version now, the 7500-12. The 7450 and 7850 have been renamed 7500-4 and 7500-8. If you get the whitebox or retail version from http://www.hypermicro.com it comes with 24" single connector IDE cables that 3ware certifies will work despite being above the official 18" max.

Oh and with the release of the 12ch controller it took the $500 spot, the 8ch is now about $365, the 4ch $245, the 7210 $129 and the older 6410 controller is $99 (a good bargain if you ask me).

As for the people whining about the performance of IDE RAID, these arent your standard promise or highpoint crap. They have onboard CPUs just like a SCSI host adapter, they perform command queue, overlapping i/o, and elevator sort just like a midrange or better SCSI RAID controller. My 6400 peaks about 550 I/Os per second in iometer and will defrag with 3% CPU, so yes it can handle a modest database.

Share this post


Link to post
Share on other sites

True fractal, about the amps needed upon startup...

The 24amps you worked out is easily taken care of with the 30/40Amps output on the 12V line of the 2 top of the line Enermax PSU's, dont know where the story of Enermax's 5v lines being bad came from either...

Share this post


Link to post
Share on other sites

Before anyone needs to correct me, let me correct myself...

The 550Watt Enermax has the following:

Inrush current

60A max/230V (at cold start)

3.3V

50mV

40A Max

+5V

50mV

11A Min / 46A Max

+12V

120mV

4A Min /24A Max

-5V

50mV

1A

-12V

120mV

1A

+5Vsb

50mV

1.8A

Regards.

Share this post


Link to post
Share on other sites
You know Ms. Delany? Wonderful! Any chance for me to get an autographed 'Inside SQL Server 2000'?  :wink:  I actually grab the book and immediately flip to the preface and see your name mentioned on page 'xxx'.  

Tell her that her book is one of the best tech book I've ever read. No kidding. It beats all those MCDBA books by far.

I always want to get an autographed copy myself but I can never be bothered to take a copy on the plane with me :) I am in the uk she is in the states.

I agree it really is a good book.

Best Regards

Trevor

Share this post


Link to post
Share on other sites

Trevor, have you looked at any of the new external ATA to SCSI raid enclosures out there? They'd lick your power, cabling and cooling needs and might be in your price range. I am investigating a 14 drive 3U rackmount unit from Proware (http://www.proware.com.tw), they've an 2U, 8 drive unit that would work well for you, especially if you wait for the 240GB Maxtors to come out. Check out Axus as well (http://www.axus.com.tw), both companies use the same raid controller, but have different cases and prices.

I just spec'ed out a 14 bay Proware system with 8 x120GB drives for about $5400. The folks at both Area (http://www.areasys.com) and Carday (http://www.cardaysupply.com) are super helpful. Look at both Synetic (http://www.synetic.net) and Zero-D/Frbrenetix (http://www.fibrenetix.co.uk) as well.

Good luck!

Z]

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this