Restore MSSQL database using batch script


If you are looking for a tool which can restore the MS SQL DB backup from the production environment to the development environment, this script is just the one that you are after. In my example, the script does the following things: 1) Copy of the latest pro db backup to local. 2) Close all connections of … Continue reading Restore MSSQL database using batch script

Monitor V7000 active alerts in Xymon


Continue with my previous post on installing the Xymon, you can write your own monitor scripts. I wrote a script named v7000alerts to check whether there are active alerts in my IBM StorWize V7000. 1) Download the script v7000alerts to /home/xymon/server/ext, and run 'chmod a+x v7000alerts' and 'chown xymon:xymon v7000alerts'. 2) Add the following into /home/xymon/server/etc/tasks.cfg … Continue reading Monitor V7000 active alerts in Xymon

PowerShell: XenApp Server Performance


I wrote a simple PowerShell script to monitor the real time performance (CPU usage, Memory usage and Disk queue length) of the XenApp farm servers. To make it work, you need to: 1) Download and install the XenApp Powershell SDK. 2) Ensure the 'Citrix XenApp Commands Remoting' service is running on the data collector server. … Continue reading PowerShell: XenApp Server Performance