?? ????? ????? ??????? ??? ?? ?? ?? ???? 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 ?????????? ????? ?? ????? ????? ?? ???? ????:
- ????? ????,????????? ????? ????,??? ??????????? ????? ????,Microsoft SQL Server?? ????-????? ????, ?? ???? ????????????? ???????.
- ??????? ????Microsoft SQL ?????\SQL ????? ????\SQL ??????\??????????????? ?? ????
???:SQL ???????????????? ????? MOM ??????? ??? ???????? ?????? ??? - ????-????? ????SystemCenterReporting?? ????-????? ????, ?? ???? ??????.
- ????? ???????? ????????? ??,????? ?????? (MB)???, ?? ???? ??? ?? ??? ????? ???? ???? ?????
- ????? ????????????? ?????? ??,????? ?????? (MB)???, ?? ???? ??? ?? ??? ????? ???? ???? ?????
- ????? ????,OK?????????? ?? ??????? ???? ???? ?? ????
- ????????? ???? ?? Tempdb ???? ?? ??? ?? ????? ????? ?? ???? ??? Tempdb ??? ??????? ???????? ?? ??????? ???????? ???????????? ???? ??? Tempdb ???? ???????? ??? ?? ????? ?? ???? ???? ?????? ????????? ???? ?? ???? ?????? ??? Tempdb ?? ?????, SQLERROR ??? ??? ??? ?????? ????? ???? ??? ?? ?? ???? ??? ?? ?? ???? ????? ?? ??? ???? ?? ??? ?????? ??????????? ??? ?? ????? ?? ?????, ?? ???????? ??? ?? ?????????? ??????? ?? Transact SQL ?? ????? ?? ???? ??????? ?? ?????
???????? ???? ?? ???????? ????? ????? ????? ?? ???? Tempdb ???????? ?? ?? ????? ????? ?????? ?? ??? Tempdb ?? ??? ??? ????? ????? ?????? ??? ?? ???? ??? ?????? ???
?? ?? SystemCenterReporting ??????? ?? SystemCenterReporting ???, ?? ???????? ??? ?? DTS ????? ?? ??? ?? ?????, Tempdb ?? ???? ??????? ?? ??? ????????? ?? ???? OnePoint ??????? ?? SystemCenterReporting ??????? ?? ???? ???????? ??? ?? ????? ?? ??? DTS ?????, ?? ????? ?? ???? ?????
???????? ???? ?? ????????? ??????? ??? SystemCenterDTSPackageTask ????????? ????? ???????? ??? ?? ????? ?? ??? ??????? ???? ??? ??? ??? ??? ??, ?? ???? ????????? ?? ?????
- ????? ?? ??? Windows Explorer ?? ????? ????MOM ?????????? ??????: \Program Files\Microsoft ?????? ?????? Reporting\Reporting ????????
- 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 ??? ????
- MOM ?????????? ????? ?? ??? ???????????? ?????? ???? ???? ???? ?? ????? ?? ??? ?? ?????
- ????? ????,???????????? ????,???????????:cmd?? ????-????? ????, ?? ???? ???OK.
- ????? ????????? ?? SystemCenterDTSPackageTask, ?????? ?? ???? ?????? ???????? ?? ????????? ?????/latency:20, ?? ???? ??? ?????ENTER.
? 20 ? ?? ?????? ??? 20 ??? ?? ???????????? ???? ??? - ???? latency timeframes ?? ????? ???? ??? 3 ?? ????????
- ???????/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 ????? ?? ????????? ?? ?? ???? ???? ??????
- ?? ??????????????? ???????, SQL Server Reporting ??????? ?? ????-????? ????, ?? ???? ??? ????? ?????????????? ????
- SQL ????? ??? ????? ??? ????? ?????????????? ?? ????? ????..
- ?????? ????? ??????? ??? ??? ?????1200??????????? ????-??? ???????? ????
- SQL ????? OnePoint ??????? ?? ??? 1 ?? 3 ?? ????????
- 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 ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:887016
(http://support.microsoft.com/kb/887016/
)
Microsoft ?????? ??????? 2005 ??? SystemCenterReporting ??????? ??? ???? ?? ???? ?? ??? ????? ?? ?????? ?? ??????? ???? ?? ??? ???? ????
???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ???????? ????? ????::
873235
(http://support.microsoft.com/kb/873235/
)
????????? ??? ?? growing ?? ?? SQL Server ??????? ?? ????????? ??? ???? ????? ?? ??? ???? ????
317375
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/899158/en-us/
)
????? ?? ???? ????
