Стоит SQL Server Standard Edition 2008 R2(64-bit) на Microsoft Server 2008 R2 Standard. Кубы процесятся в джобе по-частям, сначала все измерения, потом все кубы. Иногда прямо на первом шаге джоба служба SSAS отключается, но не всегда. После включения службы все отлично процесится. После выключения, в файл SQLDUMPER_ERRORLOG.log записывается что то вроде этого:
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514)
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 1504
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0000000003165C40
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1504
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0000000003165C40
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Threads processed: 37
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
(17CC:141C) 12/21/10 05:57:08, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
(17CC:141C) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
(17CC:141C) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\DB\Log\SQLDmpr0228.mdmp
(17CC:141C) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'
(17CC:141C) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(17CC:141C) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(17CC:141C) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'
(17CC:141C) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2009.100:1600.1'
(17CC:141C) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.50:1600.1'
(17CC:141C) 12/21/10 05:57:12, ACTION, msmdsrv.exe, Watson Invoke: No
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514)
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 1504
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0000000003165C40
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1504
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0000000003165C40
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Threads processed: 36
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
(BD4:1688) 12/21/10 05:57:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
(BD4:1688) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
(BD4:1688) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\DB\Log\SQLDmpr0229.mdmp
(BD4:1688) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'
(BD4:1688) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(BD4:1688) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(BD4:1688) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'
(BD4:1688) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2009.100:1600.1'
(BD4:1688) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.50:1600.1'
(BD4:1688) 12/21/10 05:57:13, ACTION, msmdsrv.exe, Watson Invoke: No
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514)
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 1504
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0000000003165C40
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1504
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0000000003165C40
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Threads processed: 36
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\DB\Log\SQLDmpr0230.mdmp
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2009.100:1600.1'
(1018:1538) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.50:1600.1'
(1018:1538) 12/21/10 05:57:13, ACTION, msmdsrv.exe, Watson Invoke: No
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514)
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 1504
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0000000003165C40
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1504
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0000000003165C40
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Threads processed: 36
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\DB\Log\SQLDmpr0231.mdmp
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2009.100:1600.1'
(6D0:1608) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.50:1600.1'
(6D0:1608) 12/21/10 05:57:13, ACTION, msmdsrv.exe, Watson Invoke: No
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514)
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 1504
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0000000003165C40
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1504
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0000000003165C40
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Threads processed: 36
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
(1268:1558) 12/21/10 05:57:13, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
(1268:1558) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
(1268:1558) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\DB\Log\SQLDmpr0232.mdmp
(1268:1558) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'
(1268:1558) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1268:1558) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1268:1558) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'
(1268:1558) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2009.100:1600.1'
(1268:1558) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.50:1600.1'
(1268:1558) 12/21/10 05:57:14, ACTION, msmdsrv.exe, Watson Invoke: No
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514)
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 1504
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0000000003165C40
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1504
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0000000003165C40
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Threads processed: 36
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\DB\Log\SQLDmpr0233.mdmp
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2009.100:1600.1'
(1640:151C) 12/21/10 05:57:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.50:1600.1'
(1640:151C) 12/21/10 05:57:14, ACTION, msmdsrv.exe, Watson Invoke: No
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514)
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 1504
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 0000000003165C40
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1504
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0000000003165C40
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Threads processed: 36
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\DB\Log\SQLDmpr0234.mdmp
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll'
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0'
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE'
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2009.100:1600.1'
(1468:698) 12/21/10 05:57:15, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.50:1600.1'
(1468:698) 12/21/10 05:57:15, ACTION, msmdsrv.exe, Watson Invoke: No
Поиск в Google по поводу этой ошибки выдает много ссылок, из которых видно, что такая проблема была и в SSAS 2005. Для SSAS 2005 решается путем установки SP2, для SSAS 2008 я фиксов не нашел.
Моя версия происходящего следующая - SQLDUMPER - это сборщик мусора, который чистит память. Когда перед процессингом куба память SSASа заполнена, то включается сборщик мусора и, по каким то причинам, рушиться. Бывают случаи, когда сервис не выключается перед процессингом, я думаю, это из-за того, что память не заполнена и сборщик мусора не запускается. У меня сервис выключался в основном в будни (кубы процессятся каждый день в 6 утра), начиная с утра вторника. Т.е. в выходные запросов к кубам нет, память не засоряется, в понедельник пользователи активно работают с кубами (они работают через Excel, т.е. в конечном итоге к кубам идет много разнообразных запросов), память засоряется и ее надо чистить. Если сервис выключить (или если он сам отключился) и потом включить, память освобождается и далее кубы процесятся нормально.
В ходе поисков решения, я нашел статью http://jesseorosz.wordpress.com/2007/07/27/msolap-service-crashes-once-a-day-windows-low-fragmentation-heap-vs-olap-heap/, в которой предлагается следующее решение - переключить SSAS с OLAP-кучи на Windows-кучу, т.к. сборщик мусора SSASа работает не устойчиво. Для этого надо в файле C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Config\msmdsrv.ini в разделе <Memory> установить следующие значения:
<MemoryHeapType>2</MemoryHeapType><HeapTypeForObjects>0</HeapTypeForObjects>
Мне не помогло, более того, у меня процесятся три куба и иногда сервис стал выключатся в процессе процессинга одного из кубов.
Переход на SQL Server Enterprise Edition 2008 R2(64-bit) не решил проблему, видно сборщик мусора у них один.
Я решил проблему в лоб - создал задание, которое каждую ночь, перед процессингом перезапускает службу SSAS.
Комментариев нет :
Отправить комментарий