Check SQL Server Virtual Log Files Using PowerShell

In a previous tip on Monitor Your SQL Server Virtual Log Files with Policy Based Management, we have seen how we can use Policy Based Management to monitor the number of virtual log files (VLFs) in our SQL Server databases. However, even with that most of the solutions I see online involve the creation of temporary tables and/or a combination of using cursors to get the total number of VLFs in a transaction log file. Is there a much easier solution?

Shrinking all log files on SQL Server 2008R2

It shrinks all log files for the databases created by users.

Tracking Processes

DBA Basics

Administration

SQL Server Uptime

This script is used to get uptime for the SQL Server. (Supports SQL2005 and onwards only)

Catalog Views

Search for an object across multiple databases on a server.

There are other options available like Sql search from Red Gate. Here's a simple script to search for objects(s) containing a particular keyword.

Check status of SPN?

Display Names and Locations of SQL Database Files and DB Owners

Displays the names of all of the SQL databases on a SQL Server instance, their data and transaction log files, their owner, and their physical locations.