Month: October 2015

  • Intro to HammerDB

    Intro to HammerDB

    One of my favorite benchmarking tools is HammerDB.  In a nutshell, it allows you to run a well evolved SQL benchmark (TPC-C) against your system to gauge performance.  The scenario to picture is an order/warehouse simulator and your metric is how many new orders per minute (NOPM) the system can crank out. CPU, memory, disk all matter […]

  • DSQuery

    DSQuery

    Using DSQuery to disable user accounts after inactivity period Query AD for users that have been inactive for 13 weeks dsquery user “CN=Users,DC=Domain,DC=local” -inactive 13

  • IOPS calculations

    IOPS calculations

    Read and Write IOPs Total the read and write IOPs and calculate the number of recommended spindles. For example, 10K RPM spindles can be assumed to support 130 IOPs, and 15K spindles can be assumed to support 180 IOPs. The total Backend IOPs workload is a function of the front-end (host) workload and the RAID […]