Skip to content

AkilDeloitte/DBA_Scripts

BranchesTags
 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

174 Commits
AG#:Update RegisterAllProvidersIP and HostRecordTTL in all AG Clusters.ps1
AG#:Update RegisterAllProvidersIP and HostRecordTTL in all AG Clusters.ps1
 
 
AlwaysON#: Always on Availability groups Status
AlwaysON#: Always on Availability groups Status
 
 
AlwaysON#: AlwaysON Failover status.sql
AlwaysON#: AlwaysON Failover status.sql
 
 
AlwaysON-Scrpits.sql
AlwaysON-Scrpits.sql
 
 
AlwaysOn-Latency Test.sql
AlwaysOn-Latency Test.sql
 
 
Azure SQL Database Diagnostic Information Queries.sql
Azure SQL Database Diagnostic Information Queries.sql
 
 
Azure SQL Database Resoruce Metrics.sql
Azure SQL Database Resoruce Metrics.sql
 
 
AzureSQL - Monitor tempdb usage.sql
AzureSQL - Monitor tempdb usage.sql
 
 
Backup#: Backup_Restore_Estimation.sql
Backup#: Backup_Restore_Estimation.sql
 
 
Backup#: Listing-when-full-differential-and-log-backups-of-all-databases-are-taken-in-sql-server.sql
Backup#: Listing-when-full-differential-and-log-backups-of-all-databases-are-taken-in-sql-server.sql
 
 
Backup#: TSQL to backup all user SQL Server databases at a time
Backup#: TSQL to backup all user SQL Server databases at a time
 
 
Balance CPU Cores Across NUMA Nodes.sql
Balance CPU Cores Across NUMA Nodes.sql
 
 
Balmukund#: Find Currently executing Queries, Blocking, Waits, Statement, Procedure, CPU.sql
Balmukund#: Find Currently executing Queries, Blocking, Waits, Statement, Procedure, CPU.sql
 
 
Best Practices Condensed Check.sql
Best Practices Condensed Check.sql
 
 
Blocking#: Monitoring-blocking-in-sql-server.sql
Blocking#: Monitoring-blocking-in-sql-server.sql
 
 
CPU#-High-CPU-usage issues in SQL Server.sql
CPU#-High-CPU-usage issues in SQL Server.sql
 
 
CostThreshold#: Plan_To_Increase_Cost_Threshold_For_Parallelism.sql
CostThreshold#: Plan_To_Increase_Cost_Threshold_For_Parallelism.sql
 
 
DB_Mirroring_EndPoint.sql
DB_Mirroring_EndPoint.sql
 
 
Daily_Usage_Scripts.sql
Daily_Usage_Scripts.sql
 
 
Database#: All DB's Heap_Tables.sql
Database#: All DB's Heap_Tables.sql
 
 
Database#: Database Design Best Practice Checks.sql
Database#: Database Design Best Practice Checks.sql
 
 
Database#: Foreign_Keys_Without_Corresponding_Indexes.sql
Database#: Foreign_Keys_Without_Corresponding_Indexes.sql
 
 
DeadLock#1: Monitoring Deadlock.sql
DeadLock#1: Monitoring Deadlock.sql
 
 
DeadLock_Details.sql
DeadLock_Details.sql
 
 
Finding an implicit type conversion.sql
Finding an implicit type conversion.sql
 
 
Get Job Output File Contents.sql
Get Job Output File Contents.sql
 
 
Health Check Scripts
Health Check Scripts
 
 
How To Check VLF Counts for All Databases in an Instance.sql
How To Check VLF Counts for All Databases in an Instance.sql
 
 
How many rows are progressed while doing operations like below from SSMS?
How many rows are progressed while doing operations like below from SSMS?
 
 
How_to_Find_Queries_Using_an_Index.sql
How_to_Find_Queries_Using_an_Index.sql
 
 
IFI#: Instant File Initialization.sql
IFI#: Instant File Initialization.sql
 
 
INDEX#: Index_Fragmentation.sql
INDEX#: Index_Fragmentation.sql
 
 
IO_Avg_IO_Stall.sql
IO_Avg_IO_Stall.sql
 
 
IO_Avg_IO_Stall_Per_DBFiles.sql
IO_Avg_IO_Stall_Per_DBFiles.sql
 
 
IO_Disk_latency.sql
IO_Disk_latency.sql
 
 
IO_Per_Database.sql
IO_Per_Database.sql
 
 
IO_Top10.sql
IO_Top10.sql
 
 
Index#: Redundant Indexes Detailed.sql
Index#: Redundant Indexes Detailed.sql
 
 
Index#: Unused indexes.sql
Index#: Unused indexes.sql
 
 
Index#: find duplicate indexes.sql
Index#: find duplicate indexes.sql
 
 
Index#:Online Index Rebuild and Resume by Default.sql
Index#:Online Index Rebuild and Resume by Default.sql
 
 
IndexFragmentation_Details.sql
IndexFragmentation_Details.sql
 
 
Index_Missing.sql
Index_Missing.sql
 
 
Index_More_Write_Than_Reads.sql
Index_More_Write_Than_Reads.sql
 
 
Index_Outdated.sl
Index_Outdated.sl
 
 
Index_Sizes.sql
Index_Sizes.sql
 
 
Index_Unused.sql
Index_Unused.sql
 
 
JOB#: Badly Configured SQL Agent Jobs.sql
JOB#: Badly Configured SQL Agent Jobs.sql
 
 
Job#: Orphaned SQL Agent Jobs.sql
Job#: Orphaned SQL Agent Jobs.sql
 
 
Job#:Monitoring SQL Server Jobs & its Schedules
Job#:Monitoring SQL Server Jobs & its Schedules
 
 
LOG#: High_VLF_Count_Multiversion.sql
LOG#: High_VLF_Count_Multiversion.sql
 
 
Last_Backup_Details.sql
Last_Backup_Details.sql
 
 
Last_restore_date.sql
Last_restore_date.sql
 
 
Linked#: Linked Server Vulnerability.sql
Linked#: Linked Server Vulnerability.sql
 
 
Locks#1: View Locking in Current Database.sql
Locks#1: View Locking in Current Database.sql
 
 
Log-Shipping: Usefull Scripts
Log-Shipping: Usefull Scripts
 
 
Log_Shipping_LSN_Missing.sql
Log_Shipping_LSN_Missing.sql
 
 
MAXDOP#: MaxDOP_Configuration_Check.sql
MAXDOP#: MaxDOP_Configuration_Check.sql
 
 
MAXDOP_recommendation.sql
MAXDOP_recommendation.sql
 
 
Memory#: Max Memory Recommendation.sql
Memory#: Max Memory Recommendation.sql
 
 
MemoryBuffer_Pool_Usage.sql
MemoryBuffer_Pool_Usage.sql
 
 
MemoryDB_Wise_Memory_Usage.sql
MemoryDB_Wise_Memory_Usage.sql
 
 
MemoryObject_Wise_Memory_Usage.sql
MemoryObject_Wise_Memory_Usage.sql
 
 
MemorySystem_Memory_Usage.sql
MemorySystem_Memory_Usage.sql
 
 
Monitor SQL AlwaysOn Health.sql
Monitor SQL AlwaysOn Health.sql
 
 
Non-SARGable Execution Plans.sql
Non-SARGable Execution Plans.sql
 
 
Partition #: Last Partition Not Empty.sql
Partition #: Last Partition Not Empty.sql
 
 
Perfmon Counters.xlsx
Perfmon Counters.xlsx
 
 
Port#; Find_SQL_TCP_Port.sql
Port#; Find_SQL_TCP_Port.sql
 
 
Query#:live_query_profiling.sql
Query#:live_query_profiling.sql
 
 
Query#How to see query history in SQL Server Management Studio
Query#How to see query history in SQL Server Management Studio
 
 
README.md
README.md
 
 
Refresh TDE.sql
Refresh TDE.sql
 
 
Replication_Scripts.sql
Replication_Scripts.sql
 
 
Restore#: How-to-get-a-sql-database-restore-history.sql
Restore#: How-to-get-a-sql-database-restore-history.sql
 
 
Restore_Database_Dynamic_SQL.sql
Restore_Database_Dynamic_SQL.sql
 
 
SHRINK: Incremental shrink data files in sql server
SHRINK: Incremental shrink data files in sql server
 
 
SQL Managed Instance Diagnostic Information Queries.sql
SQL Managed Instance Diagnostic Information Queries.sql
 
 
SQL Server Diagnostic Information Queries.sql
SQL Server Diagnostic Information Queries.sql
 
 
SQLServer_Memory_Information.sql
SQLServer_Memory_Information.sql
 
 
SSIS Catalog Clean-up.docx
SSIS Catalog Clean-up.docx
 
 
SSISDB_Catalog Database.docx
SSISDB_Catalog Database.docx
 
 
SSISDB_Scripts.docx
SSISDB_Scripts.docx
 
 
Security#: DB_Refresh_Scripts.sql
Security#: DB_Refresh_Scripts.sql
 
 
Security#: DB_Users_Script.sql
Security#: DB_Users_Script.sql
 
 
Security#: Invalid_owner_for_system_schema_role_or_database.sql
Security#: Invalid_owner_for_system_schema_role_or_database.sql
 
 
Security#: Script Out DB Permissions in case of DB Refresh.sql
Security#: Script Out DB Permissions in case of DB Refresh.sql
 
 
Security#: Transfer logins and passwords between instances of SQL Server.sql
Security#: Transfer logins and passwords between instances of SQL Server.sql
 
 
Stored Procedures using Table Variables.sql
Stored Procedures using Table Variables.sql
 
 
Table Audit.txt
Table Audit.txt
 
 
Table#: Seeing-table-sizes-in-sql-server.sql
Table#: Seeing-table-sizes-in-sql-server.sql
 
 
Table#:table to different filegroup.sql
Table#:table to different filegroup.sql
 
 
TempDB#: Script to Find and Monitoring TempDB Space Usage.sql
TempDB#: Script to Find and Monitoring TempDB Space Usage.sql
 
 
TempDB#: TempDB_File_moving.sql
TempDB#: TempDB_File_moving.sql
 
 
Update Statistics.sql
Update Statistics.sql
 
 
UpdateStats#: Outdated_Statistics.sql
UpdateStats#: Outdated_Statistics.sql
 
 
Use FILEPROPERTY to find free space in all the database
Use FILEPROPERTY to find free space in all the database
 
 
Very-Large-Databases-Optimization.sql
Very-Large-Databases-Optimization.sql
 
 
Wait_Statistics.sql
Wait_Statistics.sql
 
 
Who owns that #temp table.sql
Who owns that #temp table.sql
 
 

Repository files navigation

DBA_Scripts

👋 Hi, We are @AzureSQLChamp

👀 We are giving training on MSDBA+Azure SQL+Advance Performance Tuning

🌱 We are currently on the path of Learning Data Engineering ADF, Data Bricks, Data Lake, Synanpse

💞️ Soon we will add Data Engineering technology in our training

📫 Reach us on Call/WhatsApp "+91 9390031522"&"+91 9686854898" and E-Mail: azuresqldatamastertraining@gmail.com

Our YouTube Channel Link https://www.youtube.com/c/AzureSQLChamp

About

ALL SQLDB scripts

Resources

Readme
Activity

Stars

0 stars

Watchers

0 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages

  • PLpgSQL 54.8%
  • TSQL 45.0%
  • Other 0.2%