Please post your discovery after you resolved this issue. I am curious to know about this too. I have several SQL Server Clusters running on physical box. I am going...

Could you switch the cable between these two nodes and test it? or switch the nic cards

Did you check HBA card?

It looks like the sql instance has some delay to reach the SAN storage on node1 . Check the fibre channel or iscsi connection.

Are you using mound point for your shared drives?

Congratulations !!

I agreen that grant SQL SERVER Services account "Lock pages in memory" permission is a good practice.

They only work in some SQL Versions

http://support.microsoft.com/kb/918483

Note For 64-bit editions of SQL...

Thank you for the Link.

Our System Admin sent email to ask Microsoft, I can not believe their recommendation is still let OS manage the pagefile.

Our standard servers are...

Thank you All for the information. That is very helpful. ( That is why I like SSC so much)

You do not have to restart the box. restart sql server service should make it works. Could you post me the stat ? By the way, I think you gave...

Did you restart the sql server after you change the max memory setting?

Thank you!:-P

I would say. No.

They come from different sessions.

My point is if you configure too much memory for SQL Database engine. You ssis service on the same server has to compete withe other services and OS , It...

SSIS using seperate memory with SQL Server database engine. If you configure the max memory in SQL Server service. It will be used by the SQL database engine. The rest...