Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Performance Issues

Author  Topic 

poser
Posting Yak Master

124 Posts

Posted - 2013-01-08 : 12:28:55
I have a user showing up in Activity Monitor Processes.
It has a lot of entries for the same session ID 250.
this same user says it is blocked by itself (250)
Wait Type: LATCH_EX
Wait Resource: ACCESS_METHODS_SCAN
Also there are for ID 250
Wait Type: CXPACKET
Wait Resource: exchangeEvent id=port1812df....

My server is really running at a crawl. Not sure if this is a side effect something else or SQL?
Thank you for any help you can offer.
R/P

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-01-11 : 10:39:13
1) Check which queries are running currently with http://www.sqlserver-dba.com/2012/09/sql-server-current-queries-executing-on-sql-server.html
Analyse them. What is the 250 doing ? Is it a user query or a maintenance task?
2) Is hyperthreading turned on?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -