Z, 1. 30 concurrent users for an accounting/warehousing application. 2. OLTP 3. We will be pulling reports from within the application but, I feel that is not what you are referring to here.
Thanks for your response Few questions: 1) 30 Concurrent users correct, or just a max of 30 users. 2) Are the transactions OLAP or OLTP in nature. 3) Will you be doing reporting off this database server (not recommended) Here are some things to keep in mind. 1) Split your Disk into LUN's for the database and logs and temp DB ( not partitions but physical LUN's (RAID 1+) for Data, RAID 1+0 for Logs, RAID 5 for temp) 2) Use multiple controllers, with a high level of cache 512MB or higher if using local disk to help on transactions. 3) Consider having a temp DB for each physical processor in your system. Dual and Quad Core Processors with 8-16GB of RAM and Windows 2003/2008 Enterprise along with SQL 2000 Std/Enterprise would be a good starting point, but you can probably get away with less with your setup with Win2003 STD and SQL 2005 STD. HTH Z Edward E. Ziots Network Engineer Lifespan Organization Email: [EMAIL PROTECTED] Phone: 401-639-3505 MCSE, MCP+I, ME, CCA, Security +, Network + -----Original Message----- From: Chad Leeper [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2008 11:37 AM To: NT System Admin Issues Subject: General hardware setup recommends for a SQL 2005 database server Hi all, I am building a 2005 SQL database server that will be supporting 30 users. The front-end for this database will be on a separate box. Does anyone have any hardware recommendations. i.e. number drives, ram, etc? I prefer HP hardware but, I welcome any input. Thanks, /Chad Think green. Please consider the environment before printing ************************************************************************ ************************************************* CONFIDENTIALITY NOTE: The information contained in this transmission is privileged and confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this transmission in error, do not read it. Please immediately reply to the sender that you have received this communication in error and then delete it. Thank you. ************************************************************************ **************************************************** ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ Think green. Please consider the environment before printing ************************************************************************************************************************* CONFIDENTIALITY NOTE: The information contained in this transmission is privileged and confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this transmission in error, do not read it. Please immediately reply to the sender that you have received this communication in error and then delete it. Thank you. **************************************************************************************************************************** ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
