{"id":9292,"date":"2022-08-02T09:55:04","date_gmt":"2022-08-02T08:55:04","guid":{"rendered":"https:\/\/blog.capdata.fr\/?p=9292"},"modified":"2022-08-23T10:06:30","modified_gmt":"2022-08-23T09:06:30","slug":"sql-server-2022-la-compression-xml","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/","title":{"rendered":"SQL Server 2022 : La compression XML"},"content":{"rendered":"\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>

Que \u00e7a soit \u00e0 des fins applicatives ou de l’archivage, il nous arrive de plus en plus de rencontrer des colonnes XML massives dans nos bases de donn\u00e9es.<\/p>\n

Cela peut vite devenir tr\u00e8s encombrant et consommateur d’IO. Et m\u00eame si SQL Server a int\u00e9gr\u00e9 la compression des donn\u00e9es il y a un moment, les colonnes XML n’en b\u00e9n\u00e9ficiaient pas.<\/p>\n

Heureusement, avec SQL Server 2022, on peut d\u00e9sormais compresser les donn\u00e9es XML et leurs index !<\/p>\n

Dans cette d\u00e9monstration, j’utiliserai des plans d’ex\u00e9cution de SQL Server comme donn\u00e9es XML \u00e0 compresser.<\/p>\n

CREATE TABLE QPTable (\r\nid int identity(1,1),\r\nquery_plan xml) ; \r\n\r\nINSERT INTO QPTable\r\nSELECT eqp.query_plan \r\nFROM sys.dm_exec_cached_plans ecp\r\nCROSS APPLY sys.dm_exec_query_plan(ecp.plan_handle) eqp\r\n\r\nCREATE CLUSTERED INDEX PK ON QPTable (id)\r\n<\/pre>\n
Si je fais un sp_spaceused de cette table sur mon instance, je vois que j’ai 902 Mo de donn\u00e9es, ce qui est assez repr\u00e9sentatif.<\/p>\n
Ne reste qu’\u00e0 activer la compression XML pour cette table :<\/p>\n
ALTER INDEX PK_QPTable ON QPTable REBUILD with (XML_COMPRESSION= ON) <\/pre>\n
Et l\u00e0, un sp_spaceused m’informe que je n’ai plus que 258 Mo de donn\u00e9es ! Soit 29% de l’espace initial.<\/strong><\/p>\n
Il faut cependant comprendre que ce que vous gagnez en espace disque et en IO, vous le perdrez en CPU. Et bien souvent, les requ\u00eates sur des colonnes XML sont tr\u00e8s vites consommatrices de CPU. A manipuler avec pr\u00e9caution, donc, et \u00e0 maquetter avant la mise en oeuvre.<\/p>\n
 <\/p>\n
ATTENTION !<\/strong> Lors de mes tests sur la CTP 2.0 (build 16.0.600.9), la cr\u00e9ation d’un index XML sur une table avec la compression XML faisait crasher SQL Server. Nous ne pouvons pas vous indiquer l’impact disque sur les index.<\/p>\n
Le crash provoque le dump ci-dessous\u00a0 :<\/p>\n
<\/pre>\r\n2022-08-02 08:39:54.86 spid61 SqlDumpExceptionHandler: Process 61 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.\r\n2022-08-02 08:39:54.86 spid61 * *******************************************************************************\r\n2022-08-02 08:39:54.86 spid61 *\r\n2022-08-02 08:39:54.86 spid61 * BEGIN STACK DUMP:\r\n2022-08-02 08:39:54.86 spid61 * 08\/02\/22 08:39:54 spid 61\r\n2022-08-02 08:39:54.86 spid61 *\r\n2022-08-02 08:39:54.86 spid61 *\r\n2022-08-02 08:39:54.86 spid61 * Exception Address = <frame id="00" address="0x7FFB1B306BF3" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x1C6BF3" \/>\r\n2022-08-02 08:39:54.86 spid61 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION\r\n2022-08-02 08:39:54.86 spid61 * Access Violation occurred reading address FFFFFFFFFFFFFFFF\r\n2022-08-02 08:39:54.86 spid61 * Input Buffer 208 bytes -\r\n2022-08-02 08:39:54.86 spid61 * CREATE PRIMARY XML INDEX IXML_QP_Column ON QPTable (query_pla\r\n2022-08-02 08:39:54.86 spid61 * n) WITH (XML_COMPRESSION = ON)\r\n2022-08-02 08:39:54.86 spid61 *\r\n2022-08-02 08:39:54.86 spid61 *\r\n2022-08-02 08:39:54.86 spid61 * MODULE BASE END SIZE\r\n2022-08-02 08:39:54.86 spid61 * sqlservr 00007FF6EB0E0000 00007FF6EB1B2FFF 000d3000\r\n2022-08-02 08:39:54.86 spid61 * ntdll 00007FFB67DE0000 00007FFB67FE0FFF 00201000\r\n2022-08-02 08:39:54.86 spid61 * KERNEL32 00007FFB66BD0000 00007FFB66C8BFFF 000bc000\r\n2022-08-02 08:39:54.86 spid61 * KERNELBASE 00007FFB65720000 00007FFB65A82FFF 00363000\r\n2022-08-02 08:39:54.86 spid61 * CRYPT32 00007FFB65A90000 00007FFB65BEEFFF 0015f000\r\n2022-08-02 08:39:54.86 spid61 * ucrtbase 00007FFB653B0000 00007FFB654BFFFF 00110000\r\n2022-08-02 08:39:54.86 spid61 * WS2_32 00007FFB66B50000 00007FFB66BC0FFF 00071000\r\n2022-08-02 08:39:54.86 spid61 * RPCRT4 00007FFB661D0000 00007FFB662EDFFF 0011e000\r\n2022-08-02 08:39:54.86 spid61 * ADVAPI32 00007FFB66840000 00007FFB668EDFFF 000ae000\r\n2022-08-02 08:39:54.86 spid61 * msvcrt 00007FFB66A40000 00007FFB66AE2FFF 000a3000\r\n2022-08-02 08:39:54.86 spid61 * sechost 00007FFB663C0000 00007FFB6645EFFF 0009f000\r\n2022-08-02 08:39:54.86 spid61 * ole32 00007FFB67C20000 00007FFB67D54FFF 00135000\r\n2022-08-02 08:39:54.86 spid61 * msvcp_win 00007FFB65C60000 00007FFB65CFFFFF 000a0000\r\n2022-08-02 08:39:54.86 spid61 * GDI32 00007FFB67400000 00007FFB6742AFFF 0002b000\r\n2022-08-02 08:39:54.86 spid61 * win32u 00007FFB65D00000 00007FFB65D25FFF 00026000\r\n2022-08-02 08:39:54.86 spid61 * gdi32full 00007FFB654C0000 00007FFB655D0FFF 00111000\r\n2022-08-02 08:39:54.86 spid61 * USER32 00007FFB66690000 00007FFB66834FFF 001a5000\r\n2022-08-02 08:39:54.86 spid61 * combase 00007FFB66FA0000 00007FFB6730FFFF 00370000\r\n2022-08-02 08:39:54.86 spid61 * SHLWAPI 00007FFB66F40000 00007FFB66F9EFFF 0005f000\r\n2022-08-02 08:39:54.86 spid61 * OLEAUT32 00007FFB66960000 00007FFB66A36FFF 000d7000\r\n2022-08-02 08:39:54.86 spid61 * NETAPI32 00007FFB5A9C0000 00007FFB5A9D9FFF 0001a000\r\n2022-08-02 08:39:54.86 spid61 * pdh 00007FFB4E660000 00007FFB4E6AEFFF 0004f000\r\n2022-08-02 08:39:54.86 spid61 * IPHLPAPI 00007FFB64600000 00007FFB6462CFFF 0002d000\r\n2022-08-02 08:39:54.86 spid61 * SQLOS 00007FFB5B5A0000 00007FFB5B5A9FFF 0000a000\r\n2022-08-02 08:39:54.86 spid61 * sqlmin 00007FFB1B140000 00007FFB1DB37FFF 029f8000\r\n2022-08-02 08:39:54.86 spid61 * sqlTsEs 00007FFB18260000 00007FFB18A96FFF 00837000\r\n2022-08-02 08:39:54.86 spid61 * sqldk 00007FFB17CE0000 00007FFB18258FFF 00579000\r\n2022-08-02 08:39:54.86 spid61 * qds 00007FFB17B30000 00007FFB17CDFFFF 001b0000\r\n2022-08-02 08:39:54.86 spid61 * svl 00007FFB373F0000 00007FFB3741DFFF 0002e000\r\n2022-08-02 08:39:54.86 spid61 * MSVCP140 00007FFB5A0F0000 00007FFB5A17DFFF 0008e000\r\n2022-08-02 08:39:54.86 spid61 * VCRUNTIME140 00007FFB5A4E0000 00007FFB5A4FAFFF 0001b000\r\n2022-08-02 08:39:54.86 spid61 * Secur32 00007FFB5A7C0000 00007FFB5A7CBFFF 0000c000\r\n2022-08-02 08:39:54.86 spid61 * WINHTTP 00007FFB5D960000 00007FFB5DA68FFF 00109000\r\n2022-08-02 08:39:54.86 spid61 * XOLEHLP 00007FFB61140000 00007FFB61156FFF 00017000\r\n2022-08-02 08:39:54.86 spid61 * WININET 00007FFB3C2E0000 00007FFB3C7DCFFF 004fd000\r\n2022-08-02 08:39:54.86 spid61 * ODBC32 00007FFB17A70000 00007FFB17B28FFF 000b9000\r\n2022-08-02 08:39:54.86 spid61 * secforwarder 00007FFB37450000 00007FFB37461FFF 00012000\r\n2022-08-02 08:39:54.86 spid61 * VCRUNTIME140_1 00007FFB59450000 00007FFB5945BFFF 0000c000\r\n2022-08-02 08:39:54.86 spid61 * urlmon 00007FFB5A7D0000 00007FFB5A9BDFFF 001ee000\r\n2022-08-02 08:39:54.86 spid61 * WINMM 00007FFB4A4D0000 00007FFB4A4F6FFF 00027000\r\n2022-08-02 08:39:54.86 spid61 * bcrypt 00007FFB64C40000 00007FFB64C66FFF 00027000\r\n2022-08-02 08:39:54.86 spid61 * ncrypt 00007FFB64C10000 00007FFB64C37FFF 00028000\r\n2022-08-02 08:39:54.86 spid61 * iertutil 00007FFB5A1A0000 00007FFB5A451FFF 002b2000\r\n2022-08-02 08:39:54.86 spid61 * srvcli 00007FFB5A4B0000 00007FFB5A4D7FFF 00028000\r\n2022-08-02 08:39:54.86 spid61 * netutils 00007FFB64710000 00007FFB6471BFFF 0000c000\r\n2022-08-02 08:39:54.86 spid61 * DPAPI 00007FFB65040000 00007FFB65049FFF 0000a000\r\n2022-08-02 08:39:54.86 spid61 * sqllang 00007FFB18AA0000 00007FFB1B13AFFF 0269b000\r\n2022-08-02 08:39:54.86 spid61 * SSPICLI 00007FFB64D60000 00007FFB64DAAFFF 0004b000\r\n2022-08-02 08:39:54.86 spid61 * WINTRUST 00007FFB65BF0000 00007FFB65C59FFF 0006a000\r\n2022-08-02 08:39:54.86 spid61 * SHELL32 00007FFB67430000 00007FFB67B8AFFF 0075b000\r\n2022-08-02 08:39:54.86 spid61 * MSWSOCK 00007FFB648B0000 00007FFB64917FFF 00068000\r\n2022-08-02 08:39:54.86 spid61 * USERENV 00007FFB649A0000 00007FFB649CDFFF 0002e000\r\n2022-08-02 08:39:54.86 spid61 * AUTHZ 00007FFB641D0000 00007FFB6421CFFF 0004d000\r\n2022-08-02 08:39:54.86 spid61 * VERSION 00007FFB59460000 00007FFB59469FFF 0000a000\r\n2022-08-02 08:39:54.86 spid61 * webservices 00007FFB5B240000 00007FFB5B397FFF 00158000\r\n2022-08-02 08:39:54.86 spid61 * dhcpcsvc 00007FFB5EDE0000 00007FFB5EDFCFFF 0001d000\r\n2022-08-02 08:39:54.86 spid61 * SAMCLI 00007FFB60A10000 00007FFB60A28FFF 00019000\r\n2022-08-02 08:39:54.86 spid61 * LOGONCLI 00007FFB5CE20000 00007FFB5CE61FFF 00042000\r\n2022-08-02 08:39:54.86 spid61 * NTASN1 00007FFB64BD0000 00007FFB64C06FFF 00037000\r\n2022-08-02 08:39:54.86 spid61 * psapi 00007FFB67B90000 00007FFB67B97FFF 00008000\r\n2022-08-02 08:39:54.86 spid61 * bcryptPrimitives 00007FFB656A0000 00007FFB6571CFFF 0007d000\r\n2022-08-02 08:39:54.86 spid61 * MSASN1 00007FFB64DF0000 00007FFB64E01FFF 00012000\r\n2022-08-02 08:39:54.86 spid61 * kernel.appcore 00007FFB63D30000 00007FFB63D46FFF 00017000\r\n2022-08-02 08:39:54.86 spid61 * instapi160 00007FFB4DE60000 00007FFB4DE77FFF 00018000\r\n2022-08-02 08:39:54.86 spid61 * CRYPTSP 00007FFB64AF0000 00007FFB64B07FFF 00018000\r\n2022-08-02 08:39:54.86 spid61 * rsaenh 00007FFB64430000 00007FFB64464FFF 00035000\r\n2022-08-02 08:39:54.86 spid61 * CRYPTBASE 00007FFB64B10000 00007FFB64B1BFFF 0000c000\r\n2022-08-02 08:39:54.86 spid61 * imagehlp 00007FFB66310000 00007FFB6632EFFF 0001f000\r\n2022-08-02 08:39:54.86 spid61 * gpapi 00007FFB64940000 00007FFB64964FFF 00025000\r\n2022-08-02 08:39:54.87 spid61 * wkscli 00007FFB61540000 00007FFB61559FFF 0001a000\r\n2022-08-02 08:39:54.87 spid61 * cscapi 00007FFB54540000 00007FFB54551FFF 00012000\r\n2022-08-02 08:39:54.87 spid61 * sqlevn70 0000011DAEEF0000 0000011DAF273FFF 00384000\r\n2022-08-02 08:39:54.87 spid61 * CLUSAPI 00007FFB573B0000 00007FFB574BCFFF 0010d000\r\n2022-08-02 08:39:54.87 spid61 * RESUTILS 00007FFB57D10000 00007FFB57D9FFFF 00090000\r\n2022-08-02 08:39:54.87 spid61 * hkruntime 00007FFB17790000 00007FFB17A65FFF 002d6000\r\n2022-08-02 08:39:54.87 spid61 * hkcompile 00007FFB17640000 00007FFB1778BFFF 0014c000\r\n2022-08-02 08:39:54.87 spid61 * dbghelp 00007FFB56B50000 00007FFB56D61FFF 00212000\r\n2022-08-02 08:39:54.87 spid61 * hkengine 00007FFB16F30000 00007FFB17636FFF 00707000\r\n2022-08-02 08:39:54.87 spid61 * XmlLite 00007FFB61CF0000 00007FFB61D26FFF 00037000\r\n2022-08-02 08:39:54.87 spid61 * opends60 00007FFB2E3C0000 00007FFB2E3CAFFF 0000b000\r\n2022-08-02 08:39:54.87 spid61 * ncryptprov 00007FFB51690000 00007FFB516EDFFF 0005e000\r\n2022-08-02 08:39:54.87 spid61 * msv1_0 00007FFB64820000 00007FFB648AFFFF 00090000\r\n2022-08-02 08:39:54.87 spid61 * NtlmShared 00007FFB64810000 00007FFB6481DFFF 0000e000\r\n2022-08-02 08:39:54.87 spid61 * cryptdll 00007FFB64920000 00007FFB64934FFF 00015000\r\n2022-08-02 08:39:54.87 spid61 * kerberos 00007FFB649D0000 00007FFB64AEBFFF 0011c000\r\n2022-08-02 08:39:54.87 spid61 * schannel 00007FFB64330000 00007FFB643D4FFF 000a5000\r\n2022-08-02 08:39:54.87 spid61 * SECURITY 0000011F65DB0000 0000011F65DB2FFF 00003000\r\n2022-08-02 08:39:54.87 spid61 * MSCOREE 00007FFB5AE90000 00007FFB5AEF6FFF 00067000\r\n2022-08-02 08:39:54.87 spid61 * mscoreei 00007FFB59540000 00007FFB595E9FFF 000aa000\r\n2022-08-02 08:39:54.87 spid61 * SqlServerSpatial160 00007FFB16E80000 00007FFB16F25FFF 000a6000\r\n2022-08-02 08:39:54.87 spid61 * clbcatq 00007FFB664C0000 00007FFB6656EFFF 000af000\r\n2022-08-02 08:39:54.87 spid61 * msxml3 00007FFB4E3F0000 00007FFB4E65BFFF 0026c000\r\n2022-08-02 08:39:54.87 spid61 * msoledbsql 00007FFB16BF0000 00007FFB16E77FFF 00288000\r\n2022-08-02 08:39:54.87 spid61 * COMDLG32 00007FFB66E50000 00007FFB66F32FFF 000e3000\r\n2022-08-02 08:39:54.87 spid61 * shcore 00007FFB67310000 00007FFB673F9FFF 000ea000\r\n2022-08-02 08:39:54.87 spid61 * COMCTL32 00007FFB57090000 00007FFB57141FFF 000b2000\r\n2022-08-02 08:39:54.87 spid61 * MSOLEDBSQLR 0000011F65FE0000 0000011F66001FFF 00022000\r\n2022-08-02 08:39:54.87 spid61 * NSI 00007FFB65D30000 00007FFB65D38FFF 00009000\r\n2022-08-02 08:39:54.87 spid61 * dhcpcsvc6 00007FFB5F0D0000 00007FFB5F0E8FFF 00019000\r\n2022-08-02 08:39:54.87 spid61 * BatchParser 00007FFB16630000 00007FFB1665BFFF 0002c000\r\n2022-08-02 08:39:54.87 spid61 * DNSAPI 00007FFB64630000 00007FFB6470DFFF 000de000\r\n2022-08-02 08:39:54.87 spid61 * sqlncli11 00007FFB16890000 00007FFB16BE2FFF 00353000\r\n2022-08-02 08:39:54.87 spid61 * MSVCR100 00000000639E0000 0000000063AB1FFF 000d2000\r\n2022-08-02 08:39:54.87 spid61 * SQLNCLIR11 0000011F66050000 0000011F66087FFF 00038000\r\n2022-08-02 08:39:54.87 spid61 * netbios 00007FFB4A490000 00007FFB4A49BFFF 0000c000\r\n2022-08-02 08:39:54.87 spid61 * sqlnclirda11 0000000063680000 00000000639D8FFF 00359000\r\n2022-08-02 08:39:54.87 spid61 * SQLNCLIRDAR11 0000011F669E0000 0000011F66A17FFF 00038000\r\n2022-08-02 08:39:54.87 spid61 * clr 00007FFB58000000 00007FFB58B34FFF 00b35000\r\n2022-08-02 08:39:54.87 spid61 * VCRUNTIME140_CLR0400 00007FFB58CB0000 00007FFB58CC5FFF 00016000\r\n2022-08-02 08:39:54.87 spid61 * ucrtbase_clr0400 00007FFB57DA0000 00007FFB57E5CFFF 000bd000\r\n2022-08-02 08:39:54.87 spid61 * profapi 00007FFB652E0000 00007FFB65300FFF 00021000\r\n2022-08-02 08:39:54.87 spid61 * mskeyprotect 00007FFB56B30000 00007FFB56B44FFF 00015000\r\n2022-08-02 08:39:54.87 spid61 * ntmarta 00007FFB638B0000 00007FFB638E3FFF 00034000\r\n2022-08-02 08:39:54.87 spid61 * mscorlib.ni 00007FFB54A70000 00007FFB5606FFFF 01600000\r\n2022-08-02 08:39:54.87 spid61 * SqlAccess 00007FFB16820000 00007FFB16889FFF 0006a000\r\n2022-08-02 08:39:54.87 spid61 * clrjit 00007FFB53FC0000 00007FFB5410EFFF 0014f000\r\n2022-08-02 08:39:54.87 spid61 * windows.storage 00007FFB574C0000 00007FFB57D06FFF 00847000\r\n2022-08-02 08:39:54.87 spid61 * ntdsapi 00007FFB5B420000 00007FFB5B449FFF 0002a000\r\n2022-08-02 08:39:54.87 spid61 * DSPARSE 00007FFB5B3F0000 00007FFB5B3FBFFF 0000c000\r\n2022-08-02 08:39:54.87 spid61 * ncryptsslp 00007FFB516F0000 00007FFB51715FFF 00026000\r\n2022-08-02 08:39:54.87 spid61 * xpsqlbot 00007FFB2BB90000 00007FFB2BB9AFFF 0000b000\r\n2022-08-02 08:39:54.87 spid61 * xpstar 00007FFB16750000 00007FFB167C9FFF 0007a000\r\n2022-08-02 08:39:54.87 spid61 * SQLSCM 00007FFB167D0000 00007FFB167E8FFF 00019000\r\n2022-08-02 08:39:54.87 spid61 * xpstar 000001202B500000 000001202B50CFFF 0000d000\r\n2022-08-02 08:39:54.87 spid61 * SharedMemory 00007FFB38F30000 00007FFB38F40FFF 00011000\r\n2022-08-02 08:39:54.87 spid61 *\r\n2022-08-02 08:39:54.87 spid61 * P1Home: 007400610044005B:\r\n2022-08-02 08:39:54.87 spid61 * P2Home: 006C006F00430061:\r\n2022-08-02 08:39:54.87 spid61 * P3Home: 0000000000000000:\r\n2022-08-02 08:39:54.87 spid61 * P4Home: 005D006E006F0069:\r\n2022-08-02 08:39:54.87 spid61 * P5Home: 00790073005B002E:\r\n2022-08-02 08:39:54.87 spid61 * P6Home: 0069007400750073:\r\n2022-08-02 08:39:54.87 spid61 * ContextFlags: 000000000010005F:\r\n2022-08-02 08:39:54.87 spid61 * MxCsr: 0000000000001FA8:\r\n2022-08-02 08:39:54.87 spid61 * SegCs: 0000000000000033:\r\n2022-08-02 08:39:54.87 spid61 * SegDs: 000000000000002B:\r\n2022-08-02 08:39:54.87 spid61 * SegEs: 000000000000002B:\r\n2022-08-02 08:39:54.87 spid61 * SegFs: 0000000000000053:\r\n2022-08-02 08:39:54.87 spid61 * SegGs: 000000000000002B:\r\n2022-08-02 08:39:54.87 spid61 * SegSs: 000000000000002B:\r\n2022-08-02 08:39:54.87 spid61 * EFlags: 0000000000010202:\r\n2022-08-02 08:39:54.87 spid61 * Rax: 0000000000000000:\r\n2022-08-02 08:39:54.87 spid61 * Rcx: 0069007400630065:\r\n2022-08-02 08:39:54.87 spid61 * Rdx: 0000011E4DA989F7: 6900740063006500 2E005D006E006F00 7300790073005B00 6C00690074007500 5F00790074006900 5F00700063007500\r\n2022-08-02 08:39:54.87 spid61 * Rbx: 0000000000000000:\r\n2022-08-02 08:39:54.87 spid61 * Rsp: 00000010156DE5F0: 0000000000000000 00000010156DE710 00000010156E57C0 00000010156E57C0 00000010156DE730 0073006500740079\r\n2022-08-02 08:39:54.87 spid61 * Rbp: 00000010156DE710: 4E0055004F004309 490042005F005400 50F847F8F5004700 005B101140F64CF8 00610074006105A5 006C006C006F0043\r\n2022-08-02 08:39:54.87 spid61 * Rsi: 00000010156E57C0: 000000060000000C 00000010156E53B0 B7D66B2D00000000 00000010156E57E4 11C00C0000001F9E 0E00010140148F03\r\n2022-08-02 08:39:54.87 spid61 * Rdi: 00000000000000C4:\r\n2022-08-02 08:39:54.87 spid61 * R8: 0000000000000001:\r\n2022-08-02 08:39:54.87 spid61 * R9: 0000000000000020:\r\n2022-08-02 08:39:54.87 spid61 * R10: 00007FFB1B140000: 0000000300905A4D 0000FFFF00000004 00000000000000B8 0000000000000040 0000000000000000 0000000000000000\r\n2022-08-02 08:39:54.87 spid61 * R11: 00007FFB1B1455A4: C5E0016C7F7EA1C4 90C377F8C5007FFE 9090909090909090 74894808245C8948 4920EC8348571024 FA8B48F08B49D98B\r\n2022-08-02 08:39:54.87 spid61 * R12: 0000011E4D68C4E0: 00007FFB1A5445B0 000000000000A157 000000000000A21B 0000011E4DA74DC0 0000000100000001 0000011E4D68C220\r\n2022-08-02 08:39:54.87 spid61 * R13: 0000011E4D689380: 00000008FFFFFFF8 0000000000000000 000000000000FFFF 0000011E4D58BFC8 0000000000000007 00000000000000C8\r\n2022-08-02 08:39:54.87 spid61 * R14: 00000000000000C4:\r\n2022-08-02 08:39:54.87 spid61 * R15: 00000010156DE640: 004E0055004F0043 00490042005F0054 0044005B00280047 0043006100740061 0065006C006C006F 006F006900740063\r\n2022-08-02 08:39:54.87 spid61 * Rip: 00007FFB1B306BF3: 01EB10658B441988 047E8BF7B70F44CC 08468B4806E7C148 104E8BFB18386480 870F204E3BCE0341 08468B48016A27B2\r\n2022-08-02 08:39:54.87 spid61 * *******************************************************************************\r\n2022-08-02 08:39:54.87 spid61 * -------------------------------------------------------------------------------\r\n2022-08-02 08:39:54.87 spid61 * Short Stack Dump\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB1B306BF3" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x1C6BF3" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB1B2EF7E9" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x1AF7E9" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB1B2EFE49" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x1AFE49" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB1B2EFB77" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x1AFB77" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB1C9C2A17" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x1882A17" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB1BB6897B" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0xA2897B" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18262D17" pdb="SqlTsEs.pdb" age="2" guid="DCAFF09E-F15D-4D3F-B35A-90D3943CAA6F" module="SqlTsEs" rva="0x2D17" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB1BBABAA2" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0xA6BAA2" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB1BBAAF48" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0xA6AF48" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB1B168FB5" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x28FB5" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB1B18539E" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x4539E" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18ABE128" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x1E128" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AD95E8" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x395E8" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AD8FB4" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x38FB4" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AB7974" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x17974" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AB81AA" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x181AA" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AB8CC9" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x18CC9" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AB760D" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x1760D" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18DC4F42" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x324F42" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB19BBEC57" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x111EC57" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB19BBE999" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x111E999" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB19BB9B8C" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x1119B8C" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB19262123" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x7C2123" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB19BBC946" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x111C946" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB19BBAF4D" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x111AF4D" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB19BBAA4C" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x111AA4C" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB19BC2D45" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x1122D45" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18D264FE" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x2864FE" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AB7974" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x17974" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AB81AA" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x181AA" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AB8CC9" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x18CC9" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AB760D" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x1760D" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AC27CC" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x227CC" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AB52E9" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x152E9" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB18AB5087" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x15087" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB17CE8BD9" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x8BD9" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB17CE88E6" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x88E6" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB17CE8451" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x8451" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB17D18A0F" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x38A0F" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB17D18D50" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x38D50" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB17D18B89" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x38B89" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB17D196DA" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x396DA" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB66BE4ED0" pdb="kernel32.pdb" age="1" guid="E3D30A17-E8D7-33F7-6AEC-D5F901AD9EFC" module="kernel32" rva="0x14ED0" \/>\r\n2022-08-02 08:39:54.87 spid61 <frame id="00" address="0x7FFB67E5E39B" pdb="ntdll.pdb" age="1" guid="7BC38B16-EB40-D8C0-1526-21EE552A7823" module="ntdll" rva="0x7E39B" \/>\r\n2022-08-02 08:39:54.87 spid61 Stack Signature for the dump is 0x00000000CA5A19BE\r\n2022-08-02 08:39:54.87 spid61 CDmpClient::ExecuteAllCallbacks started.\r\n2022-08-02 08:39:54.87 spid61 XE_DumpCallbacks is executing...\r\n2022-08-02 08:39:54.90 spid61 DumpCallbackSOS is executing...\r\n2022-08-02 08:39:54.90 spid61 DumpCallbackEE is executing...\r\n2022-08-02 08:39:54.92 spid61 DumpCallbackSE is executing...\r\n2022-08-02 08:39:54.99 spid61 DumpCallbackSEAM is executing...\r\n2022-08-02 08:39:55.00 spid61 DumpCallbackSSB is executing...\r\n2022-08-02 08:39:55.04 spid61 DumpCallbackQE is executing...\r\n2022-08-02 08:39:55.05 spid61 DumpCallbackFullText is executing...\r\n2022-08-02 08:39:55.05 spid61 DumpCallbackSQLCLR is executing...\r\n2022-08-02 08:39:55.05 spid61 DumpCallbackHk is executing...\r\n2022-08-02 08:39:55.07 spid61 DumpCallbackRepl is executing...\r\n2022-08-02 08:39:55.07 spid61 DumpCallbackPolyBase is executing...\r\n2022-08-02 08:39:55.07 spid61 CDmpClient::ExecuteAllCallbacks completed. Time elapsed: 0 seconds.\r\n2022-08-02 08:39:55.72 spid61 External dump process return code 0x20000001.\r\nExternal dump process returned no errors.\r\n\r\n2022-08-02 08:39:55.72 spid61 CRT abort() function called. The process will be terminated\r\n2022-08-02 08:39:55.72 spid61 ex_terminator: Possible termination due to exception during stack unwinding.\r\n2022-08-02 08:39:55.72 spid61 CImageHelper::Init () Version-specific dbghelp.dll is not used\r\n2022-08-02 08:39:55.73 spid61 **Dump thread - spid = 61, EC = 0x0000011E4D5C71E0 Connection = 0x0000011E4D5C6890\r\n2022-08-02 08:39:55.89 spid61 ***Stack Dump being sent to C:\\Program Files\\Microsoft SQL Server\\MSSQL16.MSSQLSERVER\\MSSQL\\LOG\\SQLDump0006.txt\r\n2022-08-02 08:39:55.89 spid61 * *******************************************************************************\r\n2022-08-02 08:39:55.89 spid61 *\r\n2022-08-02 08:39:55.89 spid61 * BEGIN STACK DUMP:\r\n2022-08-02 08:39:55.89 spid61 * 08\/02\/22 08:39:55 spid 61\r\n2022-08-02 08:39:55.89 spid61 *\r\n2022-08-02 08:39:55.89 spid61 * ex_terminator - Last chance exception handling\r\n2022-08-02 08:39:55.89 spid61 *\r\n2022-08-02 08:39:55.89 spid61 * Input Buffer 208 bytes -\r\n2022-08-02 08:39:55.89 spid61 * CREATE PRIMARY XML INDEX IXML_QP_Column ON QPTable (query_pla\r\n2022-08-02 08:39:55.89 spid61 * n) WITH (XML_COMPRESSION = ON)\r\n2022-08-02 08:39:55.89 spid61 *\r\n2022-08-02 08:39:55.89 spid61 *\r\n2022-08-02 08:39:55.89 spid61 * MODULE BASE END SIZE\r\n2022-08-02 08:39:55.89 spid61 * sqlservr 00007FF6EB0E0000 00007FF6EB1B2FFF 000d3000\r\n2022-08-02 08:39:55.89 spid61 * ntdll 00007FFB67DE0000 00007FFB67FE0FFF 00201000\r\n2022-08-02 08:39:55.89 spid61 * KERNEL32 00007FFB66BD0000 00007FFB66C8BFFF 000bc000\r\n2022-08-02 08:39:55.89 spid61 * KERNELBASE 00007FFB65720000 00007FFB65A82FFF 00363000\r\n2022-08-02 08:39:55.89 spid61 * CRYPT32 00007FFB65A90000 00007FFB65BEEFFF 0015f000\r\n2022-08-02 08:39:55.89 spid61 * ucrtbase 00007FFB653B0000 00007FFB654BFFFF 00110000\r\n2022-08-02 08:39:55.89 spid61 * WS2_32 00007FFB66B50000 00007FFB66BC0FFF 00071000\r\n2022-08-02 08:39:55.89 spid61 * RPCRT4 00007FFB661D0000 00007FFB662EDFFF 0011e000\r\n2022-08-02 08:39:55.90 spid61 * ADVAPI32 00007FFB66840000 00007FFB668EDFFF 000ae000\r\n2022-08-02 08:39:55.90 spid61 * msvcrt 00007FFB66A40000 00007FFB66AE2FFF 000a3000\r\n2022-08-02 08:39:55.90 spid61 * sechost 00007FFB663C0000 00007FFB6645EFFF 0009f000\r\n2022-08-02 08:39:55.90 spid61 * ole32 00007FFB67C20000 00007FFB67D54FFF 00135000\r\n2022-08-02 08:39:55.90 spid61 * msvcp_win 00007FFB65C60000 00007FFB65CFFFFF 000a0000\r\n2022-08-02 08:39:55.90 spid61 * GDI32 00007FFB67400000 00007FFB6742AFFF 0002b000\r\n2022-08-02 08:39:55.90 spid61 * win32u 00007FFB65D00000 00007FFB65D25FFF 00026000\r\n2022-08-02 08:39:55.90 spid61 * gdi32full 00007FFB654C0000 00007FFB655D0FFF 00111000\r\n2022-08-02 08:39:55.90 spid61 * USER32 00007FFB66690000 00007FFB66834FFF 001a5000\r\n2022-08-02 08:39:55.90 spid61 * combase 00007FFB66FA0000 00007FFB6730FFFF 00370000\r\n2022-08-02 08:39:55.90 spid61 * SHLWAPI 00007FFB66F40000 00007FFB66F9EFFF 0005f000\r\n2022-08-02 08:39:55.90 spid61 * OLEAUT32 00007FFB66960000 00007FFB66A36FFF 000d7000\r\n2022-08-02 08:39:55.90 spid61 * NETAPI32 00007FFB5A9C0000 00007FFB5A9D9FFF 0001a000\r\n2022-08-02 08:39:55.90 spid61 * pdh 00007FFB4E660000 00007FFB4E6AEFFF 0004f000\r\n2022-08-02 08:39:55.90 spid61 * IPHLPAPI 00007FFB64600000 00007FFB6462CFFF 0002d000\r\n2022-08-02 08:39:55.90 spid61 * SQLOS 00007FFB5B5A0000 00007FFB5B5A9FFF 0000a000\r\n2022-08-02 08:39:55.90 spid61 * sqlmin 00007FFB1B140000 00007FFB1DB37FFF 029f8000\r\n2022-08-02 08:39:55.90 spid61 * sqlTsEs 00007FFB18260000 00007FFB18A96FFF 00837000\r\n2022-08-02 08:39:55.90 spid61 * sqldk 00007FFB17CE0000 00007FFB18258FFF 00579000\r\n2022-08-02 08:39:55.90 spid61 * qds 00007FFB17B30000 00007FFB17CDFFFF 001b0000\r\n2022-08-02 08:39:55.90 spid61 * svl 00007FFB373F0000 00007FFB3741DFFF 0002e000\r\n2022-08-02 08:39:55.90 spid61 * MSVCP140 00007FFB5A0F0000 00007FFB5A17DFFF 0008e000\r\n2022-08-02 08:39:55.90 spid61 * VCRUNTIME140 00007FFB5A4E0000 00007FFB5A4FAFFF 0001b000\r\n2022-08-02 08:39:55.90 spid61 * Secur32 00007FFB5A7C0000 00007FFB5A7CBFFF 0000c000\r\n2022-08-02 08:39:55.90 spid61 * WINHTTP 00007FFB5D960000 00007FFB5DA68FFF 00109000\r\n2022-08-02 08:39:55.90 spid61 * XOLEHLP 00007FFB61140000 00007FFB61156FFF 00017000\r\n2022-08-02 08:39:55.90 spid61 * WININET 00007FFB3C2E0000 00007FFB3C7DCFFF 004fd000\r\n2022-08-02 08:39:55.90 spid61 * ODBC32 00007FFB17A70000 00007FFB17B28FFF 000b9000\r\n2022-08-02 08:39:55.90 spid61 * secforwarder 00007FFB37450000 00007FFB37461FFF 00012000\r\n2022-08-02 08:39:55.90 spid61 * VCRUNTIME140_1 00007FFB59450000 00007FFB5945BFFF 0000c000\r\n2022-08-02 08:39:55.90 spid61 * urlmon 00007FFB5A7D0000 00007FFB5A9BDFFF 001ee000\r\n2022-08-02 08:39:55.90 spid61 * WINMM 00007FFB4A4D0000 00007FFB4A4F6FFF 00027000\r\n2022-08-02 08:39:55.90 spid61 * bcrypt 00007FFB64C40000 00007FFB64C66FFF 00027000\r\n2022-08-02 08:39:55.90 spid61 * ncrypt 00007FFB64C10000 00007FFB64C37FFF 00028000\r\n2022-08-02 08:39:55.90 spid61 * iertutil 00007FFB5A1A0000 00007FFB5A451FFF 002b2000\r\n2022-08-02 08:39:55.90 spid61 * srvcli 00007FFB5A4B0000 00007FFB5A4D7FFF 00028000\r\n2022-08-02 08:39:55.90 spid61 * netutils 00007FFB64710000 00007FFB6471BFFF 0000c000\r\n2022-08-02 08:39:55.90 spid61 * DPAPI 00007FFB65040000 00007FFB65049FFF 0000a000\r\n2022-08-02 08:39:55.90 spid61 * sqllang 00007FFB18AA0000 00007FFB1B13AFFF 0269b000\r\n2022-08-02 08:39:55.90 spid61 * SSPICLI 00007FFB64D60000 00007FFB64DAAFFF 0004b000\r\n2022-08-02 08:39:55.90 spid61 * WINTRUST 00007FFB65BF0000 00007FFB65C59FFF 0006a000\r\n2022-08-02 08:39:55.90 spid61 * SHELL32 00007FFB67430000 00007FFB67B8AFFF 0075b000\r\n2022-08-02 08:39:55.90 spid61 * MSWSOCK 00007FFB648B0000 00007FFB64917FFF 00068000\r\n2022-08-02 08:39:55.90 spid61 * USERENV 00007FFB649A0000 00007FFB649CDFFF 0002e000\r\n2022-08-02 08:39:55.90 spid61 * AUTHZ 00007FFB641D0000 00007FFB6421CFFF 0004d000\r\n2022-08-02 08:39:55.90 spid61 * VERSION 00007FFB59460000 00007FFB59469FFF 0000a000\r\n2022-08-02 08:39:55.90 spid61 * webservices 00007FFB5B240000 00007FFB5B397FFF 00158000\r\n2022-08-02 08:39:55.90 spid61 * dhcpcsvc 00007FFB5EDE0000 00007FFB5EDFCFFF 0001d000\r\n2022-08-02 08:39:55.90 spid61 * SAMCLI 00007FFB60A10000 00007FFB60A28FFF 00019000\r\n2022-08-02 08:39:55.90 spid61 * LOGONCLI 00007FFB5CE20000 00007FFB5CE61FFF 00042000\r\n2022-08-02 08:39:55.90 spid61 * NTASN1 00007FFB64BD0000 00007FFB64C06FFF 00037000\r\n2022-08-02 08:39:55.90 spid61 * psapi 00007FFB67B90000 00007FFB67B97FFF 00008000\r\n2022-08-02 08:39:55.90 spid61 * bcryptPrimitives 00007FFB656A0000 00007FFB6571CFFF 0007d000\r\n2022-08-02 08:39:55.90 spid61 * MSASN1 00007FFB64DF0000 00007FFB64E01FFF 00012000\r\n2022-08-02 08:39:55.90 spid61 * kernel.appcore 00007FFB63D30000 00007FFB63D46FFF 00017000\r\n2022-08-02 08:39:55.90 spid61 * instapi160 00007FFB4DE60000 00007FFB4DE77FFF 00018000\r\n2022-08-02 08:39:55.90 spid61 * CRYPTSP 00007FFB64AF0000 00007FFB64B07FFF 00018000\r\n2022-08-02 08:39:55.90 spid61 * rsaenh 00007FFB64430000 00007FFB64464FFF 00035000\r\n2022-08-02 08:39:55.90 spid61 * CRYPTBASE 00007FFB64B10000 00007FFB64B1BFFF 0000c000\r\n2022-08-02 08:39:55.90 spid61 * imagehlp 00007FFB66310000 00007FFB6632EFFF 0001f000\r\n2022-08-02 08:39:55.90 spid61 * gpapi 00007FFB64940000 00007FFB64964FFF 00025000\r\n2022-08-02 08:39:55.90 spid61 * wkscli 00007FFB61540000 00007FFB61559FFF 0001a000\r\n2022-08-02 08:39:55.90 spid61 * cscapi 00007FFB54540000 00007FFB54551FFF 00012000\r\n2022-08-02 08:39:55.90 spid61 * sqlevn70 0000011DAEEF0000 0000011DAF273FFF 00384000\r\n2022-08-02 08:39:55.90 spid61 * CLUSAPI 00007FFB573B0000 00007FFB574BCFFF 0010d000\r\n2022-08-02 08:39:55.90 spid61 * RESUTILS 00007FFB57D10000 00007FFB57D9FFFF 00090000\r\n2022-08-02 08:39:55.90 spid61 * hkruntime 00007FFB17790000 00007FFB17A65FFF 002d6000\r\n2022-08-02 08:39:55.90 spid61 * hkcompile 00007FFB17640000 00007FFB1778BFFF 0014c000\r\n2022-08-02 08:39:55.90 spid61 * dbghelp 00007FFB56B50000 00007FFB56D61FFF 00212000\r\n2022-08-02 08:39:55.90 spid61 * hkengine 00007FFB16F30000 00007FFB17636FFF 00707000\r\n2022-08-02 08:39:55.90 spid61 * XmlLite 00007FFB61CF0000 00007FFB61D26FFF 00037000\r\n2022-08-02 08:39:55.90 spid61 * opends60 00007FFB2E3C0000 00007FFB2E3CAFFF 0000b000\r\n2022-08-02 08:39:55.90 spid61 * ncryptprov 00007FFB51690000 00007FFB516EDFFF 0005e000\r\n2022-08-02 08:39:55.90 spid61 * msv1_0 00007FFB64820000 00007FFB648AFFFF 00090000\r\n2022-08-02 08:39:55.90 spid61 * NtlmShared 00007FFB64810000 00007FFB6481DFFF 0000e000\r\n2022-08-02 08:39:55.90 spid61 * cryptdll 00007FFB64920000 00007FFB64934FFF 00015000\r\n2022-08-02 08:39:55.90 spid61 * kerberos 00007FFB649D0000 00007FFB64AEBFFF 0011c000\r\n2022-08-02 08:39:55.90 spid61 * schannel 00007FFB64330000 00007FFB643D4FFF 000a5000\r\n2022-08-02 08:39:55.90 spid61 * SECURITY 0000011F65DB0000 0000011F65DB2FFF 00003000\r\n2022-08-02 08:39:55.90 spid61 * MSCOREE 00007FFB5AE90000 00007FFB5AEF6FFF 00067000\r\n2022-08-02 08:39:55.90 spid61 * mscoreei 00007FFB59540000 00007FFB595E9FFF 000aa000\r\n2022-08-02 08:39:55.90 spid61 * SqlServerSpatial160 00007FFB16E80000 00007FFB16F25FFF 000a6000\r\n2022-08-02 08:39:55.90 spid61 * clbcatq 00007FFB664C0000 00007FFB6656EFFF 000af000\r\n2022-08-02 08:39:55.90 spid61 * msxml3 00007FFB4E3F0000 00007FFB4E65BFFF 0026c000\r\n2022-08-02 08:39:55.90 spid61 * msoledbsql 00007FFB16BF0000 00007FFB16E77FFF 00288000\r\n2022-08-02 08:39:55.90 spid61 * COMDLG32 00007FFB66E50000 00007FFB66F32FFF 000e3000\r\n2022-08-02 08:39:55.90 spid61 * shcore 00007FFB67310000 00007FFB673F9FFF 000ea000\r\n2022-08-02 08:39:55.90 spid61 * COMCTL32 00007FFB57090000 00007FFB57141FFF 000b2000\r\n2022-08-02 08:39:55.90 spid61 * MSOLEDBSQLR 0000011F65FE0000 0000011F66001FFF 00022000\r\n2022-08-02 08:39:55.90 spid61 * NSI 00007FFB65D30000 00007FFB65D38FFF 00009000\r\n2022-08-02 08:39:55.90 spid61 * dhcpcsvc6 00007FFB5F0D0000 00007FFB5F0E8FFF 00019000\r\n2022-08-02 08:39:55.90 spid61 * BatchParser 00007FFB16630000 00007FFB1665BFFF 0002c000\r\n2022-08-02 08:39:55.90 spid61 * DNSAPI 00007FFB64630000 00007FFB6470DFFF 000de000\r\n2022-08-02 08:39:55.90 spid61 * sqlncli11 00007FFB16890000 00007FFB16BE2FFF 00353000\r\n2022-08-02 08:39:55.90 spid61 * MSVCR100 00000000639E0000 0000000063AB1FFF 000d2000\r\n2022-08-02 08:39:55.90 spid61 * SQLNCLIR11 0000011F66050000 0000011F66087FFF 00038000\r\n2022-08-02 08:39:55.90 spid61 * netbios 00007FFB4A490000 00007FFB4A49BFFF 0000c000\r\n2022-08-02 08:39:55.90 spid61 * sqlnclirda11 0000000063680000 00000000639D8FFF 00359000\r\n2022-08-02 08:39:55.90 spid61 * SQLNCLIRDAR11 0000011F669E0000 0000011F66A17FFF 00038000\r\n2022-08-02 08:39:55.90 spid61 * clr 00007FFB58000000 00007FFB58B34FFF 00b35000\r\n2022-08-02 08:39:55.90 spid61 * VCRUNTIME140_CLR0400 00007FFB58CB0000 00007FFB58CC5FFF 00016000\r\n2022-08-02 08:39:55.90 spid61 * ucrtbase_clr0400 00007FFB57DA0000 00007FFB57E5CFFF 000bd000\r\n2022-08-02 08:39:55.90 spid61 * profapi 00007FFB652E0000 00007FFB65300FFF 00021000\r\n2022-08-02 08:39:55.90 spid61 * mskeyprotect 00007FFB56B30000 00007FFB56B44FFF 00015000\r\n2022-08-02 08:39:55.90 spid61 * ntmarta 00007FFB638B0000 00007FFB638E3FFF 00034000\r\n2022-08-02 08:39:55.90 spid61 * mscorlib.ni 00007FFB54A70000 00007FFB5606FFFF 01600000\r\n2022-08-02 08:39:55.90 spid61 * SqlAccess 00007FFB16820000 00007FFB16889FFF 0006a000\r\n2022-08-02 08:39:55.90 spid61 * clrjit 00007FFB53FC0000 00007FFB5410EFFF 0014f000\r\n2022-08-02 08:39:55.90 spid61 * windows.storage 00007FFB574C0000 00007FFB57D06FFF 00847000\r\n2022-08-02 08:39:55.90 spid61 * ntdsapi 00007FFB5B420000 00007FFB5B449FFF 0002a000\r\n2022-08-02 08:39:55.90 spid61 * DSPARSE 00007FFB5B3F0000 00007FFB5B3FBFFF 0000c000\r\n2022-08-02 08:39:55.90 spid61 * ncryptsslp 00007FFB516F0000 00007FFB51715FFF 00026000\r\n2022-08-02 08:39:55.90 spid61 * xpsqlbot 00007FFB2BB90000 00007FFB2BB9AFFF 0000b000\r\n2022-08-02 08:39:55.90 spid61 * xpstar 00007FFB16750000 00007FFB167C9FFF 0007a000\r\n2022-08-02 08:39:55.90 spid61 * SQLSCM 00007FFB167D0000 00007FFB167E8FFF 00019000\r\n2022-08-02 08:39:55.90 spid61 * xpstar 000001202B500000 000001202B50CFFF 0000d000\r\n2022-08-02 08:39:55.90 spid61 * SharedMemory 00007FFB38F30000 00007FFB38F40FFF 00011000\r\n2022-08-02 08:39:55.90 spid61 *\r\n2022-08-02 08:39:55.90 spid61 * P1Home: 0000000000000000:\r\n2022-08-02 08:39:55.90 spid61 * P2Home: 0000000000000000:\r\n2022-08-02 08:39:55.90 spid61 * P3Home: 0000000000008000:\r\n2022-08-02 08:39:55.90 spid61 * P4Home: 00007FFB00000000:\r\n2022-08-02 08:39:55.90 spid61 * P5Home: 0000000000000030:\r\n2022-08-02 08:39:55.90 spid61 * P6Home: 00000000000000F8:\r\n2022-08-02 08:39:55.90 spid61 * ContextFlags: 000000000010004F:\r\n2022-08-02 08:39:55.90 spid61 * MxCsr: 0000000000001FA8:\r\n2022-08-02 08:39:55.90 spid61 * SegCs: 0000000000000033:\r\n2022-08-02 08:39:55.90 spid61 * SegDs: 000000000000002B:\r\n2022-08-02 08:39:55.90 spid61 * SegEs: 000000000000002B:\r\n2022-08-02 08:39:55.90 spid61 * SegFs: 0000000000000053:\r\n2022-08-02 08:39:55.90 spid61 * SegGs: 000000000000002B:\r\n2022-08-02 08:39:55.90 spid61 * SegSs: 000000000000002B:\r\n2022-08-02 08:39:55.90 spid61 * EFlags: 0000000000000206:\r\n2022-08-02 08:39:55.90 spid61 * Rax: 0000000000000013:\r\n2022-08-02 08:39:55.90 spid61 * Rcx: 0000000000000000:\r\n2022-08-02 08:39:55.90 spid61 * Rdx: 0000000000000101:\r\n2022-08-02 08:39:55.90 spid61 * Rbx: 0000000000000000:\r\n2022-08-02 08:39:55.90 spid61 * Rsp: 00000010156D8AE0: 00000010156D8AF0 0000000000000000 0000000000000000 0000000000000000 00000080000042AC 0000000000000000\r\n2022-08-02 08:39:55.90 spid61 * Rbp: 00007FFB17EF26C0: 0074005F00780065 0069006D00720065 006F00740061006E 0020002D00200072 007400730061004C 0061006800630020\r\n2022-08-02 08:39:55.90 spid61 * Rsi: 0000000000000000:\r\n2022-08-02 08:39:55.90 spid61 * Rdi: 0000011E4D5C6890: 0000011E4D5C0040 0000011E4D5C0840 0000011E4D5C6110 0000011E4D5C7140 0000011E4D5C6900 0000011E4BA42780\r\n2022-08-02 08:39:55.90 spid61 * R8: 0000011F00000000:\r\n2022-08-02 08:39:55.90 spid61 * R9: 0032000000001000:\r\n2022-08-02 08:39:55.90 spid61 * R10: 0038003400330030:\r\n2022-08-02 08:39:55.90 spid61 * R11: 0000000000000000:\r\n2022-08-02 08:39:55.90 spid61 * R12: 0000000000000000:\r\n2022-08-02 08:39:55.90 spid61 * R13: 000000000000002F:\r\n2022-08-02 08:39:55.90 spid61 * R14: 0000011E4D5C71E0: 0000011E4D5C71E0 0000011E4D5C6890 0000000000000000 0000000000000000 0000000000000000 0000000000000006\r\n2022-08-02 08:39:55.90 spid61 * R15: 00007FFB17EF26C0: 0074005F00780065 0069006D00720065 006F00740061006E 0020002D00200072 007400730061004C 0061006800630020\r\n2022-08-02 08:39:55.90 spid61 * Rip: 00007FFB657401DC: 8C8B480000441F0F CC3348000000C024 C481480008C51FE8 6483CCC3000000D8 CCCCCCCFEB003824 5EDBA271CCCCCCCC\r\n2022-08-02 08:39:55.90 spid61 * *******************************************************************************\r\n2022-08-02 08:39:55.90 spid61 * -------------------------------------------------------------------------------\r\n2022-08-02 08:39:55.90 spid61 * Short Stack Dump\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB657401DC" pdb="kernelbase.pdb" age="1" guid="803F8155-6A7C-C618-D23B-5935841C21F8" module="kernelbase" rva="0x201DC" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB19B52A9E" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x10B2A9E" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB19B56D06" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x10B6D06" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1B62A1BC" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x4EA1BC" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB17D6D6C3" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x8D6C3" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB17D6CF54" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x8CF54" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB6542BAB4" pdb="ucrtbase.pdb" age="1" guid="D7E2A94E-E919-EC04-1140-3F3658DBFB15" module="ucrtbase" rva="0x7BAB4" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB6542CA81" pdb="ucrtbase.pdb" age="1" guid="D7E2A94E-E919-EC04-1140-3F3658DBFB15" module="ucrtbase" rva="0x7CA81" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4E4F15" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0x4F15" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4EF3A0" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0xF3A0" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4E414C" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0x414C" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4EFCE1" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0xFCE1" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1B20C314" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0xCC314" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB67E8470F" pdb="ntdll.pdb" age="1" guid="7BC38B16-EB40-D8C0-1526-21EE552A7823" module="ntdll" rva="0xA470F" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB67E0FA9C" pdb="ntdll.pdb" age="1" guid="7BC38B16-EB40-D8C0-1526-21EE552A7823" module="ntdll" rva="0x2FA9C" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4EF86E" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0xF86E" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4E2E05" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0x2E05" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4E3224" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0x3224" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4E4248" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0x4248" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4F0AB5" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0x10AB5" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4EEF90" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0xEF90" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB67E8468F" pdb="ntdll.pdb" age="1" guid="7BC38B16-EB40-D8C0-1526-21EE552A7823" module="ntdll" rva="0xA468F" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB67E1222E" pdb="ntdll.pdb" age="1" guid="7BC38B16-EB40-D8C0-1526-21EE552A7823" module="ntdll" rva="0x3222E" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB67E2FDE3" pdb="ntdll.pdb" age="1" guid="7BC38B16-EB40-D8C0-1526-21EE552A7823" module="ntdll" rva="0x4FDE3" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB657401DC" pdb="kernelbase.pdb" age="1" guid="803F8155-6A7C-C618-D23B-5935841C21F8" module="kernelbase" rva="0x201DC" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4E66C0" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0x66C0" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB17D6C3AA" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x8C3AA" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB17D6D767" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x8D767" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB17D6C5F0" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x8C5F0" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4EF125" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0xF125" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4E3950" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0x3950" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4E3368" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0x3368" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4E4248" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0x4248" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB5A4EFCE1" pdb="vcruntime140.amd64.pdb" age="1" guid="237EE976-4E0C-0DB0-A4D3-B5F0CE7CD540" module="vcruntime140.amd64" rva="0xFCE1" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB67E8468F" pdb="ntdll.pdb" age="1" guid="7BC38B16-EB40-D8C0-1526-21EE552A7823" module="ntdll" rva="0xA468F" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB67E1222E" pdb="ntdll.pdb" age="1" guid="7BC38B16-EB40-D8C0-1526-21EE552A7823" module="ntdll" rva="0x3222E" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB67E8369E" pdb="ntdll.pdb" age="1" guid="7BC38B16-EB40-D8C0-1526-21EE552A7823" module="ntdll" rva="0xA369E" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1B306BF3" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x1C6BF3" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1B2EF7E9" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x1AF7E9" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1B2EFE49" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x1AFE49" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1B2EFB77" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x1AFB77" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1C9C2A17" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x1882A17" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1BB6897B" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0xA2897B" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18262D17" pdb="SqlTsEs.pdb" age="2" guid="DCAFF09E-F15D-4D3F-B35A-90D3943CAA6F" module="SqlTsEs" rva="0x2D17" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1BBABAA2" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0xA6BAA2" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1BBAAF48" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0xA6AF48" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1B168FB5" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x28FB5" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB1B18539E" pdb="sqlmin.pdb" age="2" guid="A85BD4FB-BC54-4065-8A4F-063B6CDE3AFD" module="sqlmin" rva="0x4539E" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18ABE128" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x1E128" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AD95E8" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x395E8" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AD8FB4" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x38FB4" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AB7974" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x17974" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AB81AA" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x181AA" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AB8CC9" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x18CC9" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AB760D" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x1760D" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18DC4F42" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x324F42" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB19BBEC57" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x111EC57" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB19BBE999" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x111E999" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB19BB9B8C" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x1119B8C" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB19262123" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x7C2123" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB19BBC946" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x111C946" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB19BBAF4D" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x111AF4D" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB19BBAA4C" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x111AA4C" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB19BC2D45" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x1122D45" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18D264FE" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x2864FE" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AB7974" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x17974" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AB81AA" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x181AA" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AB8CC9" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x18CC9" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AB760D" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x1760D" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AC27CC" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x227CC" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AB52E9" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x152E9" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB18AB5087" pdb="sqllang.pdb" age="2" guid="C97CCDF6-BCDE-4EEA-88AB-30167EA5105C" module="sqllang" rva="0x15087" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB17CE8BD9" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x8BD9" \/>\r\n2022-08-02 08:39:55.90 spid61 <frame id="00" address="0x7FFB17CE88E6" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x88E6" \/>\r\n2022-08-02 08:39:55.91 spid61 <frame id="00" address="0x7FFB17CE8451" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x8451" \/>\r\n2022-08-02 08:39:55.91 spid61 <frame id="00" address="0x7FFB17D18A0F" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x38A0F" \/>\r\n2022-08-02 08:39:55.91 spid61 <frame id="00" address="0x7FFB17D18D50" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x38D50" \/>\r\n2022-08-02 08:39:55.91 spid61 <frame id="00" address="0x7FFB17D18B89" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x38B89" \/>\r\n2022-08-02 08:39:55.91 spid61 <frame id="00" address="0x7FFB17D196DA" pdb="SqlDK.pdb" age="2" guid="9CA7910A-3090-4EF3-B34F-8F74B6F0736F" module="SqlDK" rva="0x396DA" \/>\r\n2022-08-02 08:39:55.91 spid61 <frame id="00" address="0x7FFB66BE4ED0" pdb="kernel32.pdb" age="1" guid="E3D30A17-E8D7-33F7-6AEC-D5F901AD9EFC" module="kernel32" rva="0x14ED0" \/>\r\n2022-08-02 08:39:55.91 spid61 <frame id="00" address="0x7FFB67E5E39B" pdb="ntdll.pdb" age="1" guid="7BC38B16-EB40-D8C0-1526-21EE552A7823" module="ntdll" rva="0x7E39B" \/>\r\n2022-08-02 08:39:55.91 spid61 Stack Signature for the dump is 0x00000000BE7414D9\r\n2022-08-02 08:39:55.91 spid61 CDmpClient::ExecuteAllCallbacks started.\r\n2022-08-02 08:39:55.91 spid61 XE_DumpCallbacks is executing...\r\n2022-08-02 08:39:55.94 spid61 DumpCallbackSOS is executing...\r\n2022-08-02 08:39:55.94 spid61 DumpCallbackEE is executing...\r\n2022-08-02 08:39:55.95 spid61 DumpCallbackSE is executing...\r\n2022-08-02 08:39:56.03 spid61 DumpCallbackSEAM is executing...\r\n2022-08-02 08:39:56.04 spid61 DumpCallbackSSB is executing...\r\n2022-08-02 08:39:56.08 spid61 DumpCallbackQE is executing...\r\n2022-08-02 08:39:56.09 spid61 DumpCallbackFullText is executing...\r\n2022-08-02 08:39:56.09 spid61 DumpCallbackSQLCLR is executing...\r\n2022-08-02 08:39:56.09 spid61 DumpCallbackHk is executing...\r\n2022-08-02 08:39:56.11 spid61 DumpCallbackRepl is executing...\r\n2022-08-02 08:39:56.11 spid61 DumpCallbackPolyBase is executing...\r\n2022-08-02 08:39:56.11 spid61 CDmpClient::ExecuteAllCallbacks completed. Time elapsed: 0 seconds.\r\n2022-08-02 08:39:56.75 spid61 External dump process return code 0x20000001.\r\nExternal dump process returned no errors.\r\n\r\n&nbsp;\r\n<pre><\/pre>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>","protected":false},"excerpt":{"rendered":"
Que \u00e7a soit \u00e0 des fins applicatives ou de l’archivage, il nous arrive de plus en plus de rencontrer des colonnes XML massives dans nos bases de donn\u00e9es. Cela peut vite devenir tr\u00e8s encombrant et consommateur d’IO. Et m\u00eame si… Continuer la lecture →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":9411,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[419,421,408,410,420,422],"class_list":["post-9292","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-419","tag-compression","tag-sql-server-2022","tag-sqlserver2022","tag-xml","tag-xml_compression"],"yoast_head":"\nSQL Server 2022 : La compression XML - Capdata TECH BLOG<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2022 : La compression XML - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Que \u00e7a soit \u00e0 des fins applicatives ou de l’archivage, il nous arrive de plus en plus de rencontrer des colonnes XML massives dans nos bases de donn\u00e9es. Cela peut vite devenir tr\u00e8s encombrant et consommateur d’IO. Et m\u00eame si… Continuer la lecture →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-02T08:55:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-23T09:06:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2022\/08\/xml2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Capdata team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Capdata team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"46 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/\"},\"author\":{\"name\":\"Capdata team\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9\"},\"headline\":\"SQL Server 2022 : La compression XML\",\"datePublished\":\"2022-08-02T08:55:04+00:00\",\"dateModified\":\"2022-08-23T09:06:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/\"},\"wordCount\":9265,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"2022\",\"Compression\",\"SQL Server 2022\",\"sqlserver2022\",\"XML\",\"XML_COMPRESSION\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/\",\"name\":\"SQL Server 2022 : La compression XML - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2022-08-02T08:55:04+00:00\",\"dateModified\":\"2022-08-23T09:06:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2022 : La compression XML\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9\",\"name\":\"Capdata team\",\"sameAs\":[\"https:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2022 : La compression XML - Capdata TECH BLOG","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/","og_locale":"fr_FR","og_type":"article","og_title":"SQL Server 2022 : La compression XML - Capdata TECH BLOG","og_description":"Que \u00e7a soit \u00e0 des fins applicatives ou de l’archivage, il nous arrive de plus en plus de rencontrer des colonnes XML massives dans nos bases de donn\u00e9es. Cela peut vite devenir tr\u00e8s encombrant et consommateur d’IO. Et m\u00eame si… Continuer la lecture →","og_url":"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2022-08-02T08:55:04+00:00","article_modified_time":"2022-08-23T09:06:30+00:00","og_image":[{"width":350,"height":350,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2022\/08\/xml2.png","type":"image\/png"}],"author":"Capdata team","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Capdata team","Dur\u00e9e de lecture estim\u00e9e":"46 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/"},"author":{"name":"Capdata team","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9"},"headline":"SQL Server 2022 : La compression XML","datePublished":"2022-08-02T08:55:04+00:00","dateModified":"2022-08-23T09:06:30+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/"},"wordCount":9265,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["2022","Compression","SQL Server 2022","sqlserver2022","XML","XML_COMPRESSION"],"articleSection":["SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/","url":"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/","name":"SQL Server 2022 : La compression XML - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2022-08-02T08:55:04+00:00","dateModified":"2022-08-23T09:06:30+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/sql-server-2022-la-compression-xml\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2022 : La compression XML"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9","name":"Capdata team","sameAs":["https:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/9292","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=9292"}],"version-history":[{"count":7,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/9292\/revisions"}],"predecessor-version":[{"id":9312,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/9292\/revisions\/9312"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/9411"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=9292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=9292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=9292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}