
SQL Server Configuration Manager Services Hatası
6
●80
- 03-10-2022, 23:35:09Üyeliği durdurulduneredeyse sabahtan beri uğraşıyorum. Burdan yardım istemek geldi aklıma.

- 03-10-2022, 23:54:28Hata detayına loglardan bakarsan çözüme hızla ulaşabilirsin olasi çözümler icin buraya tikla
<Drive>:Program FilesMicrosoft SQL ServerMSSQL13.<InstanceName>MSSQLLog
İcerisinde olmali log dosyasi - 04-10-2022, 00:26:47Üyeliği durduruldu
- 04-10-2022, 00:28:14Evet errorlog dosyasini açın metin belgesi ile olabiir. Hata kodunu görüntüleyin
- 04-10-2022, 00:33:01Üyeliği durdurulduatiryakicom adlı üyeden alıntı: mesajı görüntüle
7 dosya var hangisine bakmam gerek - 04-10-2022, 00:34:07Üyeliği durdurulduatiryakicom adlı üyeden alıntı: mesajı görüntüle
saatlere baktım en son bu kayıtlar var
2022-10-04 00:17:08.88 Server Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Standard Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 22621: )
2022-10-04 00:17:08.89 Server UTC adjustment: 3:00
2022-10-04 00:17:08.89 Server (c) Microsoft Corporation.
2022-10-04 00:17:08.89 Server All rights reserved.
2022-10-04 00:17:08.89 Server Server process ID is 1892.
2022-10-04 00:17:08.89 Server System Manufacturer: 'System manufacturer', System Model: 'System Product Name'.
2022-10-04 00:17:08.89 Server Authentication mode is MIXED.
2022-10-04 00:17:08.89 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL15.MSSQLSERVERMSSQLLogERRORLOG'.
2022-10-04 00:17:08.89 Server The service account is 'WORKGROUPHOME-PC$'. This is an informational message; no user action is required.
2022-10-04 00:17:08.89 Server Registry startup parameters:
-d C:Program FilesMicrosoft SQL ServerMSSQL15.MSSQLSERVERMSSQLDATAmaster.mdf
-e C:Program FilesMicrosoft SQL ServerMSSQL15.MSSQLSERVERMSSQLLogERRORLOG
-l C:Program FilesMicrosoft SQL ServerMSSQL15.MSSQLSERVERMSSQLDATAmastlog.ldf
2022-10-04 00:17:08.89 Server Command Line Startup Parameters:
-s "MSSQLSERVER"
2022-10-04 00:17:08.89 Server SQL Server detected 1 sockets with 12 cores per socket and 24 logical processors per socket, 24 total logical processors; using 24 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2022-10-04 00:17:08.89 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2022-10-04 00:17:08.89 Server Detected 16291 MB of RAM. This is an informational message; no user action is required.
2022-10-04 00:17:08.89 Server Using locked pages in the memory manager.
2022-10-04 00:17:08.89 Server Page exclusion bitmap is enabled.
2022-10-04 00:17:08.98 Server Buffer Pool: Allocating 4194304 bytes for 2188273 hashPages.
2022-10-04 00:17:09.09 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2022-10-04 00:17:09.09 Server Automatic soft-NUMA was enabled because SQL Server has detected hardware NUMA nodes with greater than 8 physical cores.
2022-10-04 00:17:09.11 Server Buffer pool extension is already disabled. No action is necessary.
2022-10-04 00:17:09.16 Server Query Store settings initialized with enabled = 1,
2022-10-04 00:17:09.17 Server The maximum number of dedicated administrator connections for this instance is '1'
2022-10-04 00:17:09.17 Server This instance of SQL Server last reported using a process ID of 4116 at 3.10.2022 23:49:57 (local) 3.10.2022 20:49:57 (UTC). This is an informational message only; no user action is required.
2022-10-04 00:17:09.17 Server Node configuration: node 0: CPU mask: 0x0000000000555555:0 Active CPU mask: 0x0000000000555555:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2022-10-04 00:17:09.17 Server Node configuration: node 1: CPU mask: 0x0000000000aaaaaa:0 Active CPU mask: 0x0000000000aaaaaa:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2022-10-04 00:17:09.18 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.
2022-10-04 00:17:09.18 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2022-10-04 00:17:09.18 Server In-Memory OLTP initialized on standard machine.
2022-10-04 00:17:09.19 Server [INFO] Created Extended Events session 'hkenginexesession'
2022-10-04 00:17:09.19 Server Database Instant File Initialization: enabled. 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.
2022-10-04 00:17:09.19 Server Total Log Writer threads: 4. This is an informational message; no user action is required.
2022-10-04 00:17:09.21 Server clwb is selected for pmem flush operation.
2022-10-04 00:17:09.21 Server Software Usage Metrics is disabled.
2022-10-04 00:17:09.21 spid12s Starting up database 'master'.
2022-10-04 00:17:09.22 spid12s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:Program FilesMicrosoft SQL ServerMSSQL15.MSSQLSERVERMSSQLDATAmaster.mdf.
2022-10-04 00:17:09.38 Server CLR version v4.0.30319 loaded.
2022-10-04 00:17:09.42 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:WindowsMicrosoft.NETFramework64v4.0.30319.
