SQL Server clustered instance dependencies – verification – using tsql, xp_cmdshell

Goal

To check and verify if the existent dependencies for sql server resources are in place

My way of achieving it

Using tsql, xp_cmdshell. From time to time due to adding more disks to an instance or performing other activities we end up having a resource that is not tied to the parent resource and when it comes to sql server disks some of the databases residing on those disks are not accessible. In order to check if we have any of the resources not being tied to the right parent resource I have created the script below that will tell us which resources are not tied. The output of the script looks like below

sqldiskdep

The code can be downloaded from here

Leave a Reply

Your email address will not be published. Required fields are marked *