I hate to keep a resolved thread going but I'm a bit unclear on both switches. I've gone through all the steps for enabling AWE and that is all...
Great. Thanks Joe. This server is not going to have an I/O subsystem commensurate with the quad core 2.66Ghz chip...so no need to spend money on...
Hmmm...maybe I should consider the Quad Core (E5355) over the Dual Core (5160) Some compares...(although the E5355 in this comparison is the 2.33Ghz...
So, since we are talking about SQL Server here - which is pretty darn good at using SMP, I would think the 4 core might be desirable. Again, this is...
I am about to buy a new box and I am trying to decide between two base configurations that are essentially the same price: 1) HP ProLiant DL380 G5 -...
Ok, how's this. I'm toying with the idea of 64K clusters and 256K RAID5 stripe size. Or 8K cluster size and 64K RAID5 stripe size. Here's an...
C: (binaries and tran logs)= 2x72GB 10K SAS D: (SQL Data files) = 6 x 72GB 10K SAS with 256MB on RAID controller. DB is 6GB. Not worried about disk...
I've not had much experience with non-default settings. The default cluster size for my windows boxes is 4K and default striping for RAID5 is 64K....
Thanks Joe. Yes, they will be SAS drives. RH
I'm under the impression that 72GB drives will outperform 36GB drives when storing the same amount of information. I think this for two reasons: 1)...
It's coming back to me now... The DL380 G5 only supports SAS internally. Your right, externally I could still get SCSI. My server team had a...
quote: i do not know why you are complaining about not reaching 8x15K, the G4 can't do that either I'm not complaining. I have a current G4 with 8...
I've built some procs that execute parameterized queries using sp_executesql. Essentially: EXEC dbo.spCallDataProcs --> calls one of many...
I have a dedicated SQL box that I am trying to replace. The system I am replacing is a Dual 1.2 GHz machine with 2GB RAM and 4 X 15K U320 SCSI in...
Thanks. I think we are in agreement. RH
Joe, you've made an interesting statement in your hardware recommendation post that I've quoted below. quote:Originally posted by joechang data...
Yes, I've seen your post - it's very helpful. Unfortunately, the listed configs are way above my budget. This server is currently running on a...
Alright, sorry for so many questions in one post - but I have several things I'm trying to hash out. First, I'm building a new SQL box. My budget...
Separate names with a comma.
