|
|
 
0 |
The second winner in our 2010/2011 post-of-the-week contest (week ending Jul 24th) is Craig Pero. Craig went down the rabbit hole to develop an innovative workaround to a performance reporting issue related to the OpsMgr 2007 data warehouse.
THE PROBLEM: Craig did a query for 10 records or 10,000 records in the DW and found there wasn't much difference in the performance when he used date specific ranges ( his DW has 1 billion records in the view). He noticed that you use the vPerfHourly view, it is a UNION of all of the perfHourly_<guid> tables. In his case, they are up to over a billion rows in that union.
THE WORKAROUND: In an attempt to improve performance Craig tried the following. The basic concept is to only include perfHourly_guid tables that you actually need. Craig saw one of my reports go from 30 minutes down to 3 minutes.
He first created a stored procedure which would return query text which would perform a UNION of only the tables where the data contained was within my date range of interest.
Get the Details
Read the full article and get the code at Workaround for Performance Hourly Table in OpsMgr 2007 Data Warehouse.
Well done Craig! Your name goes into the hat for the grand prize drawing at MMS 2011!
WARNING: This solution was tested. However, it falls outside the lines of Microsoft Support. We recommended you a case with Microsoft Support before implementing outside a lab environment.
SPECIAL THANKS TO OUR SPONSORS
We want to give a special shout out to proud Gold Sponsor Quest Software, who helps make all of this possible. As we've said in the past..great company with great people we've enjoyed working with over the years. Quest is now offering VMware ESX and VSphere monitoring for FREE!
Click the banner below to check out Quest Management Xtensions (QMX) Solutions for System Center, including how to get started monitoring your VMware infrastructure
Previous Installments of POST OF THE WEEK (2nd edition)
Details on the POST OF THE WEEK
Want to know how your contributions can be considered for the post of the week? Read more HERE.
Follow System Center Central via Twitter and RSS
