Couple of week back, I was playing around with using Powershell for some simple activities. The fall out of that was the ability to search the SQL Server Error Logs. Though we can search for anything, I just showed you a case of usage. In this blog post, I will talk about one of the most sought after request for searching what the disk latencies are. Let us see a powershell script for for Identify Disk Latency on SQL Server Box.
SQL SERVER – Disk Space Monitoring – Detecting Low Disk Space on Server
A very common question I often receive is how to detect if the disk space is running low on SQL Server.