MS-SQL Server - इक्यावन से शुरुवात

इक्यावन से शुरुवात

पहली 50 Background processes जो SQL Server की researved होती हैं जबकि हम एक नई process ID 51 ले सकते हैं

Some of these are..

BRKR EVENT HNDLR

BRKR TASK

CHECKPOINT      

DB MIRROR       

DB STARTUP      

LAZY WRITER     

LOCK MONITOR    

LOG WRITER      

PARALLEL REDO TA

RECEIVE         

RECOVERY WRITER 

RESOURCE MONITOR

SIGNAL HANDLER  

SYSTEM_HEALTH_MO

TRACE QUEUE TASK

UNKNOWN TOKEN   

XE DISPATCHER   

XE TIMER        

XTP_CKPT_AGENT

TASK MANAGER

GHOST CLEANUP

विचार

सावन का साथी, एक जीत

जब बरसात के मौसम में office नहीं पहुंच पाने के कारण काम रुक जाता था, तो SQL Server ने internet का साथ लिया, अब धूप निकलते ही हम फिर से as per routine, office आ जा सकते हैं

Besides this, Internet से मिली शान को जब मान्यता दी तो SQL Azure Technology की शुरुवात हुई!

अर्थात हमें SQL Server ही चाहिए!

Additionally,

- Understand your requirement by running performance monitor.
- Named Instance Benefits
- Anti-Virus Exclusion
- Basic Help on Architecture (BHA) - Rationals are requested to collect only the important parts from given articles as there may be some other lengthy paragraphs that can be ignored.

https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-transaction-log-architecture-and-management-guide?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-architecture?view=sql-server-ver16

- Smalldatetime and other datatypes

https://learn.microsoft.com/en-us/sql/t-sql/data-types/smalldatetime-transact-sql?view=sql-server-ver16

- Service Restart Steps

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/start-stop-pause-resume-restart-sql-server-services?view=sql-server-ver16

- Failover Cluster Heartbeat

https://learn.microsoft.com/en-us/troubleshoot/windows-server/high-availability/private-heartbeat-configuration-on-cluster-server

- Old Jobs to be deactivated.

https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/dbo-sysjobs-transact-sql?view=sql-server-ver16

- Foreign Key Constraints/Relation

https://learn.microsoft.com/en-us/sql/relational-databases/tables/create-foreign-key-relationships?view=sql-server-ver16

- Common Language Runtime

https://learn.microsoft.com/en-us/sql/relational-databases/user-defined-functions/create-clr-functions?view=sql-server-ver16

Other Link of 29th April, 2023.

https://amit-sqldbasupport.blogspot.com/2023/04/ms-sql-server-azure-guidance-for.html?m=0

https://www.microsoft.com/en-us/Download/confirmation.aspx?id=101064

सदा हो जय!

Best Regards

T. Amit Vaid S.