collecting data file size perfmon counter on clustered sql instance
-
Saturday, May 12, 2012 1:21 AM
Hi,
I am running an active/active sql cluster. I am collecting the data file size in kb perfmon counter every hour and noticed that when it pulls the databases data file(s) size in kb counter, it sometimes shows that it pulled it off the incorrect instance for that database.
Example. inst1 has database mydatabase
when I query out the data from the warehouse, it shows that mydatabase has been collected off instance1 for a couple of samples and instance 2 for a couple of samples and always totals up to 24 samples since I am collecting every hour (when I look at my perf daily view), but that database is not on instance 2. I do have agent proxy enabled on each node of that cluster. Has anyone seen this before?
My rule is:
Object: $Target/Property[Type="MicrosoftSQLServerLibrary631730!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Databases
Data File(s) Size (KB)
and I checked include all instances for the selected counter.
I am running the latest sql 2008/2012 management pack. ops manager 2007 r2
Any help would be great, thanks
All Replies
-
Tuesday, May 15, 2012 8:19 AMModerator
Hi,
I think you don’t need to select the all instances option. Please create the rule referring to the following posts:
OpsMgr SP1 – Creating rules and monitors for multi instance components
How do I collect data from a multi-instance object – like a SQL DB instance?
Regarding the instances option, I would like to share the following with you for your reference as well:
Writing monitors to target Logical or Physical Disks
Hope this helps.
Thanks.Nicholas Li
TechNet Community Support
- Marked As Answer by Nicholas LiMicrosoft Contingent Staff, Moderator Wednesday, May 23, 2012 3:40 AM
-
Wednesday, May 16, 2012 8:34 PMModerator Both cluster nodes can still talk to the cluster resource even if they dont actively host it at the moment. SO any node can collect it. Would not guess that it jumps back and forth that much, but I guess thats not the problem.
Bob Cornelissen - BICTT (My Blog about SCOM) - MVP 2012 and Microsoft Community Contributor 2011 Recipient
- Marked As Answer by Nicholas LiMicrosoft Contingent Staff, Moderator Wednesday, May 23, 2012 3:40 AM
.png)
