mithun gite (6/20/2008)
should i need to put switch of 3gb to increase the memory?
Your memory is not the issue. Your drives are the issue right now. First thing is to fix the IO slowness as that appears to be the dominent bottleneck right now.
Can you check the disk fragmentation of each drive?
How do you have a Raid 5 config with only 1 physical drive? Raid 5 requires minmum 3 drves.
What's on the E drive? Backups?
What I would strongly suggest:
Get 3 more drives (physical drives, not logical partitions)
Put the data file on 1. Put the TempDB database on a 2nd. Put the log file on a third. That should ease the IO contention.
The problem is that you have 1 physical disk, so all the reads and writes to your user db, tempDB, the windows swap file and all the system files are condending with each other.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability