Kelly - are you looking for a report that shows the Database Size listed in a configuration report table like that? You cannot do that - that was a terrible idea and should have never existed. SQL DB size should never have been a class property. It works on SQL 2000 because we never fixed that MP by deprecating those discoveries.
You can however, write a SQL based report with this information, but you would have to base it on a SQL query that is custom written.
Do you suggest using the reporting services t or custom performance detail report? Microsoft would have provided simpler way to do this since it is important report for any organization.
It doesn't need to be in configuration report. We need similar tabular report with database names and sizes.
I would appreciate any ideas on getting database sizes in tabular report instead of chart mentioned in this article. i would also like to implement scaleby to get readable values.
You can use a sample report from jimmy Harpers blog on this:
blogs.technet.com/.../sample-queries-and-reports-from-my-mms-session.aspx
He has a simple performance chart. You can implement scaleby using my blog article on the collection rule.
Thanks, Kevin. Jimmy Harper's sample report worked for me. Regarding scaleby function, I am not seeing xml from configuration tab of the Rule.
Hi Kevin,
I want to monitor the below SQL performance counter for some 25 servers.
SQLServer: Access Methods — Page Splits/sec
SQLServer: Buffer Manager—Buffer Cache Hit Ratio
SQLServer: Databases Application Database—Transactions/sec
which one i have to target for rules (SQL 2008 DB engine or database)
@David -
Simple - look at the counters in perfmon - under the instances. If there is one or no instances - then use SQL DB Engine, or SQL 20xx DB engine. If there is multiple instances (one for each DB) in perfmon, then target SQL Database, or SQL Server 20xx DB.
Thanks Kevin for your Prompt reply. It sounds good.
In my environment, i have around 50 SQL servers, but i want to monitor the performance counter only for 25 servers. Could you please help me how to accomplish this?
@David -
Use groups. Static or dynamic. You can use groups of Windows Computer objects, or groups of SQL DB Engine objects. Then use the groups to create an override, disabling or enabling your new monitors.
Hi Kevin,
if i monitor the 30 SQL performance counters for 50 SQL servers, how much disk space it would consume? Can you provide some average estimate of the disk space then i will increase the size of my opsmgr and DW database
Please advice
@David -
I don't know of a good way to estimate that. it comes down to how many collections per day, whether or not you use Optimized collection and how well that works, and then how long you retain raw, daily and monthly aggregations in the DW. Too many factors to throw out a number. The biggest impact to the warehouse is going to be number of servers and number of counters, both of which are low in your case. For the opsDB, its servers/counters/rate.
HI Kevin,
We are having SCOM 2007 and I need to collect the database growth report in a weekly manner. Is there any query for that. I tried looking into Richard's Stored procedure but unable to find the sql query.
I noticed that when using this method on an active/active sql cluster with an instance on both and have agent proxy enabled on both nodes for the scom agent, it seems to collect data multiple times. For example, if I want to collect log file size every hour for each instance, it will show that I collect it twice. I believe this is due to the agent proxy being enabled. I am targeting sql 2008 db engine. Do you have any suggestions on fixing this?
James - I have not seen that, if you target SQL DB engine - it should only run on the specific engine you target. Its probably an issue if how you are creating your collection rule - not an agent proxy issue. Agent proxy is a requirement and should not be changed.
