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:   This means any request for 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