Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Summary: I need to log usage of resources on Windows XP machine to find if the lack of resources may be the reason for the application crash. I need your advice how to do that.

Context: There is an industrial PC with Windows XP, MS-SQL Server 2008 R2 Express, and the third party application.

The application collects data from the dedicated hardware, and stores the sensor values into the database. Basically, the data is the UTC and four temperatures. The sampling interval is 1 minute (i.e. kind of minimal load). To emphasize again, the application saves 5 values to the database table in one record only once a minute.

My task was to implement the SQL Server Service Broker solution to transfer the collected data to the central SQL server. (A trigger for the new record, XML formed, sent to the other side.) It works smoothly when it works. However...

The problem: It happens occasionally that the application stops to collect data. They claim that this is because there is not enough resources after the SSB solution was implemented. My guess it that they use the change at SQL server ony as a stock excuse. Anyway, they may be right. I need some exact proof what happened in the time of the crash.

As the application records UTC, I know when it stopped to work (from the missing temperature records).

My question: How can I log the usage of the resources, what resources should I observe, and what tool should I use for the purpose?

I am not trained in hardware/OS administration (just some general knowledge), and I have never solved that kind of problem before.

I know there is something named performance counters, but I did not use them, and I do not know how to log them. There is the powershell utility installed on the machine if it matters. (I have heard it is possible to access performance counters from the powershell, but I know nothing more.) I know there is perfmon on the machine, but I do not know if it can be used for the purpose.

Thanks for any suggestion on how to solve the problem,

Petr

share|improve this question

migrated from stackoverflow.com Mar 2 '13 at 0:15

This question came from our site for professional and enthusiast programmers.

    
The shotest to start is to try exec sp_monitor. Log its result periodically and you'll have very quick data to analyse. –  Serg Feb 28 '13 at 19:53
2  
This might be a better question to ask on SuperUser.com –  user6863 Feb 28 '13 at 21:39
    
At Serg amd Slapout: Thanks both. –  pepr Mar 1 '13 at 14:44
    
@Serg: I need also the data about things unrelated to SQL server, and I need them sampled frequently in some time. –  pepr Mar 2 '13 at 10:48

1 Answer 1

So far, I have found the following recommendation http://serverfault.com/a/140978 that seems to be related to my problem. It recommends Logman, Relog, Typeperf command line utilities (instead of the PerfMon) that are available on Windows XP. They seem to fit my needs (http://support.microsoft.com/kb/303133/en-us?fr=1).

I have also found articles about what performance counters should I observe... to show few

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.