Skip to content

cloupe/sql-server-toolbox

BranchesTags
 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

43 Commits
Availability Groups
Availability Groups
 
 
.gitattributes
.gitattributes
 
 
ALLOW_PAGE_LOCKS.sql
ALLOW_PAGE_LOCKS.sql
 
 
Add SQL Agent Failure Notifications job.sql
Add SQL Agent Failure Notifications job.sql
 
 
Add SQL Agent Failure Notifications.sql
Add SQL Agent Failure Notifications.sql
 
 
Database_File_Sizes.sql
Database_File_Sizes.sql
 
 
Drop_and_Recreate_Table_Objects.sql
Drop_and_Recreate_Table_Objects.sql
 
 
Find_Mini_Dump.sql
Find_Mini_Dump.sql
 
 
FirstByte.sql
FirstByte.sql
 
 
Lock Pages in Memory.sql
Lock Pages in Memory.sql
 
 
README.md
README.md
 
 
Rename_SQL_Instance.sql
Rename_SQL_Instance.sql
 
 
ReplaceFloatWithDecimal.sql
ReplaceFloatWithDecimal.sql
 
 
SQL Mini Dumps.sql
SQL Mini Dumps.sql
 
 
SSRS Subscription failures 2.sql
SSRS Subscription failures 2.sql
 
 
SSRS Subscription failures.sql
SSRS Subscription failures.sql
 
 
SSRS Subscription inventory.sql
SSRS Subscription inventory.sql
 
 
SSRS Subscription jobs.sql
SSRS Subscription jobs.sql
 
 
Security Script - database.sql
Security Script - database.sql
 
 
Security Script 2012.sql
Security Script 2012.sql
 
 
Unsent_DB_Email.sql
Unsent_DB_Email.sql
 
 
VLF generation example.sql
VLF generation example.sql
 
 
VLFs.sql
VLFs.sql
 
 
Volume_Stats_Alert.sql
Volume_Stats_Alert.sql
 
 
add database descriptions.sql
add database descriptions.sql
 
 
add error event alerts.sql
add error event alerts.sql
 
 
autogrow change all 1mb growth files.sql
autogrow change all 1mb growth files.sql
 
 
autogrow events.sql
autogrow events.sql
 
 
automated index rebuild w online 2012.sql
automated index rebuild w online 2012.sql
 
 
automated index rebuild w online 2016.sql
automated index rebuild w online 2016.sql
 
 
avg disk secwrite.png
avg disk secwrite.png
 
 
azure dtu usage every 15s.sql
azure dtu usage every 15s.sql
 
 
azure dtu usage every hour.sql
azure dtu usage every hour.sql
 
 
backup history oldest latest.sql
backup history oldest latest.sql
 
 
backup history.sql
backup history.sql
 
 
backup restore progress.sql
backup restore progress.sql
 
 
busy databases.sql
busy databases.sql
 
 
cached exec plans.sql
cached exec plans.sql
 
 
checksum vs hashbytes.sql
checksum vs hashbytes.sql
 
 
collect connections.sql
collect connections.sql
 
 
compress indexes.sql
compress indexes.sql
 
 
configuration changes history.sql
configuration changes history.sql
 
 
cpu utilization.sql
cpu utilization.sql
 
 
database mail diag.sql
database mail diag.sql
 
 
database ownership.sql
database ownership.sql
 
 
database settings info.sql
database settings info.sql
 
 
database settings.sql
database settings.sql
 
 
deadlock part 1.sql
deadlock part 1.sql
 
 
deadlock part 2.sql
deadlock part 2.sql
 
 
deadlocks in xevents.sql
deadlocks in xevents.sql
 
 
defrag.sql
defrag.sql
 
 
dependencies.sql
dependencies.sql
 
 
deprecated usage counter.sql
deprecated usage counter.sql
 
 
dimdate.sql
dimdate.sql
 
 
dm_exec_query_memory_grants.sql
dm_exec_query_memory_grants.sql
 
 
dm_exec_session_wait_stats.sql
dm_exec_session_wait_stats.sql
 
 
dm_os_wait_stats.sql
dm_os_wait_stats.sql
 
 
dm_os_waiting_tasks.sql
dm_os_waiting_tasks.sql
 
 
easy passwords.sql
easy passwords.sql
 
 
endpoint owners.sql
endpoint owners.sql
 
 
error log.sql
error log.sql
 
 
filetable demo.sql
filetable demo.sql
 
 
fix orphaned sid.sql
fix orphaned sid.sql
 
 
generate error tables.sql
generate error tables.sql
 
 
get disk block allocation size.ps1
get disk block allocation size.ps1
 
 
guest permissions.sql
guest permissions.sql
 
 
hekaton lab.sql
hekaton lab.sql
 
 
index_usage_stats.sql
index_usage_stats.sql
 
 
install failover clustering features.ps1
install failover clustering features.ps1
 
 
instant_file_initialization.sql
instant_file_initialization.sql
 
 
job owners.sql
job owners.sql
 
 
kill detect blocking sessions setup.sql
kill detect blocking sessions setup.sql
 
 
kill detect blocking spids job.sql
kill detect blocking spids job.sql
 
 
kill detect blocking spids.sql
kill detect blocking spids.sql
 
 
missing index setup demo.sql
missing index setup demo.sql
 
 
missing indexes.sql
missing indexes.sql
 
 
modules vs routines.sql
modules vs routines.sql
 
 
move system databases.sql
move system databases.sql
 
 
multiserver backup history.sql
multiserver backup history.sql
 
 
multiserver space in files.sql
multiserver space in files.sql
 
 
my_permissions.sql
my_permissions.sql
 
 
open transactions.sql
open transactions.sql
 
 
optimize for ad hoc workloads.sql
optimize for ad hoc workloads.sql
 
 
overdue jobs.sql
overdue jobs.sql
 
 
page life expectancy.sql
page life expectancy.sql
 
 
public permissions.sql
public permissions.sql
 
 
rebuild SSRS RSExecRole permissions.sql
rebuild SSRS RSExecRole permissions.sql
 
 
record_dm_io_virtual_file_stats.sql
record_dm_io_virtual_file_stats.sql
 
 
refresh view metadata.sql
refresh view metadata.sql
 
 
reports catalog metadata.sql
reports catalog metadata.sql
 
 
restore 2.sql
restore 2.sql
 
 
script ssisdb env.sql
script ssisdb env.sql
 
 
services dmv.sql
services dmv.sql
 
 
sessions and requests blocking chain.jpg
sessions and requests blocking chain.jpg
 
 
sessions and requests table.sql
sessions and requests table.sql
 
 
sessions and requests.sql
sessions and requests.sql
 
 
sessions sql2000.sql
sessions sql2000.sql
 
 
size in memory.sql
size in memory.sql
 
 
size.sql
size.sql
 
 
sp_GetAGInformation.sql
sp_GetAGInformation.sql
 
 

Repository files navigation

sql-server-toolbox

SQL Server Toolbox

Getting Started

A loose assembly of files use for day-to-day administration, performance tuning, troubleshooting and investigation of Microsoft SQL Server databases.

Prerequisites

Many scripts have alternative versions for backwards compatibility with SQL Servers prior to SQL Server 2012, most scripts developed for SQL Server 2012 or higher, many with comments indicating features added in 2014 or 2016. Execution intended with SSMS/VSCode without SQLCMD mode enabled.

Contributing

Suggestions/corrections welcome. Collaboration limited to internal SQLDBA team.

Authors

Acknowledgments

  • Code snippet source documented with URL where appropriate, if lacking, please notify us.

About

SQL Server Toolbox

www.sqltact.com/2012/07/sql-server-dba-tool-kit.html

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

1 fork
Report repository

Releases

No releases published

Packages

No packages published

Languages

  • PowerShell 100.0%