thank you guys for providing such informative input..appreciate it 🙂

I have added in the counters recommended.. hopefully it will give me a hint of what is going on..

I see, thanks guys for the input... is there any tools that can help me to verify that?

Hi,

we are having the same problem couple of times. Did anyone manage to get rid of it? Or did unistalling the security patch solved the problem?

Currently I am still not able to install sp4 in production as it will impact some of the applications running there.

Do you think security patch MS03-031 will fix the problem?

Hi Rudy,

Thanks for your feedback.That really help me to get started.

by the way.. how large is your database currently and how frequent that the users pull reports from it?

thanks you guys.. i'm clear now..

ok.. thanks for the tip

Have a nice day !

SRB,

My total server memory actually is 8GB.

oh one last question...I have configured my max server memory for node A to 4GB and node B to 3GB is it ok? If not what will be the recommended...

Appreciate all your valueable input guys ... it really solve my puzzle now...

hmm now I can sleep in sound *just kidding* ...

Thanks for the useful tip.

But how about the memory utilisation between the 2 scenario? Which will be more efficient (since both max server memory also being configured to 3GB)?

By the...

HI Ford,

thanks for the feedback. Maybe my question here is not clear enough.Here's further elaboration on my question.

2 scenarios:

1. with total 4GB RAM being configured to 3GB memory as...

Hi Mat,

Is it ok for you to send your project plan to my email: techmail.blueivy@gmail.com?

Really appreciate it.

Thanks.

Thanks for the valuable input guys...

Really appreciate it

fhanlon,

cool.. I have been looking for this kind of tool... thanks!!

will give that a try on this coming scheduled downtime

Hope to see...