jflzc (12/9/2009)

---

Hello,

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...