MS-SQL Server - Manclute Practical

Manclute Practical

 

M - Monitoring (Have a Practical Session once a Month even If automated).

A - Association (Have an associate during the session).

N - Network Connectivity Check (Have a Practical Session once a Month even if automated).

C - Configuration Manager Reviewing settings (Have a Practical Session once a Month even if automated).

L - Logspace (Have a Practical Session once a Month even if automated).

U - Update Statistics (Have a Practical Session once a Month even if automated).

T - Tracing (Have a Practical Session once a Month even if automated).

E - Error Log Review (Have a Practical Session once a Month even if automated).

Additionally,

If CPU is High

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-high-cpu-usage-issues

Open Calculator

Sum, Average and Count

 

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

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

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

Cycle Error Log

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-cycle-errorlog-transact-sql?view=sql-server-ver16

Utility

https://learn.microsoft.com/en-us/sql/relational-databases/manage/sql-server-utility-features-and-tasks?view=sql-server-ver16

Access Denied

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/startup-shutdown/event-id-7000-access-denied

Beautify SQL queries/code for your blog using HTML.

Read/Learn if you are Thinking for Patching 

https://amit-sqldbasupport.blogspot.com/2023/03/ms-sql-server-patching.html?m=1

Best Regards

T. Amit Vaid S.