Thank you! The slow node's driver...

Evil Kraig F (2/27/2012)

---

*vivian* (2/26/2012)

---

The environment is a cluster. Only this node is having weird problem. Once move the SQL instance to the other node, run the query locally it...

Hi All, thanks for all your comments! I just find something new:

I uses xevents to trace the query execution. I tested the same query from local SSMS(node A), and from...

Evil Kraig F (2/22/2012)

---

*vivian* (2/22/2012)

---

Hi Brandie,

The query I run returns a lot of data (50000), do you think it could because both server activites and client activites happen on this...

Hello, thanks all for replying! we have set max memory for this SQL. And it seems not a sql server configuration issue.

The environment is a cluster. Only this node is...

Hi Brandie,

Thanks a lot for your reply. yes I have been running them several times, excution plan is same, and difference I see is locally it consumes more 'client processing...

David Levy

SQL 2005 caches a lot of things in tempdb, most tied to a query plan. Try a DBCC FREEPROCCACHE then you should be able to shrink. I should mention...

The server OS version is windows server 2003 standard edition, I see currently the server has 1.5GB avaliable memeory, so should be ok if enable /3gb? coz we may not...

Hi MUTHUKKUMARAN, thank you so much for your great help. I accquire a lot from your post.

However We may not be able to upgrade the software in short time....

Hi, I attached 2 query plans for 2 of the slow queries, thanks again :--)

Hi muthukkumaran, thanks a lot for taking your time on this, really appreciated. Below is my update to your queries:

1.What is the database size?

-- 109GB

2.Are you feel slowness always or...

Thanks so much for your reply. I just had a look at the query plan for 2 queries and didn't see table scan, most are the index scan or index...