(SPs) - SPROCs related to Performance.

SPS- System's Performance Stored Procedures

- sp_indexes
- sp_helpindex
- sp_indexoption
- sp_monitor
- sp_trace_getdata
- sp_who2
- sp_updatestats
- sp_statistics

- sp_helpstats

SQL Server - Storage Area Network (SAN)

Related Article

https://learn.microsoft.com/en-us/sharepoint/administration/storage-and-sql-server-capacity-planning-and-configuration

TOP Wait types

- CXPACKET,
- SOS_SCHEDULER_YIELD,
- LCK_M_IX,
- LCK_M_U,
- LCK_M_X,
- PAGEIOLATCH_SH,
- PAGEIOLATCH_EX,
- WRITELOG,
- ASYNC_NETWORK_IO,
- IO_COMPLETION,
- OLEDB

Maintenance Plan is one of the Tool to Schedule the Backups of System and User Databases.

Refer the below screenshot.




BLC - INPUTS / Value
- Buffer Cache Hit Ratio
- Latch Stats
- CPU Usage

Related..
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-latch-stats-transact-sql?view=sql-server-ver16

Additionally,

PerfMon Disk Related Counters
Physical Disk – Avg. Disk sec/Read
Physical Disk – Avg. Disk sec/Write
Physical Disk – Disk Reads/Per second
Physical Disk – Disk Writes/ Per second

Note:- There are General Statistics related to User Connections as well.


NO IDEA or We cannot get GAI (General Average IDEA) of SQL Server Status, if in case we do not keep on capturing Performance counter data from related dmv. There are certain reasons behind abnormal values from which we need to analyse the route cause.

Also there is SUM with conditions.
https://learn.microsoft.com/en-us/answers/questions/599592/conditional-sum-syntax-are-these-two-methods-both.html

Additionally,

We can also learn about Public connect permissions, refer below link

https://learn.microsoft.com/en-us/sql/relational-databases/policy-based-management/server-public-permissions?view=sql-server-ver16

Amit Vaid
Professional SQL Server DBA
New Delhi.
Note:- Signatures are usually not needed on General Information on Internet.