Stuart Cash
Guest
|
 Posted:
Mon Jan 10, 2005 11:06 pm Post subject:
Archive MOM Reporting Data |
|
|
Hello,
We have a MOM 2005 server and have installed (on the same server) SQL
Reporting Services. As part of the install we have a scheduled DTS job which
copies the MOM data from the MOM Database to the SQL Reporting Services
database (SystemCenterReporting). I have created several Reports which query
this Reporting data, using the SDKPerformanceView view.
The size of this reporting database is now growing and the reports are
taking a while to produce due to the amount of data in the database. What I
would like to do is to archive every month and so only have the current
months data in the reporting database.
What I need to know is how and what I backup. Do I backup the entire
database to a new archieved database every month (e.g. Jan05.bkf, Feb05.bkf,
etc.) or just archive all the data into one single archive database (e.g.
all data archive.bkf).
What I would like to have is that if I need to look at previous months data,
is it a case of just chaning my datasource in the report to point to the
archieved database or must I restore my archieved data back into the SQL
Reporting Database (SystemCenterReporting)?
Any suggestions would be much appreciated.
Thanks
Stuart |
|
Bill Hodghead
Guest
|
| Posted:
Mon Jan 10, 2005 11:38 pm Post subject:
Re: Archive MOM Reporting Data |
|
|
If you use the right columns in the SystemCenterReporting DB (the clustered
indexes) then the report performance is not strongly dependent on the size
of the DB, but on the size of the date range of your reports. Most of our
reports on a half-terrabyte DB with a 1 week date range, had similar
performance to smaller DB's because the amount of data the report was run
over was the same. Thus, the trick to performant reports is the report
query. The SDKPerformanceView is not the most performant view for large
DB's - it's created for backward compatibility to MOM2000. Try creating
queries directly against the SC_SampledNumericData_View and use the
LocalDateTimeSampled column for your date range.
There's a section on archiving in the new Ops Guide on the web.
"Stuart Cash" <stuart.cash@udex.com> wrote in message
news:OLw0xaz9EHA.2996@TK2MSFTNGP10.phx.gbl...
| Quote: | Hello,
We have a MOM 2005 server and have installed (on the same server) SQL
Reporting Services. As part of the install we have a scheduled DTS job
which
copies the MOM data from the MOM Database to the SQL Reporting Services
database (SystemCenterReporting). I have created several Reports which
query
this Reporting data, using the SDKPerformanceView view.
The size of this reporting database is now growing and the reports are
taking a while to produce due to the amount of data in the database. What
I
would like to do is to archive every month and so only have the current
months data in the reporting database.
What I need to know is how and what I backup. Do I backup the entire
database to a new archieved database every month (e.g. Jan05.bkf,
Feb05.bkf,
etc.) or just archive all the data into one single archive database (e.g.
all data archive.bkf).
What I would like to have is that if I need to look at previous months
data,
is it a case of just chaning my datasource in the report to point to the
archieved database or must I restore my archieved data back into the SQL
Reporting Database (SystemCenterReporting)?
Any suggestions would be much appreciated.
Thanks
Stuart
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in