Em Andamento

SQL 2000 System Reccomendations


The scenario that I'm working with is that I'm building a reporting server running Crystal reports & SQL 2000 that will have approximately 300-400 users (I'm guess 10-20 concurrent queries max). It will be dealing with about 5-10 million records and each rec is 500-1000 bytes. The ideal situation is to be able to store a large portion of SQL data in memory. I am looking for some reccomendations on software (SQL 2000 Std. vs. Ent. & Win 2K Std. vs. Adv.) and hardware setup (GB of RAM, RAMDrive, etc). I am assuming that any possible solutions will require use of the /PAE switch and using AWE in SQL (cannot use in SQL 2000 std), so I'll need any specific info on these settings as well.

1) Since SQL server 2000 Standard only supports 2GB of RAM, is there any point to installing a 4GB Cenatek RAM drive (pretty damn fast) to put the OS paging file onto? Will SQL be able to retrieve data from the paging file on the RAM drive, or will it just clear out data once it reaches it's 2GB max? I thought this might be a good solution if SQL data can be stored in the paging file and since the paging file is usually on a hard drive.

2) If installing the RAM Drive won't help, do I need to purchase SQL 2000 Enterprise and/or Win 2K Advanced and get a board that will support 8gb of RAM?

3) If I have SQL enterprise and Win 2K Std, can I buy a board with 8GB mem and have SQL use 7GB and Win 2k use 1GB, or will SQL not even see it if Windows 2K Std doesn't see it?

Take your best shot here, I need a reccomendation for the preceding issue and questions. Whoever has the best case will receive funding.

Thanks! --Justin

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

Windows 2000 Standard/Advanced and SQL 2000 Standard/Enterprise.

Habilidades: Engenharia, Microsoft, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, Hospedagem Web, Gestão de Site , Teste de Website, Área de trabalho do Windows

Ver mais: source best solutions, pae, fast switch, data request system, crystal reports 10.0, t-sql with, t-sql in, sql server max, max sql server, crystal reports 11, best case software, t-sql;, std, sql support, SQL Server Reporting, Sql reports, Sql reporting, sql data, reports sql server, rec, get sql help, Enterprise solution, ENT, data source sql, damn

Acerca do Empregador:
( 7 comentários ) United States

ID do Projeto: #3004330

Premiar a:


See private message.

$42.5 USD em 3 dias
(1 Comentário)

4 freelancers estão ofertando em média $27 para este trabalho


See private message.

$42.5 USD in 3 dias
(0 Comentários)

See private message.

$3.4 USD in 3 dias
(0 Comentários)

See private message.

$21.25 USD in 3 dias
(0 Comentários)