zinck74
Guest
|
 Posted:
Tue Oct 18, 2005 12:50 am Post subject:
Performance Data Not Collected for WSS MP |
|
|
Hi,
I have one server which does not seem to be collecting performance data
for my request sequences and I can't really figure out why. Basically
I've tried looking at the data via the SDKPerformanceView view. I've
tried a couple of queries against it based on the view to figure out
what might be going on.
If I run this query:
select * from PerfmonCounterScale
where objectname like 'wss mp%'
I can see all my request sequences. Great, looks good so far. Then I
add one more level of complexity.
select * from PerfmonCounterScale pcs
join SampledNumericDataSource snds on pcs.idperfmoncounterscale =
snds.idperfmoncounterscale
where pcs.objectname like 'wss mp%'
I'm not entirely sure what this is telling me but I get about 120 rows
returned as well with the names of all the request sequences I have
setup. So this looks positive. But then when I add another level of
complexity essentially mimicking the SDKPerformanceView view I get no
data.
select * from PerfmonCounterScale pcs
join SampledNumericDataSource snds on pcs.idperfmoncounterscale =
snds.idperfmoncounterscale
join SampledNumericDataAll snd on snds.idSampledNumericDataSource =
snd.idSampledNumericDataSource
where pcs.objectname like 'wss mp%'
I've also checked the request sequences and the box to collect
performance metrics is checked for all of them.
Anyone have any idea why this may not be capturing the data I want?
Thanks,
Bill |
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in