Powershell Commands for SQL Server Always On Availability Groups
This article can contains a PowerShell script to help you monitor and failover any SQL Server Availability Group you manage.
Alejandro Cobar is an MCP, SQL Server DBA and Developer with 10+ years of experience working in a variety of environments.
- MSSQLTips Awards: Author of the Year - 2020 | Rising Star (50+ tips) - 2021 | Author Contender - 2019, 2021
Create an Always On Availability Groups using TSQL
Learn the steps to create a new SQL Server Availability Group and add databases to the Availability Group using just TSQL code.
SQL Server 2016 Availability Group Issue with Automatic Seeding
In this article we look at an issue caused by using the automatic seeding option for an Availability Group when using it for the SSISDB database.
How To Check Disk Space in SQL Server
Script to easily monitor free space for all SQL Server drives for quick analysis and reporting.
SQL Server Monitoring for all Availability Groups
In this article we present a PowerShell script that can help you monitor all of your SQL Server Availability Groups in your environment.
SQL Server Availability Group Error 35246 missing sqlconf.dll
In this article we look at the error message a SQL Server instance name could not be validated because the dynamic link library (DLL) file sqlconf.dll could not be located Microsoft SQL Server Error 35246 and how this can be resolved.
Monitor SQL Server Table Size with PowerShell
In this article we continue the PowerShell monitoring series by collecting SQL Server table size information for all tables in all instances.
sp_whoisactive SQL Server Monitoring
In this article we look at how to use PowerShell to gather data from multiple SQL Server instances to execute and collect data from sp_WhoIsActive into a central repository.
Deploy Database Objects to Multiple SQL Server Instances
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
Monitoring SQL Server Version and Build Numbers
This article contains scripts that check the current version and build for all SQL Server instances in your environment.
PowerShell Script to Parse HTML Code with SQL Server Build Numbers
In this article we look at a PowerShell script that will read SQL Server build numbers from a web page and present the data in a easy to use manner.
Delete SQL Performance for SQL Server, MySQL and PostgreSQL
In this article we do a comparison of SQL Server, MySQL and PostgreSQL to see how long large delete operations take and the impact on the database logs.
SQL Server Monitoring with PowerShell for Database Security
In this article we continue our PowerShell monitoring series by collecting logins and server roles for all monitored instances for analysis of the data.
SQL Server Monitoring of Buffer Pool Usage by Database
This article contains PowerShell scripts to help you monitor SQL Server buffer pool use.
SQL Server High CPU Query Use Monitoring with PowerShell
In this part of the PowerShell monitoring tips we look at how to capture the top queries that are consuming the most CPU from all monitored instances.
SQL Server Wait Stats Monitoring with PowerShell
In this article we add another module to the PowerShell monitoring process to capture wait stats for all monitored SQL Server instances.
Monitor all Indexes in SQL Server with PowerShell
In this article we continue using our PowerShell scripts to monitor SQL Server by collecting index information for all server and databases that are being monitored.
How to Check SysAdmin Role in SQL Server with PowerShell
As we continue our PowerShell monitoring series, this module captures which logins have sysadmin level privileges for all of the monitored SQL Server instances.
SQL Server Database and Database File Monitoring with PowerShell
As we continue our series on monitoring SQL Server with PowerShell in this section we collect database information for each monitored instance.
SQL Server Agent Job Monitoring for Last Execution with PowerShell
In this article we continue our series of using PowerShell to monitor SQL Server by collecting the last run information for SQL Server Agent Jobs.
SQL Server Backup Monitoring with PowerShell
In this part of the series we look at how to use the PowerShell monitoring scripts to collect backup information from your monitored instances.
SQL Server Agent Job Monitoring with PowerShell
In this part of the series we look at how to use the PowerShell monitoring scripts to collect SQL Agent job information from all monitored servers.
Monitoring SQL Server with PowerShell Instance Data Collection
In this part of the series we look at scripts that can capture instance level data for SQL Server instances being monitored.
Monitoring SQL Server with PowerShell Core Object Setup
In this series of tips we will introduce PowerShell scripts with T-SQL code that can be used to monitor your SQL Server environment. This first set of scripts creates the core objects needed for this solution.