How to Store CPU and Memory Utilization from task manager in Database

Question

1.00/5 (1 vote)

See more:

I want to store the CPU and Memory Utilization of all the individual tasks after every 5 mins. from the task manager into a DB, say SQL Database. Is it possible to write a console application in C# which can accomplish this task and store the utilization in SQL Table.

Posted 22-Apr-13 4:14am

Abhik03

Add a Solution

Comments

Mike Meinz 22-Apr-13 10:20am

You could try using the WMI Code Creator to create some code to get the values you need via WMI and then integrate that code into a program that puts the data retrieved into the database.

Sergey Alexandrovich Kryukov 22-Apr-13 12:10pm

It would make a fair answer. Will you post it?
I just answered on another way, using performance counters...
—SA

Sergey Alexandrovich Kryukov 22-Apr-13 12:09pm

Why? You should understand that the accuracy of Task Manager data is very low. And of course, you cannot get this data from Task Manager, but you can request if from OS.
—SA

Abhik03 23-Apr-13 1:20am

Thanks for you suggetsion Sergey and Mike, I'll try them and will get back to you in case of any doubts. :)

Sergey Alexandrovich Kryukov 23-Apr-13 9:47am

I suggest you can accept the answers formally (green button) — thanks.
—SA

Abhik03 23-Apr-13 6:10am

Hi Sergey, I have tried the below piece of code, but it shows some different value with the task manager, pls help:

static void Main(string[] args)
{
int i = 0;
try
{
PerformanceCounterCategory cat = new PerformanceCounterCategory("Process");

string[] instanceNames = cat.GetInstanceNames();

foreach (string name in instanceNames)
{

try
{

PerformanceCounter counter = new PerformanceCounter("Process", "Private Bytes", name, true);
PerformanceCounter setCounter = new PerformanceCounter("Process", "Working Set", name, true);
PerformanceCounter poolNPCounter = new PerformanceCounter("Process", "Pool Nonpaged Bytes", name, true);

Console.WriteLine("Memory usage for process [{0}]", name);
Console.WriteLine("\tMem Usage: {0} KB", (setCounter.NextValue() / 1024f));
Console.WriteLine("\tVM Size: {0} KB", (counter.NextValue() / 1024f));
Console.WriteLine("\tNon-Paged Pool: {0} KB", (poolNPCounter.NextValue() / 1024f));
i++;
}
catch (Exception ex)
{
Console.WriteLine("Could not read memory stats for process {0}", name);
}
}
}
catch (Exception ex2)
{
Console.WriteLine("Cannot retrieve memory performance counter statistics");
}
Console.WriteLine("Total processes: " + i);
Console.ReadLine();
}

Sergey Alexandrovich Kryukov 23-Apr-13 9:43am

I would say, you can ignore Task Manager results...
—SA

Abhik03 24-Apr-13 2:22am

Ok sure, Thanks Sergey :)

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Accepted Answer · 2013-04-22T06:17:00

Solution 1

You can get this information is you use System.Diagnostics.PerformanceCounter:
http://msdn.microsoft.com/en-us/library/system.diagnostics.performancecounter.aspx[^].

You can use this introductory CodeProject article to see how to do things: An Introduction To Performance Counters[^].

—SA

Posted 22-Apr-13 6:17am

Sergey Alexandrovich Kryukov

**Zoltán Zörgő** · Accepted Answer · 2013-04-22T06:28:00

Actually all the information you got so far is correct:
- Task manager is just a tool to display data. It is not collecting anything
- In the background of task manager (and others like this) are system level tools, like WMI, as Mike Meinz highlighted.
- And you can access them easily also with performance counter tools provided by the .net framework as Sergey suggested.

Still, I would like to draw your attention towards built-in features you can use to achieve much the same result with no code at all from your side. The well-known PerfMon tool has features you can use to store your results into a database. Please see following article: http://www.sepago.de/e/nicholas/2009/11/02/performance-monitoring-part-7-using-performance-monitor-with-a-database[^].