SQL Galaxy (8/18/2014)
1. What's normal for this server for those counters?I am not sure those counter normal values, It might be < 500 seconds for better (soft/hard page read seconds)
Then you need to establish baselines. Without baselines for what is normal for the server you cannot make any sense of most perfmon counters.
3. Do you have a lot of non-SQL apps on the server which are getting paged out?
how did we check Non-SQL apps paged out or not? But DB & Apps should be same machine as per application architecture
Well, I assumed you'd know that, because having non-SQL apps with paging issues is one of the few reasons for looking at page faults/sec. SQL doesn't use the page file and, if it does get paged out there will be error messages. If you don't know, why are you looking at that counter? What do you expect to discover from it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability