CpqCiDrv.sys ILO driver kills SQL Server 2005 on Windows X64

[Rob Hill HP]

We opened a case with Microsoft support (SRX060309601666) after seeing erratic SQL Server 2005 memory allocation under Windows X64 on several DL385's with 8GB RAM.

They are claiming that the problem is with CpqCiDrv.sys and that any application could be impacted, not just SQL Server 2005.

The symptom with SQL Server is it paging massively every few minutes under load; the greater the load, the more frequent the paging. You can see the memory for sqlservr.exe get robbed in Task Manager. At the peak of the paging, SQL Server becomes unresponsive and then recovers, then the cycle starts over.

Has anyone else seen this? Does HP know about it?

There are two fixes at the moment: one to disable the ILO driver, the other two give "lock pages in memory" permission to the service account for SQL Server.

Thanks,

Rob