Showing posts from 2016

Check SQL Server Database Status

It's been a month since my last post. Today I am posting a function that can be used to check the status of MS SQL Server databases. At the current moment, I am not sure about the limitations on where this script works like which versions of Windows OS or supported MS SQL Server versions. I have been using the script on my laptop where I have installed Windows 10 OS and SQL Server 2014 Developer Edition. SQL Server Developer edition can be downloaded from here . There are multiple methods to connect to a SQL Server instance from Powershell. I found this very useful article on sqlshack . The script in this post makes use of the SQLPS module. <# . Synopsis Check database status on MS SQL Server instances. . DESCRIPTION Check the database status on one or a list of MS SQL Server instances. . Parameter ServerInstance Provide the server instance to connect to in case of a named instance servername\instancename. . EXAMPLE Get-DBStatus -Serv

Get IIS AppPool Info

Here is a simple PowerShell function to check the app pool status on remote servers. It make use of Microsoft.Web.Administration Namespace instead of WebAdministration snap-in. Please let me know your feed back. References: <# . SYNOPSIS List the app pools and it' state remotely. . DESCRIPTION Get the app pools and it's status remotely making use of .NET Microsoft.Web.Administration namespace. . PARAMETER ComputerName Provide the name or IP address of a remote computer or a list of computer names separated by a comma. .EXAMAPLE Get-AppPool -Computer comp1,comp2 #> Function Get-AppPool (){ [ CmdletBinding ()] param ( [ parameter ( mandatory = $ True , Position = 1 )] [ string []]$ ComputerName

Check Memory Usage

This blog is created as part of my PowerShell learning and getting into the blogging world, so you may see repetitive content. Please bear with me. Here I am posting a simple script that can be used to get RAM memory details from remote windows computers. Please let me know your suggestions on improving the scripts. reference: <# . SYNOPSIS Get memory details of a remote server . DESCRIPTION Get the Available physical memory, FreePhysicalMemory, and Percentage of Memory Usage remotely. . PARAMETER ComputerName Accepts a list of computer names or IP addresses . EXAMPLE Get-MemoryUsage -ComputerName computer1 Get-MemoryUsage -ComputerName computer1,computer2 . LINK #> function Get-MemoryUsage { [ CmdletBinding ()] Param ( # A computer name or list of computer names