Posts made in November, 2012


MSSQL I/O TroubleShooting


Posted By on Nov 29, 2012

Troubleshooting SQL I/O   Quick Checks:   Check disk fragmentation defrag x: -a -v Check perfmon counters typeperf “PhysicalDisk(*)Avg. Disk Queue Length” -sc 10 Values should be close to 0 High values reflect high I/O demand or poor disk performance typeperf “SQLServer:buffer ManagerPage life expectancy” -sc 10 Values should be high, and getting progressively higher. Low values reflect memory...

Read More

Change your Windows Host File


Posted By on Nov 12, 2012

1. Navigate to: C:WindowsSystem32Driversetc 2. Right click hosts file and click edit to modify with notepad 3. Add your entry.   Example of what to add: 127.0.0.1       www.domain.com   This means any request for www.domain.com on the box whose host entry you modified would be direct to the localloop back IP instead of the actual IP DNS lists.

Read More