Hello. We currently have SSAS and SQL Server on the same machine combining our OLTP and OLAP. We are having severe performance problems. So we are...
I am seeing a high % of suspended transactions on PAGEIOLATCH_SH and CXPACKET. The server is 64 bit and has 8 cpu, 12GB memory, SQL Server 2005...
Separate names with a comma.