December 9, 2009 at 7:40 am
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...
December 10, 2009 at 2:04 am
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...
Hi,
First find the "transaction blocking a process running on dba2" using sysprocesses.
Also run server side trace
Read the Gail Articles :Finding the Causes of Poor Performance[/url]
http://www.simple-talk.com/content/print.aspx?article=666
>Check the perfmon counters
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
December 10, 2009 at 3:06 am
Also CPACKET denotes parallelism waits. You might want to expiriment with MAXDOP settings
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply