• Very nice article and great output. Just a suggestion

    In your script, to caluculate uptime (for variable @vOnline_Since), it might be better to use 'tempdb' instead of 'perfstat' database in the WHERE clause because tempdb gets created everytime SQL Server Service gets started, and therefore you can rely on this for SQL Server uptime.

    Regards,

    http://www.bhaved.com


    Kindest Regards,

    Ajay Prakash