asked on

IBM server 3650 M2 with DS3400 SAN configuration

Hi All,
I have setup a SQL 2005 server in my IBM 3650 server connected with Fiber card to DS3400 SAN, my SAN is configured with 5 Disks each is 1 TB as RAID 5. the disks are SATA. my question is I have my 120 GB SQL Database which i feel its very slow in all the transactions.
can someone advise in what is the cause of the slowness, I have just 50 users accessing the Database. need help

Thanks

ASKER CERTIFIED SOLUTION

David

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Member_2_231077

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

David

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Member_2_231077

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ibrahim A

ASKER

Hi All,

Sorry its SAS disks and yes I do have two controllers, any help

Thanks

ibrahim A

ASKER

Hi All,

My server is quad core with 10 GB RAM.

ibrahim A

ASKER

Hello, I just login in to SAN Manager , its SATA.

David

well it can be 4 or 5, depending on firmware. some implementations check XOR parity on reads, and do further IOs to fix it if incorrect. ideally if you value integrity over performance, you want this extra IO ... as it also clears out unrecoverable IOs on parity blocks which would otherwise go unnoticed

SOLUTION

Member_2_231077

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial