September 24, 2008 at 11:26 am
i want to start benchmarking a system here at work , so as to have hard concrete reasons to justify my plea for more hardware in the future.
i have a moderate idea of the counters to monitor. i need to know:
1. how do you monitor, perfmon or some 3rd party software?
2. Do you have just one counter log for all counters, or divide them up?
3. how do you store the data?( excel spreadsheets, leave it in the counter logs txt log, database etc)?
I want to go into this with my eyes open and organized.
thanks for any information.
September 24, 2008 at 1:08 pm
Perfmon should do what you need.
Leave them in regular files. If you need to slice and dice the data, import it into an analysis cube, or relational tables, but most likely what you need is just the raw data.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 25, 2008 at 3:47 am
so, what is your process?
Do you store the files as log files, and then import them into a database via a job containing a dts/SSIS package?
Can perfmon log the data directly to a database? Ive played with this but cant get it to work and i think i am misinterpeting what perfmon means by logging to a database
EDIT: my post title is a bit missleading. when i say benchmark, i mean a performance baseline.
can you guys post your workflow for doing a performance baseline. thanks
September 26, 2008 at 7:13 am
I would log perfmon to a file, then import that into Excel and analyze it there. If I ever found that I needed to do more complex analysis, I'd pull it into SQL for that. But I'd start by logging to a file.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply