Skip to content

Files

Latest commit

author
Ajay Dwivedi
Modified few scripts and documents
Apr 1, 2020
7696252 · Apr 1, 2020

History

History
This branch is 107 commits ahead of mtikoian/SQLDBA-SSMS-Solution:master.

sp_HealthCheck

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
0.2 - sp_HealthCheck.sql
0.2 - sp_HealthCheck.sql
 
 
Certificate Based Authentication.sql
Certificate Based Authentication.sql
 
 
CpuUtilizationHistory.sql
CpuUtilizationHistory.sql
 
 
Extract Data From sp_WhoIsActive Collection.sql
Extract Data From sp_WhoIsActive Collection.sql
 
 
Find - What is Deleting Data.sql
Find - What is Deleting Data.sql
 
 
README.md
README.md
 
 
SQLQuery1.sql
SQLQuery1.sql
 
 
Testing.sql
Testing.sql
 
 
__01) Log all Activities using sp_WhoIsActive.sql
__01) Log all Activities using sp_WhoIsActive.sql
 
 
sp_HealthCheck.gif
sp_HealthCheck.gif
 
 
sp_HealthCheck.sql
sp_HealthCheck.sql
 
 
sp_HealthCheck.ssmssqlproj
sp_HealthCheck.ssmssqlproj
 
 
sp_HealthCheck_New.JPG
sp_HealthCheck_New.JPG
 
 
sp_HealthCheck_PMTDBA.JPG
sp_HealthCheck_PMTDBA.JPG
 
 

README.md

[sp_HealthCheck]

This project contains a procedure named sp_HealthCheck.

This procedure gives currently running queries, CPU and Memory usage, Usage of Data & Log Volumes, Space utilization of data/log files, Lead Blockers, and session details performing Backup/Restore/Rollback.