SQL server 2022 "database Engine services failed" hatası

ishak042

Femtopat
Katılım
1 Mart 2024
Mesajlar
2
Daha fazla  
Cinsiyet
Erkek
Ne kadar çözüm denediysem olmuyor. MSSM'de database bağlanamıyor, hizmet başlatılamıyor. Sizlere hata günlüğümü paylaşacağım sorunun ne olduğunu anlayamıyorum.


2024-03-03 15:27:07.63 Server Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64)
Oct 8 2022 05:58:25
Copyright (C) 2022 Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 22631: ) (Hypervisor)

2024-03-03 15:27:07.63 Server UTC adjustment: 3:00
2024-03-03 15:27:07.63 Server (c) Microsoft Corporation.
2024-03-03 15:27:07.64 Server All rights reserved.
2024-03-03 15:27:07.64 Server Server process ID is 8656.
2024-03-03 15:27:07.64 Server System Manufacturer: 'MONSTER', System Model: 'TULPAR T5 V20.3'.
2024-03-03 15:27:07.64 Server Authentication mode is MIXED.
2024-03-03 15:27:07.64 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2024-03-03 15:27:07.64 Server The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.
2024-03-03 15:27:07.64 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2024-03-03 15:27:07.64 Server Command Line Startup Parameters:
-s "MSSQLSERVER"
2024-03-03 15:27:07.64 Server SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket, 16 total logical processors; using 16 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2024-03-03 15:27:07.65 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2024-03-03 15:27:07.65 Server Detected 16125 MB of RAM. This is an informational message; no user action is required.
2024-03-03 15:27:07.65 Server Using conventional memory in the memory manager.
2024-03-03 15:27:07.65 Server Detected pause instruction latency: 122 cycles.
2024-03-03 15:27:07.65 Server Spin divider value used: 3
2024-03-03 15:27:07.65 Server Page exclusion bitmap is enabled.
2024-03-03 15:27:07.80 Server Buffer Pool: Allocating 2097152 bytes for 1929000 hashPages.
2024-03-03 15:27:07.81 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2024-03-03 15:27:07.82 Server Buffer pool extension is already disabled. No action is necessary.
2024-03-03 15:27:07.83 Server CPU vectorization level(s) detected: SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2 AVX512 (F CD BW DQ VL IFMA VBMI VBMI2 VNNI BITALG VPOQCNTDQ VP2INTERSECT)
2024-03-03 15:27:07.85 Server Query Store settings initialized with enabled = 1,
2024-03-03 15:27:07.86 Server The maximum number of dedicated administrator connections for this instance is '1'
2024-03-03 15:27:07.86 Server This instance of SQL Server last reported using a process ID of 2976 at 3.03.2024 15:21:49 (local) 3.03.2024 12:21:49 (UTC). This is an informational message only; no user action is required.
2024-03-03 15:27:07.86 Server Node configuration: node 0: CPU mask: 0x000000000000ffff:0 Active CPU mask: 0x000000000000ffff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2024-03-03 15:27:07.87 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2024-03-03 15:27:07.87 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2024-03-03 15:27:07.87 Server In-Memory OLTP initialized on standard machine.
2024-03-03 15:27:07.89 Server [INFO] Created Extended Events session 'hkenginexesession'
2024-03-03 15:27:07.89 Server Database Instant File Initialization: disabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2024-03-03 15:27:07.89 Server Total Log Writer threads: 2, Node CPUs: 8, Nodes: 1, Log Writer threads per CPU: 1, Log Writer threads per Node: 2
2024-03-03 15:27:07.89 Server clwb is selected for pmem flush operation.
2024-03-03 15:27:07.90 Server Software Usage Metrics is disabled.
2024-03-03 15:27:07.90 spid43s Starting up database 'master'.
2024-03-03 15:27:07.91 spid43s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\master.mdf.
2024-03-03 15:27:07.91 spid43s Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)
2024-03-03 15:27:07.91 spid43s Stack Signature for the dump is 0x0000000000000000
2024-03-03 15:27:07.91 spid43s CDmpClient::ExecuteAllCallbacks started.
2024-03-03 15:27:07.91 spid43s XE_DumpCallbacks is executing...
2024-03-03 15:27:07.92 spid43s DumpCallbackSOS is executing...
2024-03-03 15:27:07.92 spid43s DumpCallbackEE is executing...
2024-03-03 15:27:07.92 spid43s DumpCallbackSE is executing...
2024-03-03 15:27:07.92 spid43s DumpCallbackSEAM is executing...
2024-03-03 15:27:07.92 spid43s DumpCallbackSSB is executing...
2024-03-03 15:27:07.94 spid43s DumpCallbackQE is executing...
2024-03-03 15:27:07.94 spid43s DumpCallbackFullText is executing...
2024-03-03 15:27:07.94 spid43s DumpCallbackSQLCLR is executing...
2024-03-03 15:27:07.94 spid43s DumpCallbackHk is executing...
2024-03-03 15:27:07.94 spid43s DumpCallbackRepl is executing...
2024-03-03 15:27:07.94 spid43s DumpCallbackPolyBase is executing...
2024-03-03 15:27:07.94 spid43s CDmpClient::ExecuteAllCallbacks completed. Time elapsed: 0 seconds.
2024-03-03 15:27:08.07 Server CLR version v4.0.30319 loaded.
2024-03-03 15:27:08.14 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
2024-03-03 15:27:08.50 spid43s External dump process return code 0x20000001.
External dump process returned no errors.
 

Dosya Ekleri

  • Ekran görüntüsü 2024-03-03 154716.png
    Ekran görüntüsü 2024-03-03 154716.png
    70,9 KB · Görüntüleme: 10

Geri
Yukarı