MS-SQL Server - DBA Role to Monitor

DBA Role to Monitor....

- Buffer Cache Hit Ratio

- Disk I/O by Average Disk Queue Length

- Page Life Expectancy

- High CPU

- Total n Target Memory

- Disk Read Writes I/O

Additionally,

LIKE Operator

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-ver16

Database Mirroring

https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server?view=sql-server-ver16

Shared Memory

https://learn.microsoft.com/en-us/sql/tools/configuration-manager/shared-memory-properties?view=sql-server-ver16

Backup Media Family

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/media-sets-media-families-and-backup-sets-sql-server?view=sql-server-ver16

Partial backups are useful whenever you want to exclude read-only filegroups. A partial backup resembles a full database backup, but a partial backup does not contain all the filegroups

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/partial-backups-sql-server?view=sql-server-ver16

Well Known Text

https://learn.microsoft.com/en-us/bingmaps/v8-web-control/map-control-concepts/well-known-text-examples/

WaitTypes to learn in this article

- BROKER_SHUTDOWN

- FT_RESTART_CRAWL

- BUILTIN_HASHKEY_MUTEX

- PWAIT_MD_SERVER_CACHE

Internal Use Only,

-REMOTE_DATA_ARCHIVE_MIGRATION_DMV

Certification

https://learn.microsoft.com/en-us/certifications/posts/mcsa-mcsd-mcse-certifications-retire-with-continued-investment-to-role-based-certifications

Migrate a Reporting Services Installation

https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/migrate-a-reporting-services-installation-native-mode?view=sql-server-ver16

Days between two dates

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

Best Regards

T. Amit Vaid S.