We are looking for a Perl developer with knowledge (and access to) Microsoft SQL Server. The purpose is to write a Perl Script that connects to a Microsoft SQL Server and retrieves key performance parameters from it using WMI. For this project you need to have access to a working Microsoft SQL server.
All code should run in subroutines - the main code should be located in a subroutine called sub MAIN
Code should not fail (die) if an error is found but return the error.
We need following parameters to be captured by the perl script. Values should be returned as a Hash table.
Total Server Memory
Target Server Memory
Buffer cache hit ratio
Page Life Expectancy
Lock Wait Time (ms)
latch waits per second
total latch wait time