TempDB Shrink

use tempdb GO DBCC FREEPROCCACHE — clean cache DBCC DROPCLEANBUFFERS — clean buffers DBCC FREESYSTEMCACHE (‘ALL’) — clean system cache DBCC FREESESSIONCACHE — clean session cache DBCC SHRINKDATABASE(tempdb, 10); — shrink tempdb dbcc shrinkfile (‘tempdev’) — shrink db file dbcc shrinkfile (‘templog’) — shrink log file GO — report the new file sizes SELECT name,…

Read More

IIS website is only listening on 127.0.0.1 and not IP address

I recently had this problem, and even after ensuring that the bindings for the website were linked to all unassigned addresses, I could still only connect via the loopback address, 127.0.0.1. The first troubleshooting step was to look at all listeners using: netstat -an I noticed I had an entry for port 80 for 127.0.0.1,…

Read More