Install SQL Server for best performance

Last Post 14 Mar 2007 08:29 PM by davidlima. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
davidlima
New Member
New Member

--
14 Mar 2007 08:29 PM
Install SQL Server for best performance

I currently have a .net application that uses SQL server 2000 svcpk3a as the back end to a custom .net application.

My question is where should I install the SQL Server, SQL Data, and the .net web app to get the best performance.

Meanwhile server 2003 Enterprise, iis, and the .net frame work is installed on the crive.

My server hardware is configured as follows:

HP Proliant 360

(2) Dual Core Xeon processors
8Gb of memory
(6) Hard drives total-
(2) setup as mirrored drives on separate controller that makeup the crive
(4) setup as RAID drives on separate controller that makeup the drive


So with this configuration should I install my sql server application on the crive and place the sql data on the drive.

Also where should I place the actuall web app. On the crive with the ISS and .net installation or on the drive

***Install option 1***
Crive (2) mirrored drives
iis and .net frame work
.net application

Drive (4) RAID drives
SQL Server application
SQL Data

***Install option 2***
Crive (2) mirrored drives
iis and .net frame work
SQL Server application

Drive (4) RAID drives
.net application
SQL Data

Respectfully,

David




Acceptable Use Policy
---