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
Mar 30, 2018
Certificate Based Authentication.sql
Certificate Based Authentication.sql
May 16, 2019
CpuUtilizationHistory.sql
CpuUtilizationHistory.sql
Mar 30, 2018
Extract Data From sp_WhoIsActive Collection.sql
Extract Data From sp_WhoIsActive Collection.sql
Sep 2, 2018
Find - What is Deleting Data.sql
Find - What is Deleting Data.sql
Jun 11, 2018
README.md
README.md
Mar 31, 2018
SQLQuery1.sql
SQLQuery1.sql
Aug 22, 2019
Testing.sql
Testing.sql
Mar 31, 2018
__01) Log all Activities using sp_WhoIsActive.sql
__01) Log all Activities using sp_WhoIsActive.sql
Jun 21, 2018
sp_HealthCheck.gif
sp_HealthCheck.gif
Mar 31, 2018
sp_HealthCheck.sql
sp_HealthCheck.sql
Feb 21, 2019
sp_HealthCheck.ssmssqlproj
sp_HealthCheck.ssmssqlproj
Apr 1, 2020
sp_HealthCheck_New.JPG
sp_HealthCheck_New.JPG
Mar 30, 2018
sp_HealthCheck_PMTDBA.JPG
sp_HealthCheck_PMTDBA.JPG
Mar 30, 2018

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.