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
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
Amit Vaid
Professional SQL Server DBA
New Delhi.
Note:- Signatures are usually not needed on General Information on Internet.
Professional SQL Server DBA
New Delhi.
Note:- Signatures are usually not needed on General Information on Internet.
No comments:
Post a Comment