Skip to content
/ DBAToolKit Public

Scripts to help on manage a SQL Server environment

35 stars 27 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

vitortff/DBAToolKit

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

46 Commits
.vs
.vs
 
 
SQL Server Diagnostic Information Queries
SQL Server Diagnostic Information Queries
 
 
T-SQL Scripts
T-SQL Scripts
 
 
AddNewDBFile.sql
AddNewDBFile.sql
 
 
All Databases Index fragmentation.sql
All Databases Index fragmentation.sql
 
 
BackupInformation.sql
BackupInformation.sql
 
 
CPU_Top_Queries.sql
CPU_Top_Queries.sql
 
 
CPU_UsageHistory.sql
CPU_UsageHistory.sql
 
 
ChangeJobOwner.sql
ChangeJobOwner.sql
 
 
CheckAGHealth.sql
CheckAGHealth.sql
 
 
CheckAllDatabaseSize.sql
CheckAllDatabaseSize.sql
 
 
CheckServerPerformanceUsingTSQL.sql
CheckServerPerformanceUsingTSQL.sql
 
 
CheckTransactionsOnTLog.sql
CheckTransactionsOnTLog.sql
 
 
CheckingCursors.sql
CheckingCursors.sql
 
 
CollectConnectionDetailsFromServerList.sql
CollectConnectionDetailsFromServerList.sql
 
 
CompressionAnalysis.sql
CompressionAnalysis.sql
 
 
ConnectionInfoInRingBuffer.sql
ConnectionInfoInRingBuffer.sql
 
 
CreateIndexesFromMissingIndexes.sql
CreateIndexesFromMissingIndexes.sql
 
 
DMA_JsonFiles_Analysis.sql
DMA_JsonFiles_Analysis.sql
 
 
DatabaseGrowthList.sql
DatabaseGrowthList.sql
 
 
DatabaseMail_ScriptConfigurations.sql
DatabaseMail_ScriptConfigurations.sql
 
 
DeleteCreationForRelationedTables.sql
DeleteCreationForRelationedTables.sql
 
 
Diagnostics.sql
Diagnostics.sql
 
 
DiskUsage.sql
DiskUsage.sql
 
 
ExecSessions.sql
ExecSessions.sql
 
 
FastFileInitialization_Check.sql
FastFileInitialization_Check.sql
 
 
FindCriticalMessagesOnErrorLog.sql
FindCriticalMessagesOnErrorLog.sql
 
 
FindMissingIndexOnCache.sql
FindMissingIndexOnCache.sql
 
 
FindTriggers.sql
FindTriggers.sql
 
 
FindUnesedIndexes.sql
FindUnesedIndexes.sql
 
 
FindingMostExpensiveReportsOnReportingServices.sql
FindingMostExpensiveReportsOnReportingServices.sql
 
 
FixOprhanUsers.sql
FixOprhanUsers.sql
 
 
FullTextSearch.sql
FullTextSearch.sql
 
 
HeadBlocker.sql
HeadBlocker.sql
 
 
IO_Usage.sql
IO_Usage.sql
 
 
IndexAnalyse.sql
IndexAnalyse.sql
 
 
IndexDetailUsageFromExecutionPlan.sql
IndexDetailUsageFromExecutionPlan.sql
 
 
JobInfo.sql
JobInfo.sql
 
 
JobsInfo.sql
JobsInfo.sql
 
 
KillSessions.sql
KillSessions.sql
 
 
Kill_Inactive_Sessions.sql
Kill_Inactive_Sessions.sql
 
 
Kill_Users.sql
Kill_Users.sql
 
 
LOG_EXEC_DEPLOY.sql
LOG_EXEC_DEPLOY.sql
 
 
LastIndexesCreatedOnDatabase.sql
LastIndexesCreatedOnDatabase.sql
 
 
ListAllHeapTables.sql
ListAllHeapTables.sql
 
 
ListFailedLoginsDetails.sql
ListFailedLoginsDetails.sql
 
 
ListFileShrink.sql
ListFileShrink.sql
 
 
ListObjectDependencies.sql
ListObjectDependencies.sql
 
 
ListSQLServer_VersionDetails.sql
ListSQLServer_VersionDetails.sql
 
 
ListTableSize.sql
ListTableSize.sql
 
 
LockMonitor.sql
LockMonitor.sql
 
 
LogShippingInfo.sql
LogShippingInfo.sql
 
 
MemoryAnalysis.sql
MemoryAnalysis.sql
 
 
Mirror.sql
Mirror.sql
 
 
MirrorSuspend.sql
MirrorSuspend.sql
 
 
ModifyFileLocationForAllDatabases.sql
ModifyFileLocationForAllDatabases.sql
 
 
MostExpensiveStoredProceduresInCache.sql
MostExpensiveStoredProceduresInCache.sql
 
 
MoveResourceDB.sql
MoveResourceDB.sql
 
 
MoveTempDB.sql
MoveTempDB.sql
 
 
MoveUserDBFiles.sql
MoveUserDBFiles.sql
 
 
ObjectName.sql
ObjectName.sql
 
 
PATeVTRprepare.sql
PATeVTRprepare.sql
 
 
PartitionDetails.sql
PartitionDetails.sql
 
 
QueryConnectionsAndThreads.sql
QueryConnectionsAndThreads.sql
 
 
QueryMemoryUsage.sql
QueryMemoryUsage.sql
 
 
QueryStoreQueries.sql
QueryStoreQueries.sql
 
 
README.md
README.md
 
 
RecoveryStatus.sql
RecoveryStatus.sql
 
 
Replication.sql
Replication.sql
 
 
ReplicationIssues.sql
ReplicationIssues.sql
 
 
ResourceUse.sql
ResourceUse.sql
 
 
SQLQuery1.sql
SQLQuery1.sql
 
 
ScriptAll_IndexesCreatedOnDatabase.sql
ScriptAll_IndexesCreatedOnDatabase.sql
 
 
ScriptUsersPermissions.sql
ScriptUsersPermissions.sql
 
 
ShrinkCDC.sql
ShrinkCDC.sql
 
 
ShrinkLogTempDB.sql
ShrinkLogTempDB.sql
 
 
StoredProcedure_Info.sql
StoredProcedure_Info.sql
 
 
SystemHealth_ErrorReported_Count.sql
SystemHealth_ErrorReported_Count.sql
 
 
TEMPDB_Usage.sql
TEMPDB_Usage.sql
 
 
TrackPageSplits.sql
TrackPageSplits.sql
 
 
ViewPermissions.sql
ViewPermissions.sql
 
 
WaitStats.sql
WaitStats.sql
 
 
WhoandWhat.sql
WhoandWhat.sql
 
 
WhoandWhat2.sql
WhoandWhat2.sql
 
 

Repository files navigation

DBAToolKit

Scripts to help on manage a SQL Server environment

About

Scripts to help on manage a SQL Server environment

Resources

Readme
Activity

Stars

35 stars

Watchers

6 watching

Forks

27 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages