cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

How are Application Stats Data stored uncooked?

I'm just trying to figure out how the data is stored in the dbo.ApplicationStatistics table for an Application.


For example, I'm wondering why there are 9 entries for each time period, 5 of which have NULL values for CPU Load and MemoryUsed?


NodeID      AppName         AppID  DateTime                 CPULoad  MemoryUsed


BUFDISP2 Internet Explorer 291 2007-10-01 00:17:23.000 NULL NULL
BUFDISP2 Internet Explorer 291 2007-10-01 00:18:24.000 -2 2.809037E+07
BUFDISP2 Internet Explorer 291 2007-10-01 00:18:24.000 -2 5.694259E+07
BUFDISP2 Internet Explorer 291 2007-10-01 00:18:24.000 NULL NULL
BUFDISP2 Internet Explorer 291 2007-10-01 00:18:24.000 NULL NULL
BUFDISP2 Internet Explorer 291 2007-10-01 00:18:24.000 -2 3.60407E+07
BUFDISP2 Internet Explorer 291 2007-10-01 00:18:24.000 -2 5.599232E+07
BUFDISP2 Internet Explorer 291 2007-10-01 00:18:24.000 NULL NULL
BUFDISP2 Internet Explorer 291 2007-10-01 00:18:24.000 NULL NULL
BUFDISP2 Internet Explorer 291 2007-10-01 00:18:24.000 NULL NULL

BUFDISP2 Internet Explorer 291 2007-10-01 00:19:38.997 0 2.821734E+07


 Also, I understand that the memory used values are raw- but again, are the 9 (4 that are not NULL) values added together for a total?


And finally (sorry lots of questions) the CPU load values are really weird...there are some -2s in there? Any help would be greatly appreciated- I'm trying to generate some reports that show all applications from a specific node over a specific time period. I would much rather pull straight from the table rather than go through every single chart, import the data into excel, etc etc.

0 Kudos
1 Reply
Level 9

HAHAHAHA nevermind...I guess it would help if I actually read my own dang SQL statement. I feel stupid.

0 Kudos