October 14, 2005 at 5:58 am
Hi,
I need to put together a specification for a customer for an sql server.
Is there some documentation somewhere or, some advise on calculating memory, cpu power, etc?
If a database size is say 1gig, and the server has 1gig of memory, does that mean, everything would be cache in memory and therefore run quicker?
What does an sql server need most, processor power, or memory?
Does more users accessing the database require processor increase or memory increase?
When should clusters be considered?
These sort of question I need to work out in order to build the spec.
Regards
Andy
October 15, 2005 at 6:54 am
This article should help you on the way:
http://www.sql-server-performance.com/rc_hardware_planning.asp
Sql server performance: 80% application+design,20% hardware
Hardware performance benefits: memory (the more the merrier-> less slow IO activity needed),IO subsystem, cpu (as this is more a job for the clients)
My current sql server looks like:
2 gb ram, athlon 64 + 3400, RAID 1 OS 2*raptor, RAID 1 Data (2*7200 sata)(currently a bottle neck, to be replaced by raid 10 SCSI), RAID 1 Transactions logs (2*7200 sata)
This for +- 60 users and 200 connections.Activity: users: more read than write, batch: writes
Availibility: a hot standby server with transaction log shipping
Clustering can be implemented for availibility/loadbalancing reasons
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply