MS-SQL Server - Most Incoming Calls

Most Incoming Calls

Well, today we will learn about most of the issue related calls we receive in day to day activities.

- Space Issue

- CPU 100%

- Deadlock Errors

- Account Locked out / Password reset

- SQL Agent not running

- Blocking

Please share your valuable experience to improve the same.

Additionally,

Collation Settings

https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16

& Waittypes

DBCC_SCALE_OUT_EXPR_CACHE

IO_QUEUE_LIMIT

PREEMPTIVE_OS_NETLOCALGROUPGETMEMBERS

PHYSICAL_SEEDING_DMV

RESERVED_MEMORY_ALLOCATION_EXT

(Internal Use only)

Imp. Ones

HADR_AR_CRITICAL_SECTION_ENTRY

HADR_CLUSAPI_CALL

RBIO_RG_LOCALDESTAGE

SNI_CRITICAL_SECTION

SOS_CALLBACK_REMOVAL

CLR_MEMORY_SPY

CLR_MONITOR

EE_PMOLOCK

MEMORY_ALLOCATION_EXT

2019 RTM {Release to Manufacture} (Versions)

https://support.microsoft.com/en-us/topic/kb4518398-sql-server-2019-build-versions-782ed548-1cd8-b5c3-a566-8b4f9e20293a

Surface Area Configuration

https://learn.microsoft.com/en-us/sql/relational-databases/security/surface-area-configuration?view=sql-server-ver16

Find the product key for SQL Server Reporting Services

https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/find-reporting-services-product-key-ssrs?view=sql-server-ver16

Aggregate Functions

https://learn.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver16

How Update Lock Works

https://learn.microsoft.com/en-us/answers/questions/91746/how-update-lock-works

Database Diagram

https://learn.microsoft.com/en-us/sql/ssms/visual-db-tools/create-a-new-database-diagram-visual-database-tools?view=sql-server-ver16

Public Database Role

https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver16

Job Roles

https://learn.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-fixed-database-roles?view=sql-server-ver16

TradeMark Guidelines

https://www.microsoft.com/en-us/legal/intellectualproperty/trademarks

Best Regards

T. Amit Vaid S.