SQL Server Performance Forum – Threads Archive
Disk array controller CacheI have Compaq servers with win 2000 and sql server 2000 I have some problems as the clients hang some times having the work stations blocked. I have been told that this could be also due to the disk controller cache. I have been advised to dis-activate the cache. Is this right and can some one advise. A Viegas
If it strikes again check connection on the SQL server by using SP_WHO and check whether any blocking is persisting. Also capture few h/w counters like physical disk, processor, process, memory alongwith SQL server counters for assesment on the system usage. Fyihttp://www.sql-server-performance.com/fixing_bottlenecks.asp Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Also monitor Hit cache ratio.
BTW:What kind of RAID do you have? Luis Martin
SQL-Server-Performance.com The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
I agree with Satya on this, if blocking is due to disk controller cache, you should see large disk queue length and large write time during the blocking period. Gaurav
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
If you have a good controller, the cache really shouldn’t cause the issues you are experiencing. What do you have your cache set at? What are the percents of read/write? What are you seeing on the counters recommended here? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.