[2019] Update statistics : une drole d'erreur

**Kropernic** · 25/01/2024, 11h41

Hello,

Je tente de créer un job journalier d'update des statistiques d'une instance sql server 2019 et tout à l'air de bien se passer jusqu'à un certain point où la connexion se coupe sans donner de raison particulière.

Voici le script utilisé :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
DECLARE @DATABASE_NAME NVARCHAR(255);
 
DECLARE db_cursor CURSOR FOR
SELECT name
FROM sys.databases
WHERE database_id > 4;  -- Exclure les bases système
 
 
OPEN db_cursor;
FETCH NEXT FROM db_cursor INTO @DATABASE_NAME;
 
 
WHILE @@FETCH_STATUS = 0
BEGIN
    DECLARE @SQL NVARCHAR(MAX) = N'USE [' + @DATABASE_NAME + ']; EXEC sp_updatestats;';
 
 
    PRINT @SQL;
    EXEC (@SQL);
 
 
    FETCH NEXT FROM db_cursor INTO @DATABASE_NAME;
END
 
 
CLOSE db_cursor;
DEALLOCATE db_cursor;

Et voici le message d'erreur reçu :

Msg 596, Level 21, State 1, Line 0Cannot continue the execution because the session is in the kill state.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

Parfois, j'ai un autre message qui est celui-ci :

Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

J'ai regardé un peu en ligne mais il semblerait que cette erreur puisse survenir pour tout un tas de raison. Je viens donc chercher un peu d'aide.

Je me suis connecté sur le serveur qui héberge l'instance pour aller voir le journal d'évènement de windows et j'ai trouvé ceci :

A user request from the session with SPID 58 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

Sans plus d'indication sur la cause de l'erreur fatale...

Est-ce certains d'entres-vous auraient déjà été confronté à ce problème et auraient des pistes pour m'en sortir ?

Merci d'avance.

**Kropernic** · 25/01/2024, 11h55

Entre temps, j'ai trouvé des trucs dans les errors logs de l'instance sql..

SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

Et j'ai trouvé le dump de l'erreur aussi.

Current time is 11:38:22 01/25/24. =====================================================================
BugCheck Dump
=====================================================================

This file is generated by Microsoft SQL Server
version 15.0.2104.1
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.

Computer type is Intel(R) Xeon(R) Gold 6248R CPU @ 3.00GHz.
Bios Version is INTEL - 6040000
VMW71.00V.21100432.B64.2301110304
4 X64 level 8664, 10 Mhz processor (s).
Windows NT 10.0 Build 17763 CSD .

Memory
MemoryLoad = 57%
Total Physical = 65535 MB
Available Physical = 27703 MB
Total Page File = 75263 MB
Available Page File = 36936 MB
Total Virtual = 134217727 MB
Available Virtual = 134150429 MB
***Stack Dump being sent to E:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\LOG\SQLDump0011.txt
SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 01/25/24 11:38:22 spid 58
*
*
* Exception Address = 00007FFECBF199EC Module(sqllang+00000000014799EC)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0000000000000000
* Input Buffer 510 bytes -
* DECLARE @DatabaseName NVARCHAR(255); DECLARE db_cursor CUR
* SOR FOR SELECT name FROM sys.databases WHERE database_id > 4; -- Exc
* lure les bases système OPEN db_cursor; FETCH NEXT FROM db_cursor INT
* O @DatabaseName; WHILE @@FETCH_STATUS = 0 BEGIN DECLARE @SQL NVARC
* HAR(MAX) = N'USE [' + @DatabaseName + ']; EXEC sp_updatestats;'; --P
* RINT @SQL; EXEC (@SQL); FETCH NEXT FROM db_cursor INTO @Databas
* eName; END CLOSE db_cursor; DEALLOCATE db_cursor;
*
*
* MODULE BASE END SIZE
* sqlservr 00007FF64C620000 00007FF64C6BDFFF 0009e000
* ntd1l 000002043B610000 000002043B7FDFFF 001ee000
* kern3l32 000002043B800000 000002043B8B2FFF 000b3000
* ntdll 00007FFEE8BE0000 00007FFEE8DCDFFF 001ee000
* KERNEL32 00007FFEE6940000 00007FFEE69F2FFF 000b3000
* KERNELBASE 00007FFEE51B0000 00007FFEE544CFFF 0029d000
* InProcessClient64 00007FFEE47E0000 00007FFEE4AF2FFF 00313000
* ADVAPI32 00007FFEE8B00000 00007FFEE8BA7FFF 000a8000
* msvcrt 00007FFEE6640000 00007FFEE66DDFFF 0009e000
* sechost 00007FFEE6A00000 00007FFEE6AA1FFF 000a2000
* RPCRT4 00007FFEE6AB0000 00007FFEE6BCDFFF 0011e000
* bcrypt 00007FFEE4C80000 00007FFEE4CA5FFF 00026000
* CRYPT32 00007FFEE4F00000 00007FFEE50FDFFF 001fe000
* ucrtbase 00007FFEE4E00000 00007FFEE4EF9FFF 000fa000
* MSASN1 00007FFEE4C10000 00007FFEE4C21FFF 00012000
* ole32 00007FFEE64E0000 00007FFEE6635FFF 00156000
* combase 00007FFEE6060000 00007FFEE638AFFF 0032b000
* bcryptPrimitives 00007FFEE5120000 00007FFEE51A1FFF 00082000
* GDI32 00007FFEE5E00000 00007FFEE5E28FFF 00029000
* gdi32full 00007FFEE5C50000 00007FFEE5DF9FFF 001aa000
* msvcp_win 00007FFEE4CB0000 00007FFEE4D4FFFF 000a0000
* USER32 00007FFEE8950000 00007FFEE8AE6FFF 00197000
* win32u 00007FFEE4C60000 00007FFEE4C7FFFF 00020000
* NETAPI32 00007FFEDC3C0000 00007FFEDC3D8FFF 00019000
* pdh 00007FFEE0290000 00007FFEE02DCFFF 0004d000
* SQLOS 00007FFED44C0000 00007FFED44C7FFF 00008000
* sqlmin 00007FFECDFC0000 00007FFED0F8CFFF 02fcd000
* WS2_32 00007FFEE6470000 00007FFEE64DCFFF 0006d000
* OLEAUT32 00007FFEE6870000 00007FFEE6933FFF 000c4000
* sqlTsEs 00007FFECD610000 00007FFECDED9FFF 008ca000
* opends60 00007FFECAA90000 00007FFECAA98FFF 00009000
* sqldk 00007FFECD0A0000 00007FFECD5C7FFF 00528000
* qds 00007FFECA950000 00007FFECAA77FFF 00128000
* svl 00007FFEC7950000 00007FFEC797CFFF 0002d000
* MSVCP140 00007FFED8E40000 00007FFED8ECCFFF 0008d000
* MPR 00007FFEDC440000 00007FFEDC45AFFF 0001b000
* VCRUNTIME140 00007FFED94D0000 00007FFED94EAFFF 0001b000
* Secur32 00007FFEDC360000 00007FFEDC36BFFF 0000c000
* WINHTTP 00007FFEDFDE0000 00007FFEDFEDCFFF 000fd000
* secforwarder 00007FFEC7930000 00007FFEC7940FFF 00011000
* ODBC32 00007FFEC7870000 00007FFEC792BFFF 000bc000
* WINMM 00007FFED7910000 00007FFED7933FFF 00024000
* VCRUNTIME140_1 00007FFED7900000 00007FFED790BFFF 0000c000
* ncrypt 00007FFEE4370000 00007FFEE439BFFF 0002c000
* WINMMBASE 00007FFED7610000 00007FFED763CFFF 0002d000
* cfgmgr32 00007FFEE5C00000 00007FFEE5C49FFF 0004a000
* WININET 00007FFEC7380000 00007FFEC7861FFF 004e2000
* SSPICLI 00007FFEE4770000 00007FFEE479EFFF 0002f000
* DPAPI 00007FFEE46A0000 00007FFEE46A9FFF 0000a000
* NETUTILS 00007FFEE3DF0000 00007FFEE3DFDFFF 0000e000
* sqllang 00007FFECAAA0000 00007FFECD098FFF 025f9000
* SAMCLI 00007FFEE0930000 00007FFEE0947FFF 00018000
* WINTRUST 00007FFEE5BA0000 00007FFEE5BFEFFF 0005f000
* USERENV 00007FFEE47A0000 00007FFEE47C8FFF 00029000
* profapi 00007FFEE4C30000 00007FFEE4C52FFF 00023000
* AUTHZ 00007FFEE39F0000 00007FFEE3A3CFFF 0004d000
* XmlLite 00007FFEDE870000 00007FFEDE8A9FFF 0003a000
* dhcpcsvc 00007FFEE1ED0000 00007FFEE1EEBFFF 0001c000
* NSI 00007FFEE7330000 00007FFEE7337FFF 00008000
* LOGONCLI 00007FFEE3ED0000 00007FFEE3F10FFF 00041000
* VERSION 00007FFEE4760000 00007FFEE4769FFF 0000a000
* FLTLIB 00007FFEE4750000 00007FFEE4759FFF 0000a000
* NTASN1 00007FFEE4330000 00007FFEE436BFFF 0003c000
* psapi 00007FFEE8AF0000 00007FFEE8AF7FFF 00008000
* kernel.appcore 00007FFEE4B90000 00007FFEE4BA0FFF 00011000
* instapi150 00007FFEC0B70000 00007FFEC0B82FFF 00013000
* CRYPTSP 00007FFEE5100000 00007FFEE511AFFF 0001b000
* rsaenh 00007FFEE3C20000 00007FFEE3C52FFF 00033000
* CRYPTBASE 00007FFEE4270000 00007FFEE427BFFF 0000c000
* imagehlp 000002043BFD0000 000002043BFECFFF 0001d000
* gpapi 00007FFEE36E0000 00007FFEE3701FFF 00022000
* wkscli 00007FFEDFF00000 00007FFEDFF19FFF 0001a000
* cscapi 00007FFEC3850000 00007FFEC3861FFF 00012000
* sqlevn70 000002043C240000 000002043C579FFF 0033a000
* CLUSAPI 00007FFED4A60000 00007FFED4B67FFF 00108000
* DNSAPI 00007FFEE3E00000 00007FFEE3EC5FFF 000c6000
* IPHLPAPI 00007FFEE3DB0000 00007FFEE3DECFFF 0003d000
* RESUTILS 00007FFED4C80000 00007FFED4D1DFFF 0009e000
* hkruntime 00007FFEBA950000 00007FFEBAC22FFF 002d3000
* hkcompile 00007FFEB9CE0000 00007FFEB9E1FFFF 00140000
* SHLWAPI 00007FFEE6390000 00007FFEE63E1FFF 00052000
* hkengine 00007FFEB95B0000 00007FFEB9CA5FFF 006f6000
* dbghelp 00007FFEDF830000 00007FFEDFA1CFFF 001ed000
* ncryptprov 00007FFEDC3E0000 00007FFEDC439FFF 0005a000
* msv1_0 00007FFEE4020000 00007FFEE409AFFF 0007b000
* NtlmShared 00007FFEE4010000 00007FFEE401CFFF 0000d000
* cryptdll 00007FFEE4110000 00007FFEE4124FFF 00015000
* kerberos 00007FFEE4160000 00007FFEE4263FFF 00104000
* schannel 00007FFEE3B40000 00007FFEE3BCBFFF 0008c000
* SECURITY 00000211EE590000 00000211EE592FFF 00003000
* MSCOREE 00007FFEDCBE0000 00007FFEDCC43FFF 00064000
* mscoreei 00007FFEDC2C0000 00007FFEDC35BFFF 0009c000
* SqlServerSpatial150 00007FFEB4640000 00007FFEB46E1FFF 000a2000
* clbcatq 00007FFEE7210000 00007FFEE72B7FFF 000a8000
* msoledbsql 00007FFEB4080000 00007FFEB431EFFF 0029f000
* COMDLG32 00007FFEE6740000 00007FFEE6865FFF 00126000
* shcore 00007FFEE88A0000 00007FFEE8946FFF 000a7000
* SHELL32 00007FFEE73A0000 00007FFEE8897FFF 014f8000
* windows.storage 00007FFEE5450000 00007FFEE5B96FFF 00747000
* powrprof 00007FFEE4BB0000 00007FFEE4C0CFFF 0005d000
* COMCTL32 00007FFED1BB0000 00007FFED1C58FFF 000a9000
* MSWSOCK 00007FFEE40A0000 00007FFEE4106FFF 00067000
* MSOLEDBSQLR 00000211F69E0000 00000211F6A02FFF 00023000
* dhcpcsvc6 00007FFEE1EF0000 00007FFEE1F05FFF 00016000
* sqlncli11 00007FFEB3800000 00007FFEB3B52FFF 00353000
* MSVCR100 00000000651D0000 00000000652A1FFF 000d2000
* msxml3 00007FFEB4940000 00007FFEB4B7AFFF 0023b000
* SQLNCLIR11 00000211F6A70000 00000211F6AA7FFF 00038000
* netbios 00007FFEB3450000 00007FFEB345BFFF 0000c000
* sqlnclirda11 0000000064E70000 00000000651C8FFF 00359000
* SQLNCLIRDAR11 00000211F6AC0000 00000211F6AF7FFF 00038000
* clr 00007FFED61A0000 00007FFED6BDAFFF 00a3b000
* MSVCR120_CLR0400 00007FFED5700000 00007FFED57F6FFF 000f7000
* mscorlib.ni 00007FFED1CF0000 00007FFED32DAFFF 015eb000
* ualapi 00007FFEDD260000 00007FFEDD279FFF 0001a000
* ESENT 00007FFEDCD90000 00007FFEDD0BAFFF 0032b000
* ntmarta 00007FFEE3640000 00007FFEE3670FFF 00031000
* SqlAccess 00007FFEB2FC0000 00007FFEB3035FFF 00076000
* clrjit 00007FFEC4AE0000 00007FFEC4C0AFFF 0012b000
* BatchParser 00007FFEB2990000 00007FFEB29B9FFF 0002a000
* SRVCLI 00007FFEE3860000 00007FFEE3885FFF 00026000
* mskeyprotect 00007FFEC3550000 00007FFEC3564FFF 00015000
* ntdsapi 00007FFEDCC50000 00007FFEDCC77FFF 00028000
* DSPARSE 00007FFEDEC10000 00007FFEDEC1CFFF 0000d000
* rasadhlp 00007FFEDF640000 00007FFEDF649FFF 0000a000
* fwpuclnt 00007FFEE2000000 00007FFEE2078FFF 00079000
* ncryptsslp 00007FFEC38E0000 00007FFEC3903FFF 00024000
* xpsqlbot 00007FFEC07F0000 00007FFEC07F9FFF 0000a000
* xpstar 00007FFEC0770000 00007FFEC07E1FFF 00072000
* SQLSCM 00007FFEB2600000 00007FFEB2613FFF 00014000
* xpstar 0000021380A90000 0000021380A9CFFF 0000d000
* sqlvdi 00007FFEACAD0000 00007FFEACB0AFFF 0003b000
* xplog70 00007FFEBD500000 00007FFEBD515FFF 00016000
* xplog70 0000021380AE0000 0000021380AE3FFF 00004000
* odbccp32 00007FFEB2570000 00007FFEB2595FFF 00026000
* DSROLE 00007FFEE2480000 00007FFEE2489FFF 0000a000
* apphelp 00007FFEE1F30000 00007FFEE1FBBFFF 0008c000
* sqlevn70 000002137CE60000 000002137D24FFFF 003f0000
* sqlevn70 0000021381220000 000002138160DFFF 003ee000
* sqlevn70 0000021381610000 0000021381828FFF 00219000
* sqlevn70 0000021381BF0000 0000021381F6DFFF 0037e000
* sqlevn70 0000021382B20000 0000021382EEEFFF 003cf000
* sqlevn70 0000021382EF0000 00000213832C7FFF 003d8000
* sqlevn70 0000021381F70000 0000021382318FFF 003a9000
* sqlevn70 00000213832D0000 0000021383681FFF 003b2000
* sqlevn70 0000021383690000 00000213839F1FFF 00362000
* sqlevn70 0000021383A00000 0000021383D69FFF 0036a000
* sqlevn70 0000021383D70000 00000213840BEFFF 0034f000
* sqlevn70 00000213840C0000 000002138448AFFF 003cb000
* sqlevn70 0000021384490000 000002138485BFFF 003cc000
* sqlevn70 0000021384860000 0000021384C6BFFF 0040c000
* sqlevn70 0000021384C70000 000002138500BFFF 0039c000
* sqlevn70 0000021385010000 000002138535EFFF 0034f000
* sqlevn70 0000021385360000 00000213856FCFFF 0039d000
* sqlevn70 0000021381900000 0000021381A80FFF 00181000
* sqlevn70 0000021385700000 000002138590CFFF 0020d000
* sqlevn70 0000021385910000 0000021385A82FFF 00173000
* sqlevn70 0000021385A90000 0000021385DE9FFF 0035a000
*
* P1Home: 00000094687F6290: 0000000000000000 0000FFFF00001FA8 0000000000000000 0000000000000000 00000000
00000000 0000000000000000
* P2Home: 00007FFECDFFC19E: 00000DC0249C8B48 4100000D70C48148 5F5C415D415E415F E92C245C8BC35D5E 909090CC
FFFFFAB7 9090909090909090
* P3Home: 0000020A7E5ECE98: 00007FFECFC168E8 00007FFECFC184C0 00000000000A0005 00007FFECFC16D58 0000020B
94BF0AA8 0000020A7E5ECC40
* P4Home: 00007D78A4E70000:
* P5Home: FFFFFFFFFFFFFFFE:
* P6Home: 00000094687F67D8: 010000015DBB0000 0000000000000100 0000010000015DBB 0000020BB2E9FB50 00007D78
A4E70000 00000094687F6BC0
* ContextFlags: 000000000010005F:
* MxCsr: 0000000000001FA8:
* SegCs: 0000000000000033:
* SegDs: 000000000000002B:
* SegEs: 000000000000002B:
* SegFs: 0000000000000053:
* SegGs: 000000000000002B:
* SegSs: 000000000000002B:
* EFlags: 0000000000010202:
* Rax: 0000000000000000:
* Rcx: 0000000000000000:
* Rdx: 0000000000000000:
* Rbx: 0000020A7E5ECE98: 00007FFECFC168E8 00007FFECFC184C0 00000000000A0005 00007FFECFC16D58 0000020B
94BF0AA8 0000020A7E5ECC40
* Rsp: 00000094687F6EE0: 0000020A7E5ECE98 0000000000000000 00000094687F71C1 00007FFECE17F2AE 00000000
00000000 0000000000000000
* Rbp: 00000094687F7018: 0000000000000030 00009126A18E91CE 00007FFEE4E25EB8 00000094687F7150 00000000
00000008 0000000000000008
* Rsi: 0000020A7E5ECE28: 00007FFECFC163E0 00007FFECFC16998 0000000000000000 0000000000000000 00000000
00000000 0000000000000000
* Rdi: 0000020A7E5ECEE8: 00007FFECFC167A0 00007FFECFC16C78 00000000000A0001 00007FFECFBEE820 00000000
00000000 0000020A7E5ECC40
* R8: 0000000000000000:
* R9: 0000020B94BEFFB0: 0000020B94BF08D0 0000000000000000 0000004000000005 0000000000000010 0000020B
94BF0BB0 0000020B00000028
* R10: 0000000000000000:
* R11: 0FFFFFFFFFFFFF03:
* R12: 0000020A7E5ECE28: 00007FFECFC163E0 00007FFECFC16998 0000000000000000 0000000000000000 00000000
00000000 0000000000000000
* R13: 0000000000000013:
* R14: 0000020A8EF04040: 00007FFECD264BF0 0000020A00000001 0000000000002000 0000000000000006 0000020B
988D1CC0 0000000000000000
* R15: 0000000008000002:
* Rip: 00007FFECBF199EC: 8B484852FF108B48 FF108B48F88B4CC8 B8004D89C88B3852 202444C600000004 FFC1C748
E1F74801 CA1A058D4CFFFFFF
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
00007FFECBF199EC Module(sqllang+00000000014799EC)
00007FFECAC19739 Module(sqllang+0000000000179739)
00007FFECBF19F2F Module(sqllang+0000000001479F2F)
00007FFECE634DA9 Module(sqlmin+0000000000674DA9)
00007FFECE5D51C5 Module(sqlmin+00000000006151C5)
00007FFECD612967 Module(sqlTsEs+0000000000002967)
00007FFECDFF5FFE Module(sqlmin+0000000000035FFE)
00007FFECDFF4C0F Module(sqlmin+0000000000034C0F)
00007FFECDFF4CDC Module(sqlmin+0000000000034CDC)
00007FFECDFEB031 Module(sqlmin+000000000002B031)
00007FFECDFEB031 Module(sqlmin+000000000002B031)
00007FFECDFEB031 Module(sqlmin+000000000002B031)
00007FFECE01D67E Module(sqlmin+000000000005D67E)
00007FFECE017F5E Module(sqlmin+0000000000057F5E)
00007FFECAAAFF40 Module(sqllang+000000000000FF40)
00007FFECAAAFFEF Module(sqllang+000000000000FFEF)
00007FFECAAFC48E Module(sqllang+000000000005C48E)
00007FFECAAB1FA9 Module(sqllang+0000000000011FA9)
00007FFECAAFC422 Module(sqllang+000000000005C422)
00007FFECAAFAD17 Module(sqllang+000000000005AD17)
00007FFECAAB0806 Module(sqllang+0000000000010806)
00007FFECAAB112C Module(sqllang+000000000001112C)
00007FFECAAB18DE Module(sqllang+00000000000118DE)
00007FFECAAF7451 Module(sqllang+0000000000057451)
00007FFECAAF7C5C Module(sqllang+0000000000057C5C)
00007FFECAAF7B08 Module(sqllang+0000000000057B08)
00007FFECAAB0806 Module(sqllang+0000000000010806)
00007FFECAAB112C Module(sqllang+000000000001112C)
00007FFECAAB18DE Module(sqllang+00000000000118DE)
00007FFECB7551EF Module(sqllang+0000000000CB51EF)
00007FFECB751498 Module(sqllang+0000000000CB1498)
00007FFECAAB0806 Module(sqllang+0000000000010806)
00007FFECAAB112C Module(sqllang+000000000001112C)
00007FFECAAB18DE Module(sqllang+00000000000118DE)
00007FFECAABBAF6 Module(sqllang+000000000001BAF6)
00007FFECAAB9FB6 Module(sqllang+0000000000019FB6)
00007FFECAAB97AF Module(sqllang+00000000000197AF)
00007FFECD0A9FF3 Module(sqldk+0000000000009FF3)
00007FFECD0AA90D Module(sqldk+000000000000A90D)
00007FFECD0AA4E5 Module(sqldk+000000000000A4E5)
00007FFECD0D3102 Module(sqldk+0000000000033102)
00007FFECD0D2CDC Module(sqldk+0000000000032CDC)
00007FFECD0D2AD5 Module(sqldk+0000000000032AD5)
00007FFEE6957AC4 Module(KERNEL32+0000000000017AC4)
00007FFEE8C3A4E1 Module(ntdll+000000000005A4E1)

CSession @0x0000020A7E582810
----------------------------
m_sessionId = 58 m_cRef = 20 m_rgcRefType[0] = 1
m_rgcRefType[1] = 1 m_rgcRefType[2] = 17 m_rgcRefType[3] = 1
m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x0000020A7E582040
m_pstackBhfPool = 0x0000020A7C99C040 m_dwLoginFlags = 0x100083e0 m_fBackground = 0
m_eConnResetOption = 0 m_fUserProc = 1 m_fConnReset = 0
m_fIsConnReset = 0 m_fInLogin = 0 m_fAuditLoginSent = 1
m_fAuditLoginFailedSent = 0 m_fReplRelease = 0 m_fKill = 0
m_ulLoginStamp = 131917 m_eclClient = 7 m_protType = 5

CUEnvTransient @0x0000020A7E583BA0
----------------------------------
m_ululRowcount = 1 m_cidLastOpen = 0 m_lFetchStat = 0
m_lRetStat = 0 m_lLastError = 0 m_lPrevError = 0
m_cNestLevel = 0 m_lHoldRand1 = 0 m_lHoldRand2 = 0
m_cbContextInfo = 0 m_rgbContextInfo = 0000020A7E583D9C

CDbAndSetOpts @0x0000020A7E583BC0
---------------------------------
m_fHasDbRef = 0 m_fDateFirstSet = 0 m_fDateFormatSet = 0
m_lUserOpt1 = 0x14817000 m_lUserOpt2 = 0x40 m_lUserOpt1SetMask = 0xfffff7f7
m_idtInsert.objid = 0 m_idtInsert.state = 0 m_idtInsert.dbid = 0
m_llRowcnt = 0 m_lStatList = 0 m_lTextSize = 2147483647
m_lOffsets = 0x0 m_ulLockTimeout = 4294967295 m_ulQueryGov = 0
m_eDtFmt = 1 m_eDayDateFirst = 7 m_eDdLckPri = 0
m_eIsoLvl = 2 m_eFipsFlag = 0x0 m_sLangId = 0

m_pV7LoginRec
---------------------
0000000000000000: 73010000 04000074 00100000 00000006 2c440000 s......t........,D..

0000000000000014: 00000000 e0830010 00000000 00000000 5e000f00 ....àƒ..........^...

0000000000000028: 00000000 00000000 7c002e00 d8000f00 f6000400 ........|...Ø...ö...

000000000000003C: fa001c00 32010000 32010400 80b779d0 65363a01 ú...2...2....·yÐe6:.

0000000000000050: 28006201 00006201 00000000 0000 (.b...b.......

CPhysicalConnection @0x0000020A7E5823E0
---------------------------------------
m_pPhyConn->m_pmo = 0x0000020A7E582040
m_pPhyConn->m_pNetConn = 0x0000020A7E586040
m_pPhyConn->m_pConnList = 0x0000020A7E5827E0
m_pPhyConn->m_pSess = 0x0000020A7E582860 m_pPhyConn->m_fTracked = 1
m_pPhyConn->m_cbPacketsize = 4096 m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0

CBatch @0x0000020A7E586D20
--------------------------
m_pSess = 0x0000020A7E582810 m_pConn = 0x0000020A7E586700 m_cRef = 3
m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1
m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x0000020BB6F51088

EXCEPT (null) @0x00000094687F3348
---------------------------------
exc_number = 0 exc_severity = 0 exc_func = sqldk.dll+0x0000000000050DD0

Task @0x0000020BB6F51088
------------------------
CPU Ticks used (ms) = 558 Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x0000000000000000 WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x0000000000000000 SchedulerId = 0x3
ThreadId = 0x2c24 m_state = 0 m_eAbortSev = 0

EC @0x0000020A7E58A970
----------------------
spid = 0 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x0 ec_atomic = 0x0 ecType = 0
__pSETLS = 0x0000020A7E586770 __pSEParams = 0x0000020A7E586ED0

SEInternalTLS @0x0000020A7E586770
---------------------------------
m_activeHeapDatasetList = 0x0000020A7E586B80
m_activeIndexDatasetList = 0x0000020A7E586B90 m_flags = 0
m_TLSstatus = 3 m_CriticalOpDbId = 65535 m_CloudHostDbId = 65535
m_RestoringDbId = 65535 m_RestoreTargetDbId = 0 m_isReplicatedSysDb = false
m_noLockScanCount = 0 m_readonlyDatabaseScan = false m_inCatchupRedo = false
m_pBulkOpLockNotification = 0x0000000000000000 m_pDbccContext = 0x0000000000000000
m_pCompressionContext = 0x0000000000000000
m_pRetentionCleanupContext = 0x0000000000000000 m_pAllocFileLimit = 0x0000000000000000
m_dekInstanceIndex = 0x-1 m_pImbiContext = 0x0000000000000000
m_pNcciThreadContext = 0x0000000000000000

SEParams @0x0000020A7E586ED0
----------------------------
m_lockTimeout = -1 m_isoLevel = 4096 m_logDontReplicate = 0
m_neverReplicate = 0 m_XactWorkspace = 0x0000020B2F1B0D70
m_execStats = 0x00000209F954CF00

J'ai aussi remarqué que le problème se produit toujours sur la même DB. Il y a donc manifestement un souci avec cette DB en particulier...

**SQLpro** · 25/01/2024, 17h44

Il y a d'autres fichiers associé au dump. Peux tu les poster ?

Met aussi le type de machine et si c'est une VM :
1) les caractéristiques de la machine hôte (constructeur, type, matériel)
2) le réglage de la VM au niveau cœurs, RAM, CPU (copies exhaustive d'écrans de l'hyperviseur).

A +

**Sankasssss** · 26/01/2024, 13h20

Bonjour Frédéric,

Je suis le collègue de Kropernic, il est en congé aujourd'hui je vais donc essayer de te donner les infos.

Merci de t'intéresser à notre problème.

Envoyé par SQLpro

Il y a d'autres fichiers associé au dump. Peux tu les poster ?

Je suis allé voir dans le dossier : E:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\LOG\
Et le fichier "SQL DumpXXXX.txt" est le seul généré dans l'intervalle où j'exécute la requête.

Si tu as une piste où l'on peut trouver des fichiers supplémentaires je suis preneur.

Le "Log File Viewer" de SSMS renvoyant vers le dossier précédent j'ai aussi ceci :

Date,Source,Severity,Message
01/26/2024 11:10:46,Server,Unknown,A user request from the session with SPID 56 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
01/26/2024 11:10:46,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
01/26/2024 11:10:46,spid56,Unknown,Dump request is dismissed (stack signature 0x000000002B184DF6).
01/26/2024 11:10:46,spid56,Unknown,Stack Signature for the dump is 0x000000002B184DF6
01/26/2024 11:10:46,spid56,Unknown,00007FF8EAC7A4E1 Module(ntdll+000000000005A4E1)
01/26/2024 11:10:46,spid56,Unknown,00007FF8EA517AC4 Module(KERNEL32+0000000000017AC4)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C01242B8 Module(sqldk+00000000000242B8)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0123D2F Module(sqldk+0000000000023D2F)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0124482 Module(sqldk+0000000000024482)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C010A38E Module(sqldk+000000000000A38E)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C010A5BF Module(sqldk+000000000000A5BF)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C010A013 Module(sqldk+000000000000A013)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F748A3 Module(sqllang+00000000000148A3)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F74786 Module(sqllang+0000000000014786)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F76A15 Module(sqllang+0000000000016A15)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6C345 Module(sqllang+000000000000C345)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6CB4C Module(sqllang+000000000000CB4C)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6BA72 Module(sqllang+000000000000BA72)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C1C44648 Module(sqllang+0000000000CE4648)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C1C483A2 Module(sqllang+0000000000CE83A2)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6C345 Module(sqllang+000000000000C345)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6CB4C Module(sqllang+000000000000CB4C)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6BA72 Module(sqllang+000000000000BA72)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C12D3958 Module(sqllang+0000000000373958)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C12D3AAF Module(sqllang+0000000000373AAF)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C12D3C91 Module(sqllang+0000000000373C91)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6C345 Module(sqllang+000000000000C345)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6CB4C Module(sqllang+000000000000CB4C)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6BA72 Module(sqllang+000000000000BA72)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C12CC547 Module(sqllang+000000000036C547)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C12CE502 Module(sqllang+000000000036E502)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6E45F Module(sqllang+000000000000E45F)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C12CE53E Module(sqllang+000000000036E53E)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6B2FF Module(sqllang+000000000000B2FF)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0F6B248 Module(sqllang+000000000000B248)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C3B08782 Module(sqlmin+0000000000068782)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C3B08D53 Module(sqlmin+0000000000068D53)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C3AC5741 Module(sqlmin+0000000000025741)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C3AC5741 Module(sqlmin+0000000000025741)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C3AC5741 Module(sqlmin+0000000000025741)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C3AD2ACC Module(sqlmin+0000000000032ACC)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C3AD0D5F Module(sqlmin+0000000000030D5F)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C3AD29BE Module(sqlmin+00000000000329BE)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C0672FD7 Module(sqlTsEs+0000000000002FD7)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C40D8B95 Module(sqlmin+0000000000638B95)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C4139B29 Module(sqlmin+0000000000699B29)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C241675F Module(sqllang+00000000014B675F)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C118B7D9 Module(sqllang+000000000022B7D9)
01/26/2024 11:10:46,spid56,Unknown,00007FF8C241621E Module(sqllang+00000000014B621E)
01/26/2024 11:10:46,spid56,Unknown,* Short Stack Dump
01/26/2024 11:10:46,spid56,Unknown,* -------------------------------------------------------------------------------
01/26/2024 11:10:46,spid56,Unknown,* *******************************************************************************
01/26/2024 11:10:46,spid56,Unknown,* Rip: 00007FF8C241621E: 8B484852FF108B48 FF108B48F88B4CC8 B8004D89C88B3852 202444C600000004 FFC1C748E1F74801 FCE8058D4CFFFFFF
01/26/2024 11:10:46,spid56,Unknown,* R15: 0000000008000002:
01/26/2024 11:10:46,spid56,Unknown,* R14: 0000019675234040: 00007FF8C02CBEA0 0000019600000001 0000000000002000 0000000000000006 000001960E05DA80 0000000000000000
01/26/2024 11:10:46,spid56,Unknown,* R13: 0000000000000013:
01/26/2024 11:10:46,spid56,Unknown,* R12: 00000196969AEE28: 00007FF8C5787368 00007FF8C5787728 0000000000000000 0000000000000000 0000000000000000 0000000000000000
01/26/2024 11:10:46,spid56,Unknown,* R11: 0FFFFFFFFFFFFF03:
01/26/2024 11:10:46,spid56,Unknown,* R10: 0000000000000000:
01/26/2024 11:10:46,spid56,Unknown,* R9: 000001963698F440: 000001963698FB60 0000000000000000 0000004000080005 0000000000000180 00007FF8C578F718 000001963698ED50
01/26/2024 11:10:46,spid56,Unknown,* R8: 0000000000000000:
01/26/2024 11:10:46,spid56,Unknown,* Rdi: 00000196969AEEE8: 00007FF8C5787A18 00007FF8C5787C08 0000019696A7C841 00007FF8C5777F20 0000000000000000 00000196969AEC40
01/26/2024 11:10:46,spid56,Unknown,* Rsi: 00000196969AEE28: 00007FF8C5787368 00007FF8C5787728 0000000000000000 0000000000000000 0000000000000000 0000000000000000
01/26/2024 11:10:46,spid56,Unknown,* Rbp: 0000002105FF7558: 0000000000000030 0000C4169489C30A 00007FF8E7075EB8 0000002105FF7690 0000000000000008 0000000000000008
01/26/2024 11:10:46,spid56,Unknown,* Rsp: 0000002105FF7420: 00000196969AEE98 0000000000000000 0000002105FF7701 00007FF8C3C386FE 0000000000000000 0000000000000000
01/26/2024 11:10:46,spid56,Unknown,* Rbx: 00000196969AEE98: 00007FF8C5787B60 00007FF8C5788818 0000000000000001 00007FF8C5787CE8 000001963698FD38 00000196969AEC40
01/26/2024 11:10:46,spid56,Unknown,* Rdx: 0000000000000000:
01/26/2024 11:10:46,spid56,Unknown,* Rcx: 0000000000000000:
01/26/2024 11:10:46,spid56,Unknown,* Rax: 0000000000000000:
01/26/2024 11:10:46,spid56,Unknown,* EFlags: 0000000000010202:
01/26/2024 11:10:46,spid56,Unknown,* SegSs: 000000000000002B:
01/26/2024 11:10:46,spid56,Unknown,* SegGs: 000000000000002B:
01/26/2024 11:10:46,spid56,Unknown,* SegFs: 0000000000000053:
01/26/2024 11:10:46,spid56,Unknown,* SegEs: 000000000000002B:
01/26/2024 11:10:46,spid56,Unknown,* SegDs: 000000000000002B:
01/26/2024 11:10:46,spid56,Unknown,* SegCs: 0000000000000033:
01/26/2024 11:10:46,spid56,Unknown,* MxCsr: 0000000000001FA8:
01/26/2024 11:10:46,spid56,Unknown,* ContextFlags: 000000000010005F:
01/26/2024 11:10:46,spid56,Unknown,* P6Home: 000001958C930920: 0000000000000000 0000000000000000 0000000000000000 000001958C9039E0 4F0BA0690A216F62 839D52095B6273AA
01/26/2024 11:10:46,spid56,Unknown,* P5Home: FFFFFFFFFFFFFFFE:
01/26/2024 11:10:46,spid56,Unknown,* P4Home: 00007D78A4E70000:
01/26/2024 11:10:46,spid56,Unknown,* P3Home: 00000196969AEE98: 00007FF8C5787B60 00007FF8C5788818 0000000000000001 00007FF8C5787CE8 000001963698FD38 00000196969AEC40
01/26/2024 11:10:46,spid56,Unknown,* P2Home: 00007FF8C3AD8D05: 00000DC0249C8B48 4100000D70C48148 5F5C415D415E415F 48245C8B48C35D5E FFFAC0E92C247C8B B70F46F1B70FCCFF
01/26/2024 11:10:46,spid56,Unknown,* P1Home: 0000002105FF67D0: 0000000000000000 0000FFFF00001FA8 0000000000000000 0000000000000000 0000000000000000 0000000000000000
01/26/2024 11:10:46,spid56,Unknown,*
01/26/2024 11:10:46,spid56,Unknown,* msadcer 000001A4D16A0000 000001A4D16A2FFF 00003000
01/26/2024 11:10:46,spid56,Unknown,* msadce 00007FF8A9E60000 00007FF8A9F0FFFF 000b0000
01/26/2024 11:10:46,spid56,Unknown,* Comctl32 00007FF8B4130000 00007FF8B43A8FFF 00279000
01/26/2024 11:10:46,spid56,Unknown,* MSDART 00007FF8B4CB0000 00007FF8B4CD6FFF 00027000
01/26/2024 11:10:46,spid56,Unknown,* oledb32 00007FF8B4CE0000 00007FF8B4DCEFFF 000ef000
01/26/2024 11:10:46,spid56,Unknown,* odbccp32 00007FF8A7860000 00007FF8A7885FFF 00026000
01/26/2024 11:10:46,spid56,Unknown,* xplog70 000001A4D1040000 000001A4D1043FFF 00004000
01/26/2024 11:10:46,spid56,Unknown,* xplog70 00007FF8E09D0000 00007FF8E09E5FFF 00016000
01/26/2024 11:10:46,spid56,Unknown,* sqlvdi 00007FF8BA9C0000 00007FF8BA9FAFFF 0003b000
01/26/2024 11:10:46,spid56,Unknown,* xpstar 000001A4D1010000 000001A4D101CFFF 0000d000
01/26/2024 11:10:46,spid56,Unknown,* SQLSCM 00007FF8A7820000 00007FF8A7833FFF 00014000
01/26/2024 11:10:46,spid56,Unknown,* xpstar 00007FF8B9F30000 00007FF8B9FA1FFF 00072000
01/26/2024 11:10:46,spid56,Unknown,* xpsqlbot 00007FF8B9FB0000 00007FF8B9FB9FFF 0000a000
01/26/2024 11:10:46,spid56,Unknown,* ncryptsslp 00007FF8BF530000 00007FF8BF553FFF 00024000
01/26/2024 11:10:46,spid56,Unknown,* fwpuclnt 00007FF8E1D80000 00007FF8E1DF8FFF 00079000
01/26/2024 11:10:46,spid56,Unknown,* rasadhlp 00007FF8DDEF0000 00007FF8DDEF9FFF 0000a000
01/26/2024 11:10:46,spid56,Unknown,* DSPARSE 00007FF8DE2A0000 00007FF8DE2ACFFF 0000d000
01/26/2024 11:10:46,spid56,Unknown,* ntdsapi 00007FF8DBD50000 00007FF8DBD77FFF 00028000
01/26/2024 11:10:46,spid56,Unknown,* mskeyprotect 00007FF8BECC0000 00007FF8BECD4FFF 00015000
01/26/2024 11:10:46,spid56,Unknown,* SRVCLI 00007FF8E5860000 00007FF8E5885FFF 00026000
01/26/2024 11:10:46,spid56,Unknown,* BatchParser 00007FF8A8CA0000 00007FF8A8CC9FFF 0002a000
01/26/2024 11:10:46,spid56,Unknown,* ntmarta 00007FF8E59D0000 00007FF8E5A00FFF 00031000
01/26/2024 11:10:46,spid56,Unknown,* ESENT 00007FF8DB850000 00007FF8DBB7AFFF 0032b000
01/26/2024 11:10:46,spid56,Unknown,* ualapi 00007FF8DBBC0000 00007FF8DBBD9FFF 0001a000
01/26/2024 11:10:46,spid56,Unknown,* clrjit 00007FF8CFEA0000 00007FF8CFFCAFFF 0012b000
01/26/2024 11:10:46,spid56,Unknown,* SqlAccess 00007FF8AAEA0000 00007FF8AAF15FFF 00076000
01/26/2024 11:10:46,spid56,Unknown,* mscorlib.ni 00007FF8D0E80000 00007FF8D246AFFF 015eb000
01/26/2024 11:10:46,spid56,Unknown,* MSVCR120_CLR0400 00007FF8D6D10000 00007FF8D6E06FFF 000f7000
01/26/2024 11:10:46,spid56,Unknown,* clr 00007FF8DA490000 00007FF8DAECAFFF 00a3b000
01/26/2024 11:10:46,spid56,Unknown,* msxml3 00007FF8ABC20000 00007FF8ABE5AFFF 0023b000
01/26/2024 11:10:46,spid56,Unknown,* SQLNCLIRDAR11 000001A3472E0000 000001A347317FFF 00038000
01/26/2024 11:10:46,spid56,Unknown,* sqlnclirda11 0000000077CA0000 0000000077FF8FFF 00359000
01/26/2024 11:10:46,spid56,Unknown,* netbios 00007FF8AC440000 00007FF8AC44BFFF 0000c000
01/26/2024 11:10:46,spid56,Unknown,* SQLNCLIR11 000001A33F060000 000001A33F097FFF 00038000
01/26/2024 11:10:46,spid56,Unknown,* MSVCR100 00000000500E0000 00000000501B1FFF 000d2000
01/26/2024 11:10:46,spid56,Unknown,* sqlncli11 00007FF8AC450000 00007FF8AC7A2FFF 00353000
01/26/2024 11:10:46,spid56,Unknown,* dhcpcsvc6 00007FF8E1CA0000 00007FF8E1CB5FFF 00016000
01/26/2024 11:10:46,spid56,Unknown,* MSOLEDBSQLR 000001A33EEF0000 000001A33EF12FFF 00023000
01/26/2024 11:10:46,spid56,Unknown,* MSWSOCK 00007FF8E6080000 00007FF8E60E6FFF 00067000
01/26/2024 11:10:46,spid56,Unknown,* COMCTL32 00007FF8CEF70000 00007FF8CF018FFF 000a9000
01/26/2024 11:10:46,spid56,Unknown,* powrprof 00007FF8E6BD0000 00007FF8E6C2CFFF 0005d000
01/26/2024 11:10:46,spid56,Unknown,* windows.storage 00007FF8E7400000 00007FF8E7B46FFF 00747000
01/26/2024 11:10:46,spid56,Unknown,* SHELL32 00007FF8E86E0000 00007FF8E9BD7FFF 014f8000
01/26/2024 11:10:46,spid56,Unknown,* shcore 00007FF8EA110000 00007FF8EA1B6FFF 000a7000
01/26/2024 11:10:46,spid56,Unknown,* COMDLG32 00007FF8E7E40000 00007FF8E7F65FFF 00126000
01/26/2024 11:10:46,spid56,Unknown,* msoledbsql 00007FF8ACAD0000 00007FF8ACD6EFFF 0029f000
01/26/2024 11:10:46,spid56,Unknown,* clbcatq 00007FF8EA9C0000 00007FF8EAA67FFF 000a8000
01/26/2024 11:10:46,spid56,Unknown,* SqlServerSpatial150 00007FF8ACE20000 00007FF8ACEC1FFF 000a2000
01/26/2024 11:10:46,spid56,Unknown,* mscoreei 00007FF8DB090000 00007FF8DB12BFFF 0009c000
01/26/2024 11:10:46,spid56,Unknown,* MSCOREE 00007FF8DB590000 00007FF8DB5F3FFF 00064000
01/26/2024 11:10:46,spid56,Unknown,* SECURITY 000001A33EDF0000 000001A33EDF2FFF 00003000
01/26/2024 11:10:46,spid56,Unknown,* schannel 00007FF8E5B20000 00007FF8E5BABFFF 0008c000
01/26/2024 11:10:46,spid56,Unknown,* kerberos 00007FF8E6140000 00007FF8E6243FFF 00104000
01/26/2024 11:10:46,spid56,Unknown,* cryptdll 00007FF8E60F0000 00007FF8E6104FFF 00015000
01/26/2024 11:10:46,spid56,Unknown,* NtlmShared 00007FF8E5FF0000 00007FF8E5FFCFFF 0000d000
01/26/2024 11:10:46,spid56,Unknown,* msv1_0 00007FF8E6000000 00007FF8E607AFFF 0007b000
01/26/2024 11:10:46,spid56,Unknown,* ncryptprov 00007FF8D9ED0000 00007FF8D9F29FFF 0005a000
01/26/2024 11:10:46,spid56,Unknown,* XmlLite 00007FF8DE260000 00007FF8DE299FFF 0003a000
01/26/2024 11:10:46,spid56,Unknown,* dbghelp 00007FF8D9F30000 00007FF8DA11CFFF 001ed000
01/26/2024 11:10:46,spid56,Unknown,* hkengine 00007FF8B17A0000 00007FF8B1E97FFF 006f8000
01/26/2024 11:10:46,spid56,Unknown,* SHLWAPI 00007FF8EAB90000 00007FF8EABE1FFF 00052000
01/26/2024 11:10:46,spid56,Unknown,* hkcompile 00007FF8B1EA0000 00007FF8B1FDFFFF 00140000
01/26/2024 11:10:46,spid56,Unknown,* hkruntime 00007FF8B2010000 00007FF8B22E2FFF 002d3000
01/26/2024 11:10:46,spid56,Unknown,* RESUTILS 00007FF8D4250000 00007FF8D42EDFFF 0009e000
01/26/2024 11:10:46,spid56,Unknown,* IPHLPAPI 00007FF8E5D90000 00007FF8E5DCCFFF 0003d000
01/26/2024 11:10:46,spid56,Unknown,* DNSAPI 00007FF8E5DE0000 00007FF8E5EA5FFF 000c6000
01/26/2024 11:10:46,spid56,Unknown,* CLUSAPI 00007FF8D4140000 00007FF8D4247FFF 00108000
01/26/2024 11:10:46,spid56,Unknown,* sqlevn70 000001958CAA0000 000001958CDDFFFF 00340000
01/26/2024 11:10:46,spid56,Unknown,* cscapi 00007FF8C0F40000 00007FF8C0F51FFF 00012000
01/26/2024 11:10:46,spid56,Unknown,* wkscli 00007FF8DF680000 00007FF8DF699FFF 0001a000
01/26/2024 11:10:46,spid56,Unknown,* gpapi 00007FF8E56E0000 00007FF8E5701FFF 00022000
01/26/2024 11:10:46,spid56,Unknown,* imagehlp 00007FF8E9D90000 00007FF8E9DACFFF 0001d000
01/26/2024 11:10:46,spid56,Unknown,* CRYPTBASE 00007FF8E6250000 00007FF8E625BFFF 0000c000
01/26/2024 11:10:46,spid56,Unknown,* rsaenh 00007FF8E5C00000 00007FF8E5C32FFF 00033000
01/26/2024 11:10:46,spid56,Unknown,* CRYPTSP 00007FF8E7030000 00007FF8E704AFFF 0001b000
01/26/2024 11:10:46,spid56,Unknown,* instapi150 00007FF8BA4B0000 00007FF8BA4C3FFF 00014000
01/26/2024 11:10:46,spid56,Unknown,* kernel.appcore 00007FF8E6C60000 00007FF8E6C70FFF 00011000
01/26/2024 11:10:46,spid56,Unknown,* psapi 00007FF8EA2A0000 00007FF8EA2A7FFF 00008000
01/26/2024 11:10:46,spid56,Unknown,* NTASN1 00007FF8E6310000 00007FF8E634BFFF 0003c000
01/26/2024 11:10:46,spid56,Unknown,* FLTLIB 00007FF8E6790000 00007FF8E6799FFF 0000a000
01/26/2024 11:10:46,spid56,Unknown,* VERSION 00007FF8E67A0000 00007FF8E67A9FFF 0000a000
01/26/2024 11:10:46,spid56,Unknown,* LOGONCLI 00007FF8E5EB0000 00007FF8E5EF0FFF 00041000
01/26/2024 11:10:46,spid56,Unknown,* SAMCLI 00007FF8E1E90000 00007FF8E1EA7FFF 00018000
01/26/2024 11:10:46,spid56,Unknown,* SSPICLI 00007FF8E67E0000 00007FF8E680EFFF 0002f000
01/26/2024 11:10:46,spid56,Unknown,* DPAPI 00007FF8E66E0000 00007FF8E66E9FFF 0000a000
01/26/2024 11:10:46,spid56,Unknown,* NETUTILS 00007FF8E5DD0000 00007FF8E5DDDFFF 0000e000
01/26/2024 11:10:46,spid56,Unknown,* ncrypt 00007FF8E6350000 00007FF8E637BFFF 0002c000
01/26/2024 11:10:46,spid56,Unknown,* cfgmgr32 00007FF8E73B0000 00007FF8E73F9FFF 0004a000
01/26/2024 11:10:46,spid56,Unknown,* WINMMBASE 00007FF8E4830000 00007FF8E485CFFF 0002d000
01/26/2024 11:10:46,spid56,Unknown,* NSI 00007FF8E7FD0000 00007FF8E7FD7FFF 00008000
01/26/2024 11:10:46,spid56,Unknown,* dhcpcsvc 00007FF8E1C80000 00007FF8E1C9BFFF 0001c000
01/26/2024 11:10:46,spid56,Unknown,* AUTHZ 00007FF8E5910000 00007FF8E595CFFF 0004d000
01/26/2024 11:10:46,spid56,Unknown,* profapi 00007FF8E6C30000 00007FF8E6C52FFF 00023000
01/26/2024 11:10:46,spid56,Unknown,* USERENV 00007FF8E67B0000 00007FF8E67D8FFF 00029000
01/26/2024 11:10:46,spid56,Unknown,* secforwarder 00007FF8BFF60000 00007FF8BFF70FFF 00011000
01/26/2024 11:10:46,spid56,Unknown,* VCRUNTIME140_1 00007FF8D5E70000 00007FF8D5E7BFFF 0000c000
01/26/2024 11:10:46,spid56,Unknown,* WINMM 00007FF8E48B0000 00007FF8E48D3FFF 00024000
01/26/2024 11:10:46,spid56,Unknown,* WINTRUST 00007FF8E6CA0000 00007FF8E6CFEFFF 0005f000
01/26/2024 11:10:46,spid56,Unknown,* ODBC32 00007FF8CDB40000 00007FF8CDBFBFFF 000bc000
01/26/2024 11:10:46,spid56,Unknown,* WINHTTP 00007FF8DFFE0000 00007FF8E00DCFFF 000fd000
01/26/2024 11:10:46,spid56,Unknown,* Secur32 00007FF8DBC10000 00007FF8DBC1BFFF 0000c000
01/26/2024 11:10:46,spid56,Unknown,* WININET 00007FF8C35B0000 00007FF8C3A91FFF 004e2000
01/26/2024 11:10:46,spid56,Unknown,* svl 00007FF8BFF80000 00007FF8BFFACFFF 0002d000
01/26/2024 11:10:46,spid56,Unknown,* VCRUNTIME140 00007FF8D60F0000 00007FF8D610AFFF 0001b000
01/26/2024 11:10:46,spid56,Unknown,* MPR 00007FF8D9340000 00007FF8D935AFFF 0001b000
01/26/2024 11:10:46,spid56,Unknown,* MSVCP140 00007FF8D6140000 00007FF8D61CCFFF 0008d000
01/26/2024 11:10:46,spid56,Unknown,* qds 00007FF8BFFB0000 00007FF8C00DCFFF 0012d000
01/26/2024 11:10:46,spid56,Unknown,* sqllang 00007FF8C0F60000 00007FF8C35A8FFF 02649000
01/26/2024 11:10:46,spid56,Unknown,* opends60 00007FF8C00E0000 00007FF8C00E8FFF 00009000
01/26/2024 11:10:46,spid56,Unknown,* WS2_32 00007FF8E8510000 00007FF8E857CFFF 0006d000
01/26/2024 11:10:46,spid56,Unknown,* sqldk 00007FF8C0100000 00007FF8C0633FFF 00534000
01/26/2024 11:10:46,spid56,Unknown,* sqlmin 00007FF8C3AA0000 00007FF8C6B1AFFF 0307b000
01/26/2024 11:10:46,spid56,Unknown,* OLEAUT32 00007FF8EA040000 00007FF8EA103FFF 000c4000
01/26/2024 11:10:46,spid56,Unknown,* sqlTsEs 00007FF8C0670000 00007FF8C0F3CFFF 008cd000
01/26/2024 11:10:46,spid56,Unknown,* SQLOS 00007FF8C6B20000 00007FF8C6B27FFF 00008000
01/26/2024 11:10:46,spid56,Unknown,* NETAPI32 00007FF8DAFD0000 00007FF8DAFE8FFF 00019000
01/26/2024 11:10:46,spid56,Unknown,* pdh 00007FF8E0760000 00007FF8E07ACFFF 0004d000
01/26/2024 11:10:46,spid56,Unknown,* win32u 00007FF8E7DF0000 00007FF8E7E0FFFF 00020000
01/26/2024 11:10:46,spid56,Unknown,* USER32 00007FF8EA360000 00007FF8EA4F6FFF 00197000
01/26/2024 11:10:46,spid56,Unknown,* msvcp_win 00007FF8E7D50000 00007FF8E7DEFFFF 000a0000
01/26/2024 11:10:46,spid56,Unknown,* gdi32full 00007FF8E7200000 00007FF8E73A9FFF 001aa000
01/26/2024 11:10:46,spid56,Unknown,* GDI32 00007FF8E9E10000 00007FF8E9E38FFF 00029000
01/26/2024 11:10:46,spid56,Unknown,* bcryptPrimitives 00007FF8E6D00000 00007FF8E6D81FFF 00082000
01/26/2024 11:10:46,spid56,Unknown,* combase 00007FF8EA5C0000 00007FF8EA8EAFFF 0032b000
01/26/2024 11:10:46,spid56,Unknown,* ole32 00007FF8E8580000 00007FF8E86D5FFF 00156000
01/26/2024 11:10:46,spid56,Unknown,* MSASN1 00007FF8E6C80000 00007FF8E6C91FFF 00012000
01/26/2024 11:10:46,spid56,Unknown,* ucrtbase 00007FF8E7050000 00007FF8E7149FFF 000fa000
01/26/2024 11:10:46,spid56,Unknown,* CRYPT32 00007FF8E7B50000 00007FF8E7D4DFFF 001fe000
01/26/2024 11:10:46,spid56,Unknown,* bcrypt 00007FF8E7E10000 00007FF8E7E35FFF 00026000
01/26/2024 11:10:46,spid56,Unknown,* RPCRT4 00007FF8EAA70000 00007FF8EAB8DFFF 0011e000
01/26/2024 11:10:46,spid56,Unknown,* sechost 00007FF8EA2B0000 00007FF8EA351FFF 000a2000
01/26/2024 11:10:46,spid56,Unknown,* msvcrt 00007FF8EA920000 00007FF8EA9BDFFF 0009e000
01/26/2024 11:10:46,spid56,Unknown,* ADVAPI32 00007FF8E8460000 00007FF8E8507FFF 000a8000
01/26/2024 11:10:46,spid56,Unknown,* InProcessClient64 00007FF8E6820000 00007FF8E6B32FFF 00313000
01/26/2024 11:10:46,spid56,Unknown,* KERNELBASE 00007FF8E6D90000 00007FF8E702CFFF 0029d000
01/26/2024 11:10:46,spid56,Unknown,* KERNEL32 00007FF8EA500000 00007FF8EA5B2FFF 000b3000
01/26/2024 11:10:46,spid56,Unknown,* ntdll 00007FF8EAC20000 00007FF8EAE0DFFF 001ee000
01/26/2024 11:10:46,spid56,Unknown,* kern3l32 000001958C060000 000001958C112FFF 000b3000
01/26/2024 11:10:46,spid56,Unknown,* ntd1l 000001958BE70000 000001958C05DFFF 001ee000
01/26/2024 11:10:46,spid56,Unknown,* sqlservr 00007FF7746C0000 00007FF77475EFFF 0009f000
01/26/2024 11:10:46,spid56,Unknown,* MODULE BASE END SIZE
01/26/2024 11:10:46,spid56,Unknown,*
01/26/2024 11:10:46,spid56,Unknown,*
01/26/2024 11:10:46,spid56,Unknown,* ME; END CLOSE db_cursor; DEALLOCATE db_cursor;
01/26/2024 11:10:46,spid56,Unknown,* EXEC (@SQL); END FETCH NEXT FROM db_cursor INTO @DATABASE_NA
01/26/2024 11:10:46,spid56,Unknown,* [' + @DATABASE_NAME + ']; EXEC sp_updatestats;'; PRINT @SQL;
01/26/2024 11:10:46,spid56,Unknown,* ABASE_NAME <> 'INNO_ADMIN' BEGIN DECLARE @SQL NVARCHAR(MAX) = N'USE
01/26/2024 11:10:46,spid56,Unknown,* or INTO @DATABASE_NAME; WHILE @@FETCH_STATUS = 0 BEGIN IF @DAT
01/26/2024 11:10:46,spid56,Unknown,* xclure les bases système OPEN db_cursor; FETCH NEXT FROM db_curs
01/26/2024 11:10:46,spid56,Unknown,* URSOR FOR SELECT name FROM sys.databases WHERE database_id > 4; -- E
01/26/2024 11:10:46,spid56,Unknown,* DECLARE @DATABASE_NAME NVARCHAR(255); DECLARE db_cursor C
01/26/2024 11:10:46,spid56,Unknown,* Input Buffer 510 bytes -
01/26/2024 11:10:46,spid56,Unknown,* Access Violation occurred reading address 0000000000000000
01/26/2024 11:10:46,spid56,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
01/26/2024 11:10:46,spid56,Unknown,* Exception Address = 00007FF8C241621E Module(sqllang+00000000014B621E)
01/26/2024 11:10:46,spid56,Unknown,*
01/26/2024 11:10:46,spid56,Unknown,*
01/26/2024 11:10:46,spid56,Unknown,* 01/26/24 11:10:46 spid 56
01/26/2024 11:10:46,spid56,Unknown,* BEGIN STACK DUMP:
01/26/2024 11:10:46,spid56,Unknown,*
01/26/2024 11:10:46,spid56,Unknown,* *******************************************************************************
01/26/2024 11:10:46,spid56,Unknown,SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
01/26/2024 11:10:46,spid56,Unknown,***Stack Dump being sent to E:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\LOG\SQLDump0027.txt
01/26/2024 11:10:46,spid56,Unknown,CImageHelper::Init () Version-specific dbghelp.dll is not used

J'ai bien sûr cherché après Error: 17310 mais je ne trouve que des fix et conversation sur des versions antérieurs.

Envoyé par SQLpro

Met aussi le type de machine

L'instruction "EXEC xp_msver donne" :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Index		Name			Internal_Value		Character_Value
-----------------------------------------------------------------------------------------------
1		ProductName		NULL			Microsoft SQL Server
2		ProductVersion		983040			15.0.4345.5
3		Language		1033			English (United States)
4		Platform		NULL			NT x64
5		Comments		NULL			SQL
6		CompanyName		NULL			Microsoft Corporation
7		FileDescription		NULL			SQL Server Windows NT - 64 Bit
8		FileVersion		NULL			2019.0150.4345.05 ((sql2019_rtm_qfe-cu24).231204-2220)
9		InternalName		NULL			SQLSERVR
10		LegalCopyright		NULL			Microsoft. All rights reserved.
11		LegalTrademarks		NULL			Microsoft SQL Server is a registered trademark of Microsoft Corporation.
12		OriginalFilename	NULL			SQLSERVR.EXE
13		PrivateBuild		NULL			NULL
14		SpecialBuild		284753925		NULL
15		WindowsVersion		284753925		6.3 (17763)
16		ProcessorCount		4			4
17		ProcessorActiveMask	NULL	               	f
18		ProcessorType		8664			NULL
19		PhysicalMemory		65535			65535 (68718452736)
20		Product ID		NULL			NULL

systeminfo :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
Host Name:                 XXXX
OS Name:                   Microsoft Windows Server 2019 Datacenter
OS Version:                10.0.17763 N/A Build 17763
OS Manufacturer:           Microsoft Corporation
OS Configuration:          Member Server
OS Build Type:             Multiprocessor Free
Registered Owner:          XXX
Registered Organization:   XXX
Product ID:                XXX
Original Install Date:     2/02/2021, 13:32:10
System Boot Time:          25/01/2024, 15:41:39
System Manufacturer:       VMware, Inc.
System Model:              VMware7,1
System Type:               x64-based PC
Processor(s):              2 Processor(s) Installed.
                           [01]: Intel64 Family 6 Model 85 Stepping 7 GenuineIntel ~2993 Mhz
                           [02]: Intel64 Family 6 Model 85 Stepping 7 GenuineIntel ~2993 Mhz
BIOS Version:              VMware, Inc. VMW71.00V.21100432.B64.2301110304, 11/01/2023
Windows Directory:         C:\Windows
System Directory:          C:\Windows\system32
Boot Device:               \Device\HarddiskVolume2
System Locale:             nl-be;Dutch (Belgium)
Input Locale:              nl-be;Dutch (Belgium)
Time Zone:                 (UTC+01:00) Brussels, Copenhagen, Madrid, Paris
Total Physical Memory:     65.535 MB
Available Physical Memory: 56.572 MB
Virtual Memory: Max Size:  75.263 MB
Virtual Memory: Available: 64.975 MB
Virtual Memory: In Use:    10.288 MB
Page File Location(s):     C:\pagefile.sys
Domain:                    XXX
Logon Server:              XXX
Hotfix(s):                 22 Hotfix(s) Installed.
                           [01]: KB5033904
                           [02]: KB4535680
                           [03]: KB4587735
                           [04]: KB4589208
                           [05]: KB4598480
                           [06]: KB4601393
                           [07]: KB5001404
                           [08]: KB5034127
                           [09]: KB5006754
                           [10]: KB5009642
                           [11]: KB5011574
                           [12]: KB5012675
                           [13]: KB5014031
                           [14]: KB5014797
                           [15]: KB5015896
                           [16]: KB5017400
                           [17]: KB5020374
                           [18]: KB5023789
                           [19]: KB5028316
                           [20]: KB5030505
                           [21]: KB5031589
                           [22]: KB5032306
Network Card(s):           1 NIC(s) Installed.
                           [01]: vmxnet3 Ethernet Adapter
                                 Connection Name: Ethernet0
                                 DHCP Enabled:    No
                                 IP address(es)
                                 [01]: XXX
Hyper-V Requirements:      A hypervisor has been detected. Features required for Hyper-V will not be displayed.

Pour le processeur : wmic cpu get caption

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
Caption
Intel64 Family 6 Model 85 Stepping 7
Intel64 Family 6 Model 85 Stepping 7

Pour la RAM : wmic memorychip get capacity

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
Capacity
17179869184
17179869184
17179869184
17179869184

Envoyé par SQLpro

et si c'est une VM :
1) les caractéristiques de la machine hôte (constructeur, type, matériel)
2) le réglage de la VM au niveau cœurs, RAM, CPU (copies exhaustive d'écrans de l'hyperviseur).

C'est effectivement une VM comme on a pu les voir dans les infos précédentes.
Nom : VM SQL1.png
Affichages : 409
Taille : 79,1 Ko

Réglage VM :
Nom : VM SQL1.png
Affichages : 407
Taille : 79,5 Ko

J'espère que c'est complet. Merci déjà pour ton aide.

**SQLpro** · 28/01/2024, 16h44

C'est pas bon ce que tu me donne.... Je veux voir les caractéristiques de la VM, pas de la machine hôte.... Nombre de CPU / cœurs (apparemment 4) au niveau de la VM SQL Server. Idem pour la RAM.

Est-ce une edition standard ou enterprise ???

Code :

Sélectionner tout - Visualiser dans une fenêtre à part