468,306 Members | 1,192 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,306 developers. It's quick & easy.

CPU Time usage shown in EM-CurrentActivity/Process Info

Hello experts,

Here is my problem. We are using an application developed in C#, using SQL Server 2000 as backend. There are about 100 users using the same application Module for examle sales & marketing.

When I monitor the Process info in Enterprise Manager, I found that there are two threads for each user have created and also observed that the CPU time usage is growing gradually. After 3 to 4 hours time taking for fetching data, updating data and inserting data is more and literally the application performance become dead.

I noticed that if the user closed the application, then corresponding threads gets vanished from the EM, but if user left open the application and gone for breaking the threads remaing opening.

How to refresh this current activity through coding.
Aug 28 '07 #1
0 928

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

18 posts views Thread by Peter Mount | last post: by
2 posts views Thread by tomvr | last post: by
2 posts views Thread by Jarvis | last post: by
15 posts views Thread by Capstar | last post: by
5 posts views Thread by andrew | last post: by
38 posts views Thread by axlq | last post: by
reply views Thread by SHAOLIN | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.