mithun gite (6/20/2008)
would it this immidiate change will benefit me a bit or not ?
No. They're still on the same physical drive. c, d and e are just logical splits of the raid 5 array you have. You need to get the data file, log files and tempDB onto seperate physical drives.
and should i use index tunning wizard ? and how abt that 3gb switch?
Wait on that until the drive configutration is better. It may not be necessary.
and also can u give me any check list for the performance counter whiich gives the should be ideal data for the processes ,so i can check or should set some alert on that those values...
sec/read and sec/write should be under 50 ms
buffer cache hit ratio should be above 90%
those are the two main ones I can think of.
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