Hello guys,
I've enabled data collection on sql server 2012 sp1 because in the last time users are complaining is slow.
On the output report I see that top waits are PAGEIOLATCH_SH,CXPACKET AND CLR_SEMAPHORE.
The server is a HP proaliant dl380 with two separate raid 1 on scsi disk (10k) with 1Gb of fwbc cache distributed 75% on write and 25% on read, so I cannot explain why this behavior.
Sometime I've see on the SQL Log "memory pressure" , but database is about 14Gbyte and ram on server is 16Gbyte so it would be enough for put in cache all db.
How I can find statements or procedure that cause this issue?
Thanks!
Andrew