sql-server - sqldumper错误导致C盘满

Question

我在 this guide 之后安装了 Microsoft SQL Server 2019 . 10:30 建议将用户数据库目录、用户日志目录和备份目录从默认目录更改为 D 盘上的目录。

现在我在 C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\Polybase\dump

处生成了转储文件

这是来自 SQLDUMPER_ERRORLOG.log 的片段:

(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514)
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,   Parameter 1: 25340
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,   Parameter 2: 0
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,   Parameter 3: 0:0
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,   Parameter 4: 00007FF62791B360
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters:
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ProcessID = 25340
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ThreadId = 0
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     Flags = 0x0
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     MiniDumpFlags = 0x0
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     SqlInfoPtr = 0x00007FF62791B360
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     DumpDir = <NULL>
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExceptionRecordPtr = 0x0000000000000000
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ContextPtr = 0x0000000000000000
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ExtraFile = <NULL>
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     PatternForExtraFiles = <NULL>
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     InstanceName = <NULL>
(9E04:9E08) 12/08/19 21:19:45, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,     ServiceName = <NULL>
(9E04:9E08) 12/08/19 21:19:45, ACTION,               mpdwsvc.exe, Not creating an additional dump, because dump for stack signature 00000001AB5F1D21 already exists.
(9E04:9E08) 12/08/19 21:19:45, ACTION,               mpdwsvc.exe, Send_To_Watson flag is set to true
(9E04:9E08) 12/08/19 21:19:45, ACTION,               mpdwsvc.exe, Force_Watson flag is set to true
(9E04:9E08) 12/08/19 21:19:45, ACTION,               mpdwsvc.exe, Watson Invoke: Yes
(9E04:9E08) 12/08/19 21:19:45, ACTION,               mpdwsvc.exe, Creating WER report...
(9E04:9E08) 12/08/19 21:19:45, ACTION,               mpdwsvc.exe, Created the report.
(9E04:9E08) 12/08/19 21:19:45, ACTION,               mpdwsvc.exe, WerReportAddFile Mini Dump succeeded.
(9E04:9E08) 12/08/19 21:19:45, ACTION,               mpdwsvc.exe, Submitting WER report...
(9E04:9E08) 12/08/19 21:22:49, ACTION,               mpdwsvc.exe, Submitted report synchronously.

我查看了错误，发现了 question .答案是在 \package 参数中更改包路径。

如何找到更改包参数的位置？

Answer 1

该链接问题与 SSIS 有关，而您的问题似乎与 Polybase 相关 - 基于转储文件路径。

看看this article看看那里描述的问题是否符合您的经验。