| route-pattern | /:user_id/:repository |
| route-controller | files |
| route-action | disambiguate |
| fetch-nonce | v2:3d90cf0b-2804-a6ca-e19d-b935eeaf4329 |
| current-catalog-service-hash | f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb |
| request-id | 9C62:C7D69:39F743:4D86FF:6A614EC6 |
| html-safe-nonce | f9c6cc508f7d501b84f827d6addef07b0311e8470a3dab0d3b31e8b12c1df730 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5QzYyOkM3RDY5OjM5Rjc0Mzo0RDg2RkY6NkE2MTRFQzYiLCJ2aXNpdG9yX2lkIjoiNTEzNzcwMzQxMjQxNjIwNDQ4NiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 5a76931622ee15b0b015c4cc9a3a705daabe7881aeefeb283402f4ec43520e27 |
| hovercard-subject-tag | repository:805056860 |
| github-keyboard-shortcuts | repository,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | // |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/fkostya/DBA_Scripts |
| twitter:image | https://opengraph.githubassets.com/2ff8f1b1e404b6a3a7d41fbf75e80b45e1b2560860dcfae633987b77d069a118/fkostya/DBA_Scripts |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/2ff8f1b1e404b6a3a7d41fbf75e80b45e1b2560860dcfae633987b77d069a118/fkostya/DBA_Scripts |
| og:image:alt | Contribute to fkostya/DBA_Scripts development by creating an account on GitHub. |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | 35b919fdb8e6752d2ed95a144e761ca5e924557563e2ed0a5ebf6c4430cdeeb6 |
| turbo-cache-control | no-cache |
| go-import | github.com/fkostya/DBA_Scripts git https://github.com/fkostya/DBA_Scripts.git |
| octolytics-dimension-user_id | 64334685 |
| octolytics-dimension-user_login | fkostya |
| octolytics-dimension-repository_id | 805056860 |
| octolytics-dimension-repository_nwo | fkostya/DBA_Scripts |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | true |
| octolytics-dimension-repository_parent_id | 601536180 |
| octolytics-dimension-repository_parent_nwo | AzureSQLChamp/DBA_Scripts |
| octolytics-dimension-repository_network_root_id | 601536180 |
| octolytics-dimension-repository_network_root_nwo | AzureSQLChamp/DBA_Scripts |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 1e22b08b60ccb67c3791f565bed248565260e611 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| Skip to content | https://github.com/fkostya/DBA_Scripts#start-of-content |
|
| https://github.com/ |
|
Sign in
| https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffkostya%2FDBA_Scripts |
| GitHub CopilotWrite better code with AI | https://github.com/features/copilot |
| GitHub Copilot appDirect agents from issue to merge | https://github.com/features/ai/github-app |
| MCP RegistryNewIntegrate external tools | https://github.com/mcp |
| ActionsAutomate any workflow | https://github.com/features/actions |
| CodespacesInstant dev environments | https://github.com/features/codespaces |
| IssuesPlan and track work | https://github.com/features/issues |
| Code ReviewManage code changes | https://github.com/features/code-review |
| Code QualityEnforce quality at merge | https://github.com/features/code-quality |
| GitHub Advanced SecurityFind and fix vulnerabilities | https://github.com/security/advanced-security |
| Code securitySecure your code as you build | https://github.com/security/advanced-security/code-security |
| Secret protectionStop leaks before they start | https://github.com/security/advanced-security/secret-protection |
| Why GitHub | https://github.com/why-github |
| Documentation | https://docs.github.com |
| Blog | https://github.blog |
| Changelog | https://github.blog/changelog |
| Marketplace | https://github.com/marketplace |
| View all features | https://github.com/features |
| Enterprises | https://github.com/enterprise |
| Small and medium teams | https://github.com/team |
| Startups | https://github.com/enterprise/startups |
| Nonprofits | https://github.com/solutions/industry/nonprofits |
| App Modernization | https://github.com/solutions/use-case/app-modernization |
| DevSecOps | https://github.com/solutions/use-case/devsecops |
| DevOps | https://github.com/solutions/use-case/devops |
| CI/CD | https://github.com/solutions/use-case/ci-cd |
| View all use cases | https://github.com/solutions/use-case |
| Healthcare | https://github.com/solutions/industry/healthcare |
| Financial services | https://github.com/solutions/industry/financial-services |
| Manufacturing | https://github.com/solutions/industry/manufacturing |
| Government | https://github.com/solutions/industry/government |
| View all industries | https://github.com/solutions/industry |
| View all solutions | https://github.com/solutions |
| AI | https://github.com/resources/articles?topic=ai |
| Software Development | https://github.com/resources/articles?topic=software-development |
| DevOps | https://github.com/resources/articles?topic=devops |
| Security | https://github.com/resources/articles?topic=security |
| View all topics | https://github.com/resources/articles |
| Customer stories | https://github.com/customer-stories |
| Events & webinars | https://github.com/resources/events |
| Ebooks & reports | https://github.com/resources/whitepapers |
| Business insights | https://github.com/solutions/executive-insights |
| GitHub Skills | https://skills.github.com |
| Documentation | https://docs.github.com |
| Customer support | https://support.github.com |
| Community forum | https://github.com/orgs/community/discussions |
| Trust center | https://github.com/trust-center |
| Partners | https://github.com/partners |
| View all resources | https://github.com/resources |
| GitHub SponsorsFund open source developers | https://github.com/open-source/sponsors |
| Security Lab | https://securitylab.github.com |
| Maintainer Community | https://maintainers.github.com |
| Accelerator | https://github.com/open-source/accelerator |
| GitHub Stars | https://stars.github.com |
| Archive Program | https://archiveprogram.github.com |
| Topics | https://github.com/topics |
| Trending | https://github.com/trending |
| Collections | https://github.com/collections |
| Enterprise platformAI-powered developer platform | https://github.com/enterprise |
| GitHub Advanced SecurityEnterprise-grade security features | https://github.com/security/advanced-security |
| Copilot for BusinessEnterprise-grade AI features | https://github.com/features/copilot/copilot-business |
| Premium SupportEnterprise-grade 24/7 support | https://github.com/enterprise/premium-support |
| Pricing | https://github.com/pricing |
| Search syntax tips | https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax |
| documentation | https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax |
|
Sign in
| https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffkostya%2FDBA_Scripts |
|
Sign up
| https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=fkostya%2FDBA_Scripts |
| Reload | https://github.com/fkostya/DBA_Scripts |
| Reload | https://github.com/fkostya/DBA_Scripts |
| Reload | https://github.com/fkostya/DBA_Scripts |
|
fkostya
| https://github.com/fkostya |
| DBA_Scripts | https://github.com/fkostya/DBA_Scripts |
| AzureSQLChamp/DBA_Scripts | https://github.com/AzureSQLChamp/DBA_Scripts |
|
Notifications
| https://github.com/login?return_to=%2Ffkostya%2FDBA_Scripts |
|
Fork
0
| https://github.com/login?return_to=%2Ffkostya%2FDBA_Scripts |
|
Star
0
| https://github.com/login?return_to=%2Ffkostya%2FDBA_Scripts |
|
Code
| https://github.com/fkostya/DBA_Scripts |
|
Pull requests
0
| https://github.com/fkostya/DBA_Scripts/pulls |
|
Actions
| https://github.com/fkostya/DBA_Scripts/actions |
|
Projects
| https://github.com/fkostya/DBA_Scripts/projects |
|
Security and quality
0
| https://github.com/fkostya/DBA_Scripts/security |
|
Insights
| https://github.com/fkostya/DBA_Scripts/pulse |
|
Code
| https://github.com/fkostya/DBA_Scripts |
|
Pull requests
| https://github.com/fkostya/DBA_Scripts/pulls |
|
Actions
| https://github.com/fkostya/DBA_Scripts/actions |
|
Projects
| https://github.com/fkostya/DBA_Scripts/projects |
|
Security and quality
| https://github.com/fkostya/DBA_Scripts/security |
|
Insights
| https://github.com/fkostya/DBA_Scripts/pulse |
| https://github.com/fkostya/DBA_Scripts |
| Branches | https://github.com/fkostya/DBA_Scripts/branches |
| Tags | https://github.com/fkostya/DBA_Scripts/tags |
| https://github.com/fkostya/DBA_Scripts/branches |
| https://github.com/fkostya/DBA_Scripts/tags |
| 199 Commits | https://github.com/fkostya/DBA_Scripts/commits/main/ |
| https://github.com/fkostya/DBA_Scripts/commits/main/ |
| AG#:Update RegisterAllProvidersIP and HostRecordTTL in all AG Clusters.ps1 | https://github.com/fkostya/DBA_Scripts/blob/main/AG%23%3AUpdate%20RegisterAllProvidersIP%20and%20HostRecordTTL%20in%20all%20AG%20Clusters.ps1 |
| AG#:Update RegisterAllProvidersIP and HostRecordTTL in all AG Clusters.ps1 | https://github.com/fkostya/DBA_Scripts/blob/main/AG%23%3AUpdate%20RegisterAllProvidersIP%20and%20HostRecordTTL%20in%20all%20AG%20Clusters.ps1 |
| AlwaysON#: Always on Availability groups Status | https://github.com/fkostya/DBA_Scripts/blob/main/AlwaysON%23%3A%20Always%20on%20Availability%20groups%20Status |
| AlwaysON#: Always on Availability groups Status | https://github.com/fkostya/DBA_Scripts/blob/main/AlwaysON%23%3A%20Always%20on%20Availability%20groups%20Status |
| AlwaysON#: AlwaysON Failover status.sql | https://github.com/fkostya/DBA_Scripts/blob/main/AlwaysON%23%3A%20AlwaysON%20Failover%20status.sql |
| AlwaysON#: AlwaysON Failover status.sql | https://github.com/fkostya/DBA_Scripts/blob/main/AlwaysON%23%3A%20AlwaysON%20Failover%20status.sql |
| AlwaysON#: Login Synchronization Across Always On Availability group Replicas | https://github.com/fkostya/DBA_Scripts/blob/main/AlwaysON%23%3A%20Login%20Synchronization%20Across%20Always%20On%20Availability%20group%20Replicas |
| AlwaysON#: Login Synchronization Across Always On Availability group Replicas | https://github.com/fkostya/DBA_Scripts/blob/main/AlwaysON%23%3A%20Login%20Synchronization%20Across%20Always%20On%20Availability%20group%20Replicas |
| AlwaysON-Scrpits.sql | https://github.com/fkostya/DBA_Scripts/blob/main/AlwaysON-Scrpits.sql |
| AlwaysON-Scrpits.sql | https://github.com/fkostya/DBA_Scripts/blob/main/AlwaysON-Scrpits.sql |
| AlwaysOn-Latency Test.sql | https://github.com/fkostya/DBA_Scripts/blob/main/AlwaysOn-Latency%20Test.sql |
| AlwaysOn-Latency Test.sql | https://github.com/fkostya/DBA_Scripts/blob/main/AlwaysOn-Latency%20Test.sql |
| Azure SQL Database Diagnostic Information Queries.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Azure%20SQL%20Database%20Diagnostic%20Information%20Queries.sql |
| Azure SQL Database Diagnostic Information Queries.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Azure%20SQL%20Database%20Diagnostic%20Information%20Queries.sql |
| Azure SQL Database Resoruce Metrics.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Azure%20SQL%20Database%20Resoruce%20Metrics.sql |
| Azure SQL Database Resoruce Metrics.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Azure%20SQL%20Database%20Resoruce%20Metrics.sql |
| AzureSQL - Monitor tempdb usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/AzureSQL%20-%20Monitor%20tempdb%20usage.sql |
| AzureSQL - Monitor tempdb usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/AzureSQL%20-%20Monitor%20tempdb%20usage.sql |
| Backup#: Backup_Restore_Estimation.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Backup%23%3A%20Backup_Restore_Estimation.sql |
| Backup#: Backup_Restore_Estimation.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Backup%23%3A%20Backup_Restore_Estimation.sql |
| Backup#: Listing-when-full-differential-and-log-backups-of-all-databases-are-taken-in-sql-server.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Backup%23%3A%20Listing-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 | https://github.com/fkostya/DBA_Scripts/blob/main/Backup%23%3A%20Listing-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 | https://github.com/fkostya/DBA_Scripts/blob/main/Backup%23%3A%20TSQL%20to%20backup%20all%20user%20SQL%20Server%20databases%20at%20a%20time |
| Backup#: TSQL to backup all user SQL Server databases at a time | https://github.com/fkostya/DBA_Scripts/blob/main/Backup%23%3A%20TSQL%20to%20backup%20all%20user%20SQL%20Server%20databases%20at%20a%20time |
| Balance CPU Cores Across NUMA Nodes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Balance%20CPU%20Cores%20Across%20NUMA%20Nodes.sql |
| Balance CPU Cores Across NUMA Nodes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Balance%20CPU%20Cores%20Across%20NUMA%20Nodes.sql |
| Balmukund#: Find Currently executing Queries, Blocking, Waits, Statement, Procedure, CPU.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Balmukund%23%3A%20Find%20Currently%20executing%20Queries%2C%20Blocking%2C%20Waits%2C%20Statement%2C%20Procedure%2C%20CPU.sql |
| Balmukund#: Find Currently executing Queries, Blocking, Waits, Statement, Procedure, CPU.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Balmukund%23%3A%20Find%20Currently%20executing%20Queries%2C%20Blocking%2C%20Waits%2C%20Statement%2C%20Procedure%2C%20CPU.sql |
| Best Practices Condensed Check.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Best%20Practices%20Condensed%20Check.sql |
| Best Practices Condensed Check.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Best%20Practices%20Condensed%20Check.sql |
| Blocking#: Monitoring-blocking-in-sql-server.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Blocking%23%3A%20Monitoring-blocking-in-sql-server.sql |
| Blocking#: Monitoring-blocking-in-sql-server.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Blocking%23%3A%20Monitoring-blocking-in-sql-server.sql |
| CPU#-High-CPU-usage issues in SQL Server.sql | https://github.com/fkostya/DBA_Scripts/blob/main/CPU%23-High-CPU-usage%20issues%20in%20SQL%20Server.sql |
| CPU#-High-CPU-usage issues in SQL Server.sql | https://github.com/fkostya/DBA_Scripts/blob/main/CPU%23-High-CPU-usage%20issues%20in%20SQL%20Server.sql |
| CPU#: High CPU usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/CPU%23%3A%20High%20CPU%20usage.sql |
| CPU#: High CPU usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/CPU%23%3A%20High%20CPU%20usage.sql |
| CostThreshold#: Plan_To_Increase_Cost_Threshold_For_Parallelism.sql | https://github.com/fkostya/DBA_Scripts/blob/main/CostThreshold%23%3A%20Plan_To_Increase_Cost_Threshold_For_Parallelism.sql |
| CostThreshold#: Plan_To_Increase_Cost_Threshold_For_Parallelism.sql | https://github.com/fkostya/DBA_Scripts/blob/main/CostThreshold%23%3A%20Plan_To_Increase_Cost_Threshold_For_Parallelism.sql |
| Create & Refresh TDE.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Create%20%26%20Refresh%20TDE.sql |
| Create & Refresh TDE.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Create%20%26%20Refresh%20TDE.sql |
| DBCC CHECKDB WITH ESTIMATEONLY.sql | https://github.com/fkostya/DBA_Scripts/blob/main/DBCC%20CHECKDB%20WITH%20ESTIMATEONLY.sql |
| DBCC CHECKDB WITH ESTIMATEONLY.sql | https://github.com/fkostya/DBA_Scripts/blob/main/DBCC%20CHECKDB%20WITH%20ESTIMATEONLY.sql |
| DB_Mirroring_EndPoint.sql | https://github.com/fkostya/DBA_Scripts/blob/main/DB_Mirroring_EndPoint.sql |
| DB_Mirroring_EndPoint.sql | https://github.com/fkostya/DBA_Scripts/blob/main/DB_Mirroring_EndPoint.sql |
| Daily_Usage_Scripts.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Daily_Usage_Scripts.sql |
| Daily_Usage_Scripts.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Daily_Usage_Scripts.sql |
| Database#: All DB's Heap_Tables.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Database%23%3A%20All%20DB's%20Heap_Tables.sql |
| Database#: All DB's Heap_Tables.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Database%23%3A%20All%20DB's%20Heap_Tables.sql |
| Database#: Database Design Best Practice Checks.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Database%23%3A%20Database%20Design%20Best%20Practice%20Checks.sql |
| Database#: Database Design Best Practice Checks.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Database%23%3A%20Database%20Design%20Best%20Practice%20Checks.sql |
| Database#: Database usage Info Report.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Database%23%3A%20Database%20usage%20Info%20Report.sql |
| Database#: Database usage Info Report.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Database%23%3A%20Database%20usage%20Info%20Report.sql |
| Database#: Foreign_Keys_Without_Corresponding_Indexes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Database%23%3A%20Foreign_Keys_Without_Corresponding_Indexes.sql |
| Database#: Foreign_Keys_Without_Corresponding_Indexes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Database%23%3A%20Foreign_Keys_Without_Corresponding_Indexes.sql |
| DeadLock#1: Monitoring Deadlock.sql | https://github.com/fkostya/DBA_Scripts/blob/main/DeadLock%231%3A%20Monitoring%20Deadlock.sql |
| DeadLock#1: Monitoring Deadlock.sql | https://github.com/fkostya/DBA_Scripts/blob/main/DeadLock%231%3A%20Monitoring%20Deadlock.sql |
| DeadLock_Details.sql | https://github.com/fkostya/DBA_Scripts/blob/main/DeadLock_Details.sql |
| DeadLock_Details.sql | https://github.com/fkostya/DBA_Scripts/blob/main/DeadLock_Details.sql |
| Drive Usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Drive%20Usage.sql |
| Drive Usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Drive%20Usage.sql |
| Find Overlapping Indexes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Find%20Overlapping%20Indexes.sql |
| Find Overlapping Indexes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Find%20Overlapping%20Indexes.sql |
| Finding an implicit type conversion.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Finding%20an%20implicit%20type%20conversion.sql |
| Finding an implicit type conversion.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Finding%20an%20implicit%20type%20conversion.sql |
| Get Job Output File Contents.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Get%20Job%20Output%20File%20Contents.sql |
| Get Job Output File Contents.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Get%20Job%20Output%20File%20Contents.sql |
| Health Check Scripts | https://github.com/fkostya/DBA_Scripts/blob/main/Health%20Check%20Scripts |
| Health Check Scripts | https://github.com/fkostya/DBA_Scripts/blob/main/Health%20Check%20Scripts |
| How To Check VLF Counts for All Databases in an Instance.sql | https://github.com/fkostya/DBA_Scripts/blob/main/How%20To%20Check%20VLF%20Counts%20for%20All%20Databases%20in%20an%20Instance.sql |
| How To Check VLF Counts for All Databases in an Instance.sql | https://github.com/fkostya/DBA_Scripts/blob/main/How%20To%20Check%20VLF%20Counts%20for%20All%20Databases%20in%20an%20Instance.sql |
| How many rows are progressed while doing operations like below from SSMS? | https://github.com/fkostya/DBA_Scripts/blob/main/How%20many%20rows%20are%20progressed%20while%20doing%20operations%20like%20below%20from%20SSMS%3F |
| How many rows are progressed while doing operations like below from SSMS? | https://github.com/fkostya/DBA_Scripts/blob/main/How%20many%20rows%20are%20progressed%20while%20doing%20operations%20like%20below%20from%20SSMS%3F |
| How_to_Find_Queries_Using_an_Index.sql | https://github.com/fkostya/DBA_Scripts/blob/main/How_to_Find_Queries_Using_an_Index.sql |
| How_to_Find_Queries_Using_an_Index.sql | https://github.com/fkostya/DBA_Scripts/blob/main/How_to_Find_Queries_Using_an_Index.sql |
| IFI#: Instant File Initialization.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IFI%23%3A%20Instant%20File%20Initialization.sql |
| IFI#: Instant File Initialization.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IFI%23%3A%20Instant%20File%20Initialization.sql |
| INDEX#: Index_Fragmentation.sql | https://github.com/fkostya/DBA_Scripts/blob/main/INDEX%23%3A%20Index_Fragmentation.sql |
| INDEX#: Index_Fragmentation.sql | https://github.com/fkostya/DBA_Scripts/blob/main/INDEX%23%3A%20Index_Fragmentation.sql |
| IO_Avg_IO_Stall.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IO_Avg_IO_Stall.sql |
| IO_Avg_IO_Stall.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IO_Avg_IO_Stall.sql |
| IO_Avg_IO_Stall_Per_DBFiles.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IO_Avg_IO_Stall_Per_DBFiles.sql |
| IO_Avg_IO_Stall_Per_DBFiles.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IO_Avg_IO_Stall_Per_DBFiles.sql |
| IO_Disk_latency.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IO_Disk_latency.sql |
| IO_Disk_latency.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IO_Disk_latency.sql |
| IO_Per_Database.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IO_Per_Database.sql |
| IO_Per_Database.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IO_Per_Database.sql |
| IO_Top10.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IO_Top10.sql |
| IO_Top10.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IO_Top10.sql |
| Index Metadata.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index%20Metadata.sql |
| Index Metadata.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index%20Metadata.sql |
| Index#: Redundant Indexes Detailed.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index%23%3A%20Redundant%20Indexes%20Detailed.sql |
| Index#: Redundant Indexes Detailed.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index%23%3A%20Redundant%20Indexes%20Detailed.sql |
| Index#: Unused indexes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index%23%3A%20Unused%20indexes.sql |
| Index#: Unused indexes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index%23%3A%20Unused%20indexes.sql |
| Index#: find duplicate indexes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index%23%3A%20find%20duplicate%20indexes.sql |
| Index#: find duplicate indexes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index%23%3A%20find%20duplicate%20indexes.sql |
| Index#:Online Index Rebuild and Resume by Default.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index%23%3AOnline%20Index%20Rebuild%20and%20Resume%20by%20Default.sql |
| Index#:Online Index Rebuild and Resume by Default.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index%23%3AOnline%20Index%20Rebuild%20and%20Resume%20by%20Default.sql |
| IndexFragmentation_Details.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IndexFragmentation_Details.sql |
| IndexFragmentation_Details.sql | https://github.com/fkostya/DBA_Scripts/blob/main/IndexFragmentation_Details.sql |
| Index_Missing.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index_Missing.sql |
| Index_Missing.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index_Missing.sql |
| Index_More_Write_Than_Reads.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index_More_Write_Than_Reads.sql |
| Index_More_Write_Than_Reads.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index_More_Write_Than_Reads.sql |
| Index_Outdated.sl | https://github.com/fkostya/DBA_Scripts/blob/main/Index_Outdated.sl |
| Index_Outdated.sl | https://github.com/fkostya/DBA_Scripts/blob/main/Index_Outdated.sl |
| Index_Sizes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index_Sizes.sql |
| Index_Sizes.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index_Sizes.sql |
| Index_Unused.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index_Unused.sql |
| Index_Unused.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Index_Unused.sql |
| JOB#: Badly Configured SQL Agent Jobs.sql | https://github.com/fkostya/DBA_Scripts/blob/main/JOB%23%3A%20Badly%20Configured%20SQL%20Agent%20Jobs.sql |
| JOB#: Badly Configured SQL Agent Jobs.sql | https://github.com/fkostya/DBA_Scripts/blob/main/JOB%23%3A%20Badly%20Configured%20SQL%20Agent%20Jobs.sql |
| Job#: Orphaned SQL Agent Jobs.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Job%23%3A%20Orphaned%20SQL%20Agent%20Jobs.sql |
| Job#: Orphaned SQL Agent Jobs.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Job%23%3A%20Orphaned%20SQL%20Agent%20Jobs.sql |
| Job#:Monitoring SQL Server Jobs & its Schedules | https://github.com/fkostya/DBA_Scripts/blob/main/Job%23%3AMonitoring%20SQL%20Server%20Jobs%20%26%20its%20Schedules |
| Job#:Monitoring SQL Server Jobs & its Schedules | https://github.com/fkostya/DBA_Scripts/blob/main/Job%23%3AMonitoring%20SQL%20Server%20Jobs%20%26%20its%20Schedules |
| LOG#: High_VLF_Count_Multiversion.sql | https://github.com/fkostya/DBA_Scripts/blob/main/LOG%23%3A%20High_VLF_Count_Multiversion.sql |
| LOG#: High_VLF_Count_Multiversion.sql | https://github.com/fkostya/DBA_Scripts/blob/main/LOG%23%3A%20High_VLF_Count_Multiversion.sql |
| Last_Backup_Details.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Last_Backup_Details.sql |
| Last_Backup_Details.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Last_Backup_Details.sql |
| Last_restore_date.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Last_restore_date.sql |
| Last_restore_date.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Last_restore_date.sql |
| Linked#: Linked Server Vulnerability.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Linked%23%3A%20Linked%20Server%20Vulnerability.sql |
| Linked#: Linked Server Vulnerability.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Linked%23%3A%20Linked%20Server%20Vulnerability.sql |
| Locks#1: View Locking in Current Database.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Locks%231%3A%20View%20Locking%20in%20Current%20Database.sql |
| Locks#1: View Locking in Current Database.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Locks%231%3A%20View%20Locking%20in%20Current%20Database.sql |
| Log-Shipping: Usefull Scripts | https://github.com/fkostya/DBA_Scripts/blob/main/Log-Shipping%3A%20Usefull%20Scripts |
| Log-Shipping: Usefull Scripts | https://github.com/fkostya/DBA_Scripts/blob/main/Log-Shipping%3A%20Usefull%20Scripts |
| Log_Shipping_LSN_Missing.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Log_Shipping_LSN_Missing.sql |
| Log_Shipping_LSN_Missing.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Log_Shipping_LSN_Missing.sql |
| MAXDOP#: MaxDOP_Configuration_Check.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MAXDOP%23%3A%20MaxDOP_Configuration_Check.sql |
| MAXDOP#: MaxDOP_Configuration_Check.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MAXDOP%23%3A%20MaxDOP_Configuration_Check.sql |
| MAXDOP_recommendation.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MAXDOP_recommendation.sql |
| MAXDOP_recommendation.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MAXDOP_recommendation.sql |
| Memory#: Max Memory Recommendation.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Memory%23%3A%20Max%20Memory%20Recommendation.sql |
| Memory#: Max Memory Recommendation.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Memory%23%3A%20Max%20Memory%20Recommendation.sql |
| MemoryBuffer_Pool_Usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MemoryBuffer_Pool_Usage.sql |
| MemoryBuffer_Pool_Usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MemoryBuffer_Pool_Usage.sql |
| MemoryDB_Wise_Memory_Usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MemoryDB_Wise_Memory_Usage.sql |
| MemoryDB_Wise_Memory_Usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MemoryDB_Wise_Memory_Usage.sql |
| MemoryObject_Wise_Memory_Usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MemoryObject_Wise_Memory_Usage.sql |
| MemoryObject_Wise_Memory_Usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MemoryObject_Wise_Memory_Usage.sql |
| MemorySystem_Memory_Usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MemorySystem_Memory_Usage.sql |
| MemorySystem_Memory_Usage.sql | https://github.com/fkostya/DBA_Scripts/blob/main/MemorySystem_Memory_Usage.sql |
| Monitor SQL AlwaysOn Health.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Monitor%20SQL%20AlwaysOn%20Health.sql |
| Monitor SQL AlwaysOn Health.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Monitor%20SQL%20AlwaysOn%20Health.sql |
| Non-SARGable Execution Plans.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Non-SARGable%20Execution%20Plans.sql |
| Non-SARGable Execution Plans.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Non-SARGable%20Execution%20Plans.sql |
| Orphaned User Fix in SQL Server | https://github.com/fkostya/DBA_Scripts/blob/main/Orphaned%20User%20Fix%20in%20SQL%20Server |
| Orphaned User Fix in SQL Server | https://github.com/fkostya/DBA_Scripts/blob/main/Orphaned%20User%20Fix%20in%20SQL%20Server |
| Partition #: Last Partition Not Empty.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Partition%20%23%3A%20Last%20Partition%20Not%20Empty.sql |
| Partition #: Last Partition Not Empty.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Partition%20%23%3A%20Last%20Partition%20Not%20Empty.sql |
| Perfmon Counters.xlsx | https://github.com/fkostya/DBA_Scripts/blob/main/Perfmon%20Counters.xlsx |
| Perfmon Counters.xlsx | https://github.com/fkostya/DBA_Scripts/blob/main/Perfmon%20Counters.xlsx |
| Port#; Find_SQL_TCP_Port.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Port%23%3B%20Find_SQL_TCP_Port.sql |
| Port#; Find_SQL_TCP_Port.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Port%23%3B%20Find_SQL_TCP_Port.sql |
| Query#:live_query_profiling.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Query%23%3Alive_query_profiling.sql |
| Query#:live_query_profiling.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Query%23%3Alive_query_profiling.sql |
| Query#How to see query history in SQL Server Management Studio | https://github.com/fkostya/DBA_Scripts/blob/main/Query%23How%20to%20see%20query%20history%20in%20SQL%20Server%20Management%20Studio |
| Query#How to see query history in SQL Server Management Studio | https://github.com/fkostya/DBA_Scripts/blob/main/Query%23How%20to%20see%20query%20history%20in%20SQL%20Server%20Management%20Studio |
| README.md | https://github.com/fkostya/DBA_Scripts/blob/main/README.md |
| README.md | https://github.com/fkostya/DBA_Scripts/blob/main/README.md |
| Replication Details | https://github.com/fkostya/DBA_Scripts/blob/main/Replication%20Details |
| Replication Details | https://github.com/fkostya/DBA_Scripts/blob/main/Replication%20Details |
| Replication: Latency usefull Queries.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Replication%3A%20Latency%20usefull%20Queries.sql |
| Replication: Latency usefull Queries.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Replication%3A%20Latency%20usefull%20Queries.sql |
| Replication: Latency usefull query-2.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Replication%3A%20Latency%20usefull%20query-2.sql |
| Replication: Latency usefull query-2.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Replication%3A%20Latency%20usefull%20query-2.sql |
| Replication: Script Replication Topology | https://github.com/fkostya/DBA_Scripts/blob/main/Replication%3A%20Script%20Replication%20Topology |
| Replication: Script Replication Topology | https://github.com/fkostya/DBA_Scripts/blob/main/Replication%3A%20Script%20Replication%20Topology |
| Replication_Scripts.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Replication_Scripts.sql |
| Replication_Scripts.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Replication_Scripts.sql |
| Restore#: How-to-get-a-sql-database-restore-history.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Restore%23%3A%20How-to-get-a-sql-database-restore-history.sql |
| Restore#: How-to-get-a-sql-database-restore-history.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Restore%23%3A%20How-to-get-a-sql-database-restore-history.sql |
| Restore_Database_Dynamic_SQL.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Restore_Database_Dynamic_SQL.sql |
| Restore_Database_Dynamic_SQL.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Restore_Database_Dynamic_SQL.sql |
| SHRINK: Incremental shrink data files in sql server | https://github.com/fkostya/DBA_Scripts/blob/main/SHRINK%3A%20%20Incremental%20shrink%20data%20files%20in%20sql%20server |
| SHRINK: Incremental shrink data files in sql server | https://github.com/fkostya/DBA_Scripts/blob/main/SHRINK%3A%20%20Incremental%20shrink%20data%20files%20in%20sql%20server |
| SQL Agent Job Schedules.sql | https://github.com/fkostya/DBA_Scripts/blob/main/SQL%20Agent%20Job%20Schedules.sql |
| SQL Agent Job Schedules.sql | https://github.com/fkostya/DBA_Scripts/blob/main/SQL%20Agent%20Job%20Schedules.sql |
| SQL Managed Instance Diagnostic Information Queries.sql | https://github.com/fkostya/DBA_Scripts/blob/main/SQL%20Managed%20Instance%20Diagnostic%20Information%20Queries.sql |
| SQL Managed Instance Diagnostic Information Queries.sql | https://github.com/fkostya/DBA_Scripts/blob/main/SQL%20Managed%20Instance%20Diagnostic%20Information%20Queries.sql |
| SQL Server Diagnostic Information Queries.sql | https://github.com/fkostya/DBA_Scripts/blob/main/SQL%20Server%20Diagnostic%20Information%20Queries.sql |
| SQL Server Diagnostic Information Queries.sql | https://github.com/fkostya/DBA_Scripts/blob/main/SQL%20Server%20Diagnostic%20Information%20Queries.sql |
| SQLServer_Memory_Information.sql | https://github.com/fkostya/DBA_Scripts/blob/main/SQLServer_Memory_Information.sql |
| SQLServer_Memory_Information.sql | https://github.com/fkostya/DBA_Scripts/blob/main/SQLServer_Memory_Information.sql |
| SSIS Catalog Clean-up.docx | https://github.com/fkostya/DBA_Scripts/blob/main/SSIS%20Catalog%20Clean-up.docx |
| SSIS Catalog Clean-up.docx | https://github.com/fkostya/DBA_Scripts/blob/main/SSIS%20Catalog%20Clean-up.docx |
| SSISDB_Catalog Database.docx | https://github.com/fkostya/DBA_Scripts/blob/main/SSISDB_Catalog%20Database.docx |
| SSISDB_Catalog Database.docx | https://github.com/fkostya/DBA_Scripts/blob/main/SSISDB_Catalog%20Database.docx |
| SSISDB_Scripts.docx | https://github.com/fkostya/DBA_Scripts/blob/main/SSISDB_Scripts.docx |
| SSISDB_Scripts.docx | https://github.com/fkostya/DBA_Scripts/blob/main/SSISDB_Scripts.docx |
| Security#: DB_Refresh_Scripts.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Security%23%3A%20DB_Refresh_Scripts.sql |
| Security#: DB_Refresh_Scripts.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Security%23%3A%20DB_Refresh_Scripts.sql |
| Security#: DB_Users_Script.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Security%23%3A%20DB_Users_Script.sql |
| Security#: DB_Users_Script.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Security%23%3A%20DB_Users_Script.sql |
| Security#: Invalid_owner_for_system_schema_role_or_database.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Security%23%3A%20Invalid_owner_for_system_schema_role_or_database.sql |
| Security#: Invalid_owner_for_system_schema_role_or_database.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Security%23%3A%20Invalid_owner_for_system_schema_role_or_database.sql |
| Security#: Script Out DB Permissions in case of DB Refresh.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Security%23%3A%20Script%20Out%20DB%20Permissions%20in%20case%20of%20DB%20Refresh.sql |
| Security#: Script Out DB Permissions in case of DB Refresh.sql | https://github.com/fkostya/DBA_Scripts/blob/main/Security%23%3A%20Script%20Out%20DB%20Permissions%20in%20case%20of%20DB%20Refresh.sql |
| README | https://github.com/fkostya/DBA_Scripts |
| https://github.com/fkostya/DBA_Scripts#dba_scripts |
| https://www.youtube.com/c/AzureSQLChamp | https://www.youtube.com/c/AzureSQLChamp |
|
Readme
| https://github.com/fkostya/DBA_Scripts#readme-ov-file |
| Please reload this page | https://github.com/fkostya/DBA_Scripts |
|
Activity | https://github.com/fkostya/DBA_Scripts/activity |
|
0
forks | https://github.com/fkostya/DBA_Scripts/forks |
|
Report repository
| https://github.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Ffkostya%2FDBA_Scripts&report=fkostya+%28user%29 |
| Releases | https://github.com/fkostya/DBA_Scripts/releases |
| Packages
0 | https://github.com/users/fkostya/packages?repo_name=DBA_Scripts |
| Please reload this page | https://github.com/fkostya/DBA_Scripts |
| Contributors | https://github.com/fkostya/DBA_Scripts/graphs/contributors |
| Please reload this page | https://github.com/fkostya/DBA_Scripts |
|
| https://github.com |
| Terms | https://docs.github.com/site-policy/github-terms/github-terms-of-service |
| Privacy | https://docs.github.com/site-policy/privacy-policies/github-privacy-statement |
| Security | https://github.com/security |
| Status | https://www.githubstatus.com/ |
| Community | https://github.community/ |
| Docs | https://docs.github.com/ |
| Contact | https://support.github.com?tags=dotcom-footer |