As a matter of interest how much latency is to much (I know, how many angels can you fit on a pinhead) ?
We've had a few DBA types come and comment on long SQL queue lengths associated with disk i/o - the SQL luns are connected via iSCSI.
As far as the end user is concerned performance seems fine for things like SharePoint and CRM. Even Exchange. However a few apps with high i/o (mail archiving to database and SCOM which seems to thrash the database) do seem to suffer a little in terms of slow response time.
Do people have tips for optimising iSCSI performance (targets are ESX servers, Exchange on physical hardware and SQL on a mix of physical and virtual servers) ?
What key counters should I keep an eye on ?
Fibre Channel is still prohibitively expensive plus 10GbE seems very promising and more pervasive than a few years ago.
Cheers, Raj.
On 10/3/09, Romeo Theriault romeotheriault@gmail.com wrote:
I think everyone would be interested in the updated version!
Great! Ok, I'll put up the version that can also filter on aggregates on Monday. I hadn't put it up earlier mainly because it takes a bit more setup to get working. I used the netapp perl api to access the aggregate information so it also requires a user account with the appropriate api permissions and the associated netapp perl api modules. I just haven't gotten around to figuring out if I can legally bundle the netapp perl modules and just generally putting it in a easily usable package for the general public. I'll try to figure out the details on monday and see what I can get out, with or without the netapp modules.
-- Romeo Theriault System Administrator Information Technology Services