Этот баннер — требование Роскомнадзора для исполнения 152 ФЗ.
«На сайте осуществляется обработка файлов cookie, необходимых для работы сайта, а также для анализа использования сайта и улучшения предоставляемых сервисов с использованием метрической программы Яндекс.Метрика. Продолжая использовать сайт, вы даёте согласие с использованием данных технологий».
Политика конфиденциальности
|
|
|
Нужна помощь в анализе дампа MSSQLН
|
|||
|---|---|---|---|
|
#18+
Добрый день. У меня начал барахлить MSSQL, нужная помощь в анализе DMP файлов. https://www.dropbox.com/s/wybm1gm46r6047j/SQLDump0002.mdmp?dl=0 Ниже выдержка из лог файла. (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () completed with status (00000514) (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 2796 (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0 (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0 (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 00007FF61808BD98 (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters: (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2796 (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0 (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0 (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0 (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x00007FF61808BD98 (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL> (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000 (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000 (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL> (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, PatternForExtraFiles = <NULL> (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL> (7D4:1180) 04/18/18 02:20:16, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL> (7D4:1180) 04/18/18 02:20:16, ACTION, sqlservr.exe, Dump is associated with file C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\LOG\SQLDump0002.txt (7D4:1180) 04/18/18 02:20:16, ACTION, sqlservr.exe, Dump file has original name, no need to rename companion files (7D4:1180) 04/18/18 02:20:16, ACTION, sqlservr.exe, Target suspended (7D4:1180) 04/18/18 02:20:16, ACTION, sqlservr.exe, Callback type 11 not used (7D4:1180) 04/18/18 02:20:16, ACTION, sqlservr.exe, Callback type 15 not used (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Callback type 7 not used (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\LOG\SQLDump0002.mdmp (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Total Buffer pool data pages filtered out: 0 KB (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Total Hekaton data pages filtered out: 0 KB (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Total Free memory (from non top level allocators) filtered out: 0 KB (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Total top level free memory filtered out: 0 KB (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Total Log pool memory filtered out: 0 KB (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\130\Shared\dbghelp.dll' (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, File version of module 'C:\Program Files\Microsoft SQL Server\130\Shared\dbghelp.dll' : '6.12:2.633' (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Product version of module 'C:\Program Files\Microsoft SQL Server\130\Shared\dbghelp.dll' : '6.12:2.633' (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\130\Shared\SQLDUMPER.EXE' (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, File version of module 'C:\Program Files\Microsoft SQL Server\130\Shared\SQLDUMPER.EXE' : '2015.130:1601.5' (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Product version of module 'C:\Program Files\Microsoft SQL Server\130\Shared\SQLDUMPER.EXE' : '13.0:1601.5' (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Send_To_Watson flag is set to true (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Watson Invoke: Yes (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Creating WER report... (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Created the report. (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, WerReportAddFile Mini Dump succeeded. (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, WerReportAddFile SQLDumpFile succeeded. (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, WerReportAddFile Log Tail File succeeded. (7D4:1180) 04/18/18 02:20:17, ACTION, sqlservr.exe, Submitted report asynchronously. На серваке несколько SSD. Один под систему, второй под БД. Архивация идет на отдельный HDD. После ошибок делал DBCC CHECKDB на рабочей БД. Сейчас ошибок нет. Но хотелось бы узнать причину такого плохого поведения MSSQL 2016 ОС: Windows Server 2016 Standart Так же MS SQL Management Studio начал зависать на ровном месте. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 20.04.2018, 04:32 |
|
||
|
|

start [/forum/topic.php?fid=46&fpage=154&tid=1689895]: |
0ms |
get settings: |
10ms |
get forum list: |
17ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
58ms |
get topic data: |
11ms |
get forum data: |
3ms |
get page messages: |
40ms |
get tp. blocked users: |
2ms |
| others: | 256ms |
| total: | 405ms |

| 0 / 0 |
