Hope someone can help me with this problem.
I have two databases db1 and db2
Both have high concurrency at all times during the day, at certain point I start getting complaints about the speed of transactions, when I check the process monitor I get a lot of CXPACKET, LATCH_EX, PAGEIOLATCH on diferent transactions, the problem is the transaction blocking a process running on dba2 it's running on db1.
Tried adjusting the paralelism degree but it didnt solve it...
Am I having I/O bottlenecks?? How can I find out if the problem is the CPU, RAM, hard disk or network???
Sorry for any gramatical errors, English it's not my native languaje.
Please Help me...