DTS ?? ???????? ??? MOM 2005 Reporting sizing ??????? ???????? ?? ?????? ???? ????

???? ?????? ???? ??????
???? ID: 899158 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ????? ????? ??????? ??? ?? ?? ?? ???? MOM 2005 ??? Microsoft ?????? ??????? (MOM) ?????????? ???? ?? ??????? ???? ?? ???:
  • ????? ?? ?????? MOM ??????? ????
  • ?? ?????? ???? ??? MOM ?????????? ????? ?? ????? ?? ??? ??????? ?? ????? ?? ???, ???? ????? ?????? ????? ??????? ?? ???? ??:
    ??? ???? ?????? ?? ?? ??????? ?? ????
  • OnePoint ??????? ?? ???? suddenly grows ???? ??????? grows ??? ?? ???? ???? ???? ???????? ????? ?? ???? ?????? ?? MOM ???????????? ???? ??? ?? ?? ?? ???? ??? ???????? 30-???????? (GB) ???? ?? ???? OnePoint ??????? ????? ?? ???? ???
  • MOM ?????????? ????? ?? ????????? ??? ??? ????? ????? ????? ???? ??:

    ????? ID 1001
    ?????: MOM.Datawarehousing.DTSPackageGenerator.exe
    ?????: ??????????? ????? ???? ?? ??? MOM ?????????? DTS ????? ????

    ????? ID: 81
    ????? ?????: DataTransformationServices
    ?????: ????? DTS ????? ?? ???????? ???? ???:

????? ID 1001 ????? ???? ??????????????? ?????? (DTS) ?????? ?? ???? ???? ?? ?? ????????? ????? ???? ??? ????? ID 81 ?????? ?? ???? ?? ???? ??? ???? ??????? ?? ?????? ???? ??? ????? ????? ?? ????? ?? ??? ?? ??????? ??? ???????? ????? ????? ????? ?? ???? ??? ??? ??????? ?????? ??????? ?? ?????? ??????????? ???:
  • ?????? ???? ?? ??? ????? ??? 'SystemCenterReporting' ??????? 'SC_EventFact_Table' ???????? ?? ??? ??????? '????????' filegroup ???? ??? ???
  • ??????? 'SystemCenterReporting' ?? ??? ??? ???? ??? ??? ??? ??? ?? ??? ????? ????? ???? ?? ??? ??????? ?? ??? ????????? ??? ?? ????? ????
  • ???????? ?? ??? ????? ?? ?????? ???? ?? ??? ' (?????? ???? id:-548802855) ' ??? 'TEMPDB' ?? ??????? ??????? '???????' filegroup ???? ??? ???
? MOM Reporting DTS ????? ??????????? ????? ???? ??? ???? ? ????? ???? ?? ?? ??????? ????? ?? ???? ??? ?? ??????? ????? ?? ?? ????? ???? ?? ??? ?????????? ??????? OnePoint ??????? ?? ?????????? ???? ?? ????????? ???? ?? ?? ???

????

?? ????? DTS ????? ???? ?????????? ???? ?? ????????? ????? OnePoint ??????? ?? MOM ?????????? ????? ??????? ???? ?? ???? ??? ???? ???? grooming ????? ?? ??? OnePoint ???????, ?? DTS ????? ??????????? ???? ?? ?? ?????? ???? ???? ??????
DTS ????? ???? ?? ???? ?? ?? ????? ????????? ???? ???:
  • DTS ????? MOM ?????????? Server ??????? ?? ???? ?? ????? ?? ????????? ????? ?? ????? ???? ???
  • ?????????? ????? MOM ??????? ??? ????? ????? ?? ???? ???? ?? ??? ???????? ????? ????? ???
  • ????????? ??????? ??? SystemCenterDTSPackageTask ??????? ??? ?? ????? ?? ???????? ??? ?? ???? ???? ???? ?? ??? ??????? ???? ??? ???
?????????? ????? MOM ??????? ?? ??? ?? ???? ??? ?? ????? ????? DTS ????? OnePoint ??????? ?? ???? ?? ????????? ????? ?? ?????? ???? ???? ?? ??????? ?? ?? ???? ?? ??? MOM ????? ???? ?? ????? ???? ?? ???????? ??? ?????? ?? ???, ?? ??????? ?? ???? ?? ??? ????? ????????? ???? ??:
  • MOM ????? MOM ?????????? ???? ?? ??????? ???? ?? ???? ??? ???? ??? ?? ??? ?? ??? ???? ??? ???
  • ?? ??????? ?? ??????? MOM ????? ???? ?? ??? ?? ?? ??? ??? ????
  • ?? ???? ?????? ??? ????? ?? ??????????? ???? ?? ?? ??? ?????? ??? ??????? ??? ??? ???? ???????
  • ?? ?????? ?? ????? ?????? ???? ??? ??????? ??? ??????? ???? ???
  • ?????? ??? 1 (SP1) ?? ??? MOM 2005 Reorting ?? ???? ??????? ?? ???????? ???? ???? ??? ???

????????

?? ?????? ?? ?? ???? ?? ??? SystemCenterReporting ??????? ?? SystemCenterReporting ??? ?? ???? ??????? ??? ???? ?? ???, MOM ?????????? ????? ?? ????? ????? ?? ???? ????:
  1. ????? ????,????????? ????? ????,??? ??????????? ????? ????,Microsoft SQL Server?? ????-????? ????, ?? ???? ????????????? ???????.
  2. ??????? ????Microsoft SQL ?????\SQL ????? ????\SQL ??????\??????????????? ?? ????

    ???:SQL ???????????????? ????? MOM ??????? ??? ???????? ?????? ???
  3. ????-????? ????SystemCenterReporting?? ????-????? ????, ?? ???? ??????.
  4. ????? ???????? ????????? ??,????? ?????? (MB)???, ?? ???? ??? ?? ??? ????? ???? ???? ?????
  5. ????? ????????????? ?????? ??,????? ?????? (MB)???, ?? ???? ??? ?? ??? ????? ???? ???? ?????
  6. ????? ????,OK?????????? ?? ??????? ???? ???? ?? ????
  7. ????????? ???? ?? Tempdb ???? ?? ??? ?? ????? ????? ?? ???? ??? Tempdb ??? ??????? ???????? ?? ??????? ???????? ???????????? ???? ??? Tempdb ???? ???????? ??? ?? ????? ?? ???? ???? ?????? ????????? ???? ?? ???? ?????? ??? Tempdb ?? ?????, SQLERROR ??? ??? ??? ?????? ????? ???? ??? ?? ?? ???? ??? ?? ?? ???? ????? ?? ??? ???? ?? ??? ?????? ??????????? ??? ?? ????? ?? ?????, ?? ???????? ??? ?? ?????????? ??????? ?? Transact SQL ?? ????? ?? ???? ??????? ?? ?????
    ???????? ???? ?? ???????? ????? ????? ????? ?? ???? Tempdb ???????? ?? ?? ????? ????? ?????? ?? ??? Tempdb ?? ??? ??? ????? ????? ?????? ??? ?? ???? ??? ?????? ???
?? ?? SystemCenterReporting ??????? ?? SystemCenterReporting ???, ?? ???????? ??? ?? DTS ????? ?? ??? ?? ?????, Tempdb ?? ???? ??????? ?? ??? ????????? ?? ???? OnePoint ??????? ?? SystemCenterReporting ??????? ?? ???? ???????? ??? ?? ????? ?? ??? DTS ?????, ?? ????? ?? ???? ?????

???????? ???? ?? ????????? ??????? ??? SystemCenterDTSPackageTask ????????? ????? ???????? ??? ?? ????? ?? ??? ??????? ???? ??? ??? ??? ??? ??, ?? ???? ????????? ?? ?????
  1. ????? ?? ??? Windows Explorer ?? ????? ????MOM ?????????? ??????: \Program Files\Microsoft ?????? ?????? Reporting\Reporting ????????
  2. MOM.Datawarehouse.DTSPackageGenerator.exe ????? ?? ???-????? ?????
???:????????? ????? ???, ???????? ???? ??? ?? ?? ?? SystemCenterDTSPackageTask ??????? ??? ?? ????? ?? ???????? ??? ?? ?? ??? ???? ????

???? ???????

/Latency ????? ?? /chunksize ????? ?? ????? ?? ???? ?? ?? ?????? ???

?? ??????? ???? ??? ?? ?? ???? ??? ?? ???? ???? ????? ??? ???? ??? ?? ?? ??? ??? ?? ???? ?? ??? ???? ?? ?? ???? ?????? ??? ?? SQL ????? ??? ??? outs ?? ???? ??? ?? ???? ???? ?? ???? ?? ???? ???? ???? ??? ?? SQL Server ??? ??? ???????? ?? ?? ?? ?? ???? ????

/Latency ?????

MOM.Datawarehouse.DTSPackageGenerator.exe ????? ???? SystemCenterReporting ??????? ??????????? ???? ?? ??? ???? ?? ??? ??? ????????? ???? ???? ?? ?? latency ???????? ?? ?????? ???? ??? ?? SystemCenterReporting ??????? ?? ??? ????? ???? ?? ????????? ???? ?? ?? ????????? ???? ?? ??? latency ???????? ?? ????? ?? ???? ???? Latency ???????? ????? ???????? ?? ????? ???? ??:
MOM.Datawarehousing.DTSPackageGenerator.exe /latency:????? ?? ??????
?? ??????? ???? ??? ?? ?? latency ???????? ?? ????? ??? DTS ????? ?? ???? ?? ??? ?? ??? ??? ?? ??? ???? ?? ?? ???

????? ?? ??? ???? ?? ?? ????? ??? DTS ????? ??????????? ??, TimeDTSLastRan ??? ?? ??? OnePoint ??????? ??? ReportingSettings ?????? ?? ???? ????? ?? ??????? ??????? ??? (???????? ????? ???) ??? ????????? ???? ???? ???

?? ?????? ???, DTS ????? ???? ????? ?? 30 ????? ???? ?????, ?? 20 ?? ??? ?? ??? latency ????? ?? ????? ?? ???? ??? ?? ????? MOM ?????????? ??????? ??? 20 ????? ?? ?????? ?? ?? ??? ???? ?? ??????????? ??????? ???? ??? ?? ?? ????? ?? ????? ?? ??? ??? of10 ??? ???????? ???? ?? ??? ?? 10 ????? ?? ?????? ?? ?????????? ?? ????? ????? ??? ?? ????? ??? ???????/latency??? ??? ???? ??????????? ???? ?? ??? MOM.Datawarehousing.DTSPackageGenerator.exe ?? ????? ????? ???, ?????? ???? ???? ????? ?? ?????? overwhelming ?????

???:?? ?????? ????? ?? ?? OnePoint ??????? ??? ???? ?? 30 ??? ????
  1. MOM ?????????? ????? ?? ??? ???????????? ?????? ???? ???? ???? ?? ????? ?? ??? ?? ?????
  2. ????? ????,???????????? ????,???????????:cmd?? ????-????? ????, ?? ???? ???OK.
  3. ????? ????????? ?? SystemCenterDTSPackageTask, ?????? ?? ???? ?????? ???????? ?? ????????? ?????/latency:20, ?? ???? ??? ?????ENTER.

    ? 20 ? ?? ?????? ??? 20 ??? ?? ???????????? ???? ???
  4. ???? latency timeframes ?? ????? ???? ??? 3 ?? ????????
  5. ???????/latency????? ??? ????? ????? ?? ????? ??????? latency ?????? ?? 5 ???? ??? ?? ????? ??, ??? ???? ?? ?? ????? 5 ???? ????? ??? ?????? ???
???:?? ?? ?? ??? ??? ???? ???? ??? ?? ??? ?????????? ?????, ??????? ??? ?? ????? ?? latency ???????? ??????? ?????? ???

/Chunksize ?????

??? ??? ???? ???????? ????? ??? ?? MOM 2005 SP1 ??? ????? ?? ??? ???? ?????? ?? DTS ????? ????? ???:
  • /chunksize: ????? ??? ???? chunk. ??? ???? ?? ???? ??? ???? ??? ?? ???? ??????????? ?? ?? ???? ?????? ?? ????? ??? ????? ?? ????-??? ?? ???? ?? ?????????? ??? ????? ???? ??? ??? ?? ???? ??? ?? 0 (?????) ????????? ????, ?? ???? chunk ???? ?????? (???????? 1 ??? =)?
  • /maxchunks: ?? chunking ????? ????? ?? ??? ??? ?? ?????? ??????? (???????? 10 ??? =)?

DTS ????? ?? ?? ???? ???? ?? ?? ???? ?? ????-??? ??????

DTS ????? ?? ???? ?? ??? ?? ???? ?? ????????? ???? ?? ???? ?? ?? ???? ?? ?????? ???? ???? ?? ??? ??? ????-??? ?????? ????? ?????

????? 1001, ????? 81 ?? ????? DTS ???? ?? ?????? ?? ????? ?????: ???? /????? ?? ?????? ?? ????? ?? ???? ?? ?????? ????? ?? ????? ?? ???? ??:
???????? ??????? ?????? ?? ?? ???
???????? ???? ?? ???????? ????? ???? ?? ???? ??? ??, ?? ????? ???????? ???? ?? ??? ???
???????? ?????? ?? ???? ?? ????? ?? ?? ??????? ??????? ?????? ?? ??
??????? ????? 81 ??? ????? ??????? ?? ????????? ??? ????? ???? ?? ???? ??? ??? ?????? ???? ????? ???? ???, ??? ?? ???? ??????????? ???????? ?? ??????? ?????? ?? ???? ??????? ??? ?????, ????? ??????? ??? ?? ???? ?? ?? ????? ????:
  • DTS ????? ??? ?? ??????
  • ??? DTS ????? ??? ???? ????, ?? ?????? ??? ????? ??? ??????

?????? ?????? ??? ????? 1200 ???? ?? ??? 600 ????? ?? ?? ???? ?? ???????? ??? ?? increased ???? ?? ???? ??, ?? ??? ???? ?? ??? ?????? ?????? ??? ????? 0 (??????) ??? ????? ???? ????? ?? ????? ?? ??? ???? ??? ?????? ?????? ??? ????? ?? ????? ?? ??? ????? ????? ?? ???? ????:

???:?????? ?????? ??? ????? ??? Reporting ??????? ?? ????? ???? ?? ?? SQL ????? ?? OnePoint ??????? ?? ????? ???? ?? ?? SQL ????? ?? ????????? ?? ?? ???? ???? ??????
  1. ?? ??????????????? ???????, SQL Server Reporting ??????? ?? ????-????? ????, ?? ???? ??? ????? ?????????????? ????
  2. SQL ????? ??? ????? ??? ????? ?????????????? ?? ????? ????..
  3. ?????? ????? ??????? ??? ??? ?????1200??????????? ????-??? ???????? ????
  4. SQL ????? OnePoint ??????? ?? ??? 1 ?? 3 ?? ????????
  5. DTS ????? ??????? ?????
    ???
    • ??? DTS ????? ?? ?? ??? ?????? ??, ?? ??? 1 ?? 6 ???????? ???????, ??? 3 ?? ??? 2400, ??? ????????? ?? ?????? 3600 ?? 0?
    • ?????? ?? ?? ?? ??, ?? ??? ????? ?????? ??? ????? ??? 600 ?? whatever ??? ?? ??????????? ????? ?? ??? ?????? ????? ?? ??? ?????? ???
????? ID 1001 ??????? ?? ?? ????? ?? ???? ??:
Step StepInvokeInnerPackage failed. Step Error Source: Microsoft OLE DB Provider for SQL Server Step Error Description: (1:SC_Inner_DTS_Package) SubStep 'DTSStep_ExecuteSQLTask_SC_SampledNumericDataFact_View_1_Insert' failed with the following error: OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached. (Microsoft OLE DB Provider for SQL Server (80040e14): OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned 0x80040e31: Execution terminated by the provider because a resource limit was reached.].) (Microsoft OLE DB Provider for SQL Server (80040e14): [OLE/DB provider returned message: Timeout expired]) Execution was canceled by user. Step Error Code: -2147220441 Step Error Help File: Step Error Help Context ID:0

???????? ?????? ?????? ???????

  • SQL ????? ???? DTS ????? ????????? ???? ?? ??? ?? ?? ????????? ?? ?????? ??? ?? ??????? ?????
  • SQL ????? ???? DTS ????? ????????? ???? ?? ??? ?? ?? SQL Server ??? ?? ??????? ?????
  • ????????? ???? ?? OnePoint ?? SystemCenterReporting ??????? ????????????? ?? ??????? ??? ??? ??? ???? ?? ??????? ??? ??? ???????? ???? ??? ??????????? ?? ????? ????..
  • ????????? ?? ?????? ??????? ?????? ?? ??????? ???? ?? ??? ?? ??????? ????????? ?? ??? ??????? ??? ?? ????? ?? DTS ???? ?????? ?? ????????? ??????

    ?????? ?? ???, C:\Program Files\Microsoft ?????? ?????? Reporting\Reporting>MOM.Datawarehousing.DTSPackageGenerator.exe /silent /srcserver:servername /srcdb:OnePoint /dwserver:servername /dwdb:SystemCenterReporting /product: "Microsoft ?????? ???????"

    /Silent ??????? ?? ????? ????? ????????? ?? ??????? ?? ?????? ??? ????? ???? ???? ??, ?? ?????? ??????? ?? ?????? ?? ??????? ?? ?? ?????? ?? ?????? ?? ?????? ?? ??? ??? ???? ?? ??? ????????? ?? ???? ????
    ?? DTS ????? succeeds ??? ?????? ????????? ???? ???? ?? ?? ?? ????? ????????? ????????? ???? ??????

    ??? ??? ???? ????? ????? ?????? ??

    ??? SystemCenterReporting ??????? ????? ????? ?????? ?? ?????? ?? ???? ?? ????? ??? ??, ?? ?? ?? ????? ?? ??? ?? ???? ????? ????? ?? ???????? ???? ?? ?????? grooming ??????? ?? ???? ???????? reconfigured ???? ?? ???????? ????? ???????? ??? ??, SystemCenterReporting ??????? ??? ???? ?? ???? ?? ??? ???? 395 ????? ??? MOM 2005 Reporting ??? ??????? ???? ?? ??? ???????? ????????? p_updategroomdays SystemCenterReporting ??????? ??? ????? ??? ??? ?? SystemCenterReporting ??????? ??? ???? ??? ????? ?? ?????? ?? ???????? ???? ?? ??? ?? ???????? ????????? ?? ????? ?? ???? ???Grooming ?????? ?? ????????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
    887016Microsoft ?????? ??????? 2005 ??? SystemCenterReporting ??????? ??? ???? ?? ???? ?? ??? ????? ?? ?????? ?? ??????? ???? ?? ??? ???? ????
???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ???????? ????? ????::
873235????????? ??? ?? growing ?? ?? SQL Server ??????? ?? ????????? ??? ???? ????? ?? ??? ???? ????
317375??? ????????? ??? grows ????????? ??? ?? ?? ???? SQL Server ??? ??? ???????? ?? ????? ?? ????

???

???? ID: 899158 - ????? ???????: 05 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft Operations Manager (MOM) 2005
??????: 
kbopmanreporting kbopmaneventmgmt kbopmanalerts kbtshoot kbdatabase kberrmsg kbevent kbmt KB899158 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:899158

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com