Skip to content

ash3rr/SQLServerMonitoringSolution

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
DB Performance Dashboard_v4.pbix
DB Performance Dashboard_v4.pbix
 
 
DBFreeSpace_query.sql
DBFreeSpace_query.sql
 
 
Deadlock Report.pbix
Deadlock Report.pbix
 
 
README.md
README.md
 
 
indexusage2_sp.sql
indexusage2_sp.sql
 
 
indexusge_tbl.sql
indexusge_tbl.sql
 
 
install.ps1
install.ps1
 
 
job_aggregateiostats.sql
job_aggregateiostats.sql
 
 
job_buffer_pool_summary.sql
job_buffer_pool_summary.sql
 
 
job_cpu rank collector.sql
job_cpu rank collector.sql
 
 
job_cpu_history_collector.sql
job_cpu_history_collector.sql
 
 
job_dbfile latency collector.sql
job_dbfile latency collector.sql
 
 
job_dbfreespace_collector.sql
job_dbfreespace_collector.sql
 
 
job_deadlock_collector.sql
job_deadlock_collector.sql
 
 
job_diskfreespace_collector.sql
job_diskfreespace_collector.sql
 
 
job_disklatency_collector.sql
job_disklatency_collector.sql
 
 
job_memoryclerksummary.sql
job_memoryclerksummary.sql
 
 
job_ossysmemory.sql
job_ossysmemory.sql
 
 
job_semaphorememorysummary.sql
job_semaphorememorysummary.sql
 
 
job_statistics_history.sql
job_statistics_history.sql
 
 
job_thread_info_collector.sql
job_thread_info_collector.sql
 
 
job_threadinfo_collector.sql
job_threadinfo_collector.sql
 
 
job_threadpool_wait_collector.sql
job_threadpool_wait_collector.sql
 
 
job_top_waits_collector.sql
job_top_waits_collector.sql
 
 
perf counter collector job.sql
perf counter collector job.sql
 
 
perfcounter_sp.sql
perfcounter_sp.sql
 
 
performancecounters_tbl.sql
performancecounters_tbl.sql
 
 
semaphorememsummary_sp.sql
semaphorememsummary_sp.sql
 
 
semaphoreresource_tbl.sql
semaphoreresource_tbl.sql
 
 
sizing_sp.sql
sizing_sp.sql
 
 
sp_alert_blocking.sql
sp_alert_blocking.sql
 
 
sp_bufferpoolsummary2.sql
sp_bufferpoolsummary2.sql
 
 
sp_dbfilelatencymonitor.sql
sp_dbfilelatencymonitor.sql
 
 
sp_disklatencymonitor.sql
sp_disklatencymonitor.sql
 
 
sp_fragmentation_report.sql
sp_fragmentation_report.sql
 
 
sp_indexusage.sql
sp_indexusage.sql
 
 
sp_memoryclerksummary.sql
sp_memoryclerksummary.sql
 
 
sp_os_sys_memory.sql
sp_os_sys_memory.sql
 
 
sp_ossysmemory.sql
sp_ossysmemory.sql
 
 
sp_perfcounters.sql
sp_perfcounters.sql
 
 
sp_semaphorememsummary.sql
sp_semaphorememsummary.sql
 
 
sp_statistics_history.sql
sp_statistics_history.sql
 
 
sp_topwaitmon.sql
sp_topwaitmon.sql
 
 
sp_topwaitmonitor.sql
sp_topwaitmonitor.sql
 
 
tbl_aggregateiostats.sql
tbl_aggregateiostats.sql
 
 
tbl_blockedreport.sql
tbl_blockedreport.sql
 
 
tbl_bufferpoolsummary.sql
tbl_bufferpoolsummary.sql
 
 
tbl_cpuhistory.sql
tbl_cpuhistory.sql
 
 
tbl_cpuintensivequeries.sql
tbl_cpuintensivequeries.sql
 
 
tbl_cpurank.sql
tbl_cpurank.sql
 
 
tbl_dbfilelatency.sql
tbl_dbfilelatency.sql
 
 
tbl_dbfreespace.sql
tbl_dbfreespace.sql
 
 
tbl_diskfreespace.sql
tbl_diskfreespace.sql
 
 
tbl_disklatency.sql
tbl_disklatency.sql
 
 
tbl_healthcheck.sql
tbl_healthcheck.sql
 
 
tbl_indexfraglog.sql
tbl_indexfraglog.sql
 
 
tbl_indexusge.sql
tbl_indexusge.sql
 
 
tbl_memoryclerk.sql
tbl_memoryclerk.sql
 
 
tbl_memoryclerksummary.sql
tbl_memoryclerksummary.sql
 
 
tbl_memoryintensivequeries.sql
tbl_memoryintensivequeries.sql
 
 
tbl_os_sysmemory.sql
tbl_os_sysmemory.sql
 
 
tbl_performancecounters_broken.sql
tbl_performancecounters_broken.sql
 
 
tbl_statistics_history.sql
tbl_statistics_history.sql
 
 
tbl_sysmemory_broken.sql
tbl_sysmemory_broken.sql
 
 
tbl_threadinfo.sql
tbl_threadinfo.sql
 
 
tbl_threadpoolwait.sql
tbl_threadpoolwait.sql
 
 
tbl_topwaits.sql
tbl_topwaits.sql
 
 

Repository files navigation

SQL Server Monitoring Solution

The solution is comprised of *.tbl files which must be installed ran first inside the DBATools database.

After this you can create the stored procedure files (sp_) in the same database.

You should then create the jobs.

After this installation step, metrics are inserted into tables within the DBATools database. The Power BI dashboard which is in the repository connects to and allows you visualise these metrics in order to monitor SQL Server performance.

About

No description, website, or topics provided.

Resources

Readme
Activity

Stars

1 star

Watchers

2 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages