My results from SQLIO are just wrong. I have a 6 drive RAID 10 array with SAS disks 10K RPM. SQLIO is saying I am getting max of 8000+ IOps. I am using a 10,240MB file, random read, 1 thread per file, 4 Outstanding IOs, 4-32 request byte size.
How do I prevent caching? HP 400 controllers have 100% read cache only (no-battery backup I just found out). Windows 2008 enterprise. You can't turn the cache off on the controller.
Thanks, Chuck
I have a complex environment, many highend cisco network boxes, firewalls, and routers. I have many (100-200) connection timeout errors (just authenticating, not running any queries) connecting from IIS to SQL server 2005 using windows authentication. Our network engineers have poured over tcp/ip dumps, we don't have AD experts in house, Kerberos doesn't seem to work in our db environment, so I thought you all might be able to point to documentation on how IIS makes a connection to SQL server where the domain of the servers are different from the domain of the user and the user's domain is housed in another state over dedicated leased lines. Both locations have redundant DC controllers and site metrics setup. Network geeks think that the time it takes kerberos to fail and default to NTLM could be issue.
More info: We brought in MS premier consultant again, and we found LSASS.exe sp? was consuming tons of CPU on AD boxes. Culprit was Barracuda SPAM box doing queries against AD for non-existant meta data columns. If I found out how he figured that out, I will post.
TIA, Chuck