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

Critcal error: TF30046: The instance information does not match. Team Foundation expected xxx which was not found. Please contact your Team Foundation Server administrator.

This scenario is for After Restoring TFS Database 2013 Open Database instance in Sql Server Management Studio and open database TFS_Configuration Go to tbl_ServiceHost table and look for entry where Name  = “TEAM FOUNDATION”. Copy the HostId Go to TFS INSTALL FOLDER \Application Tier\Web Services folder Open the web.config and update the value for applicationId…

Read More

Test Network Connectivity with the PowerShell Test-Connection Cmdlet

Since the first time computers were networked together, people have had to test their connections. Just like a dial tone that tells you the phone is ready to use, many IT pros want to make sure they have a remote connection before beginning their ‘call’. For IT pros, this has traditionally meant using the PING utility that…

Read More

Case of the Logon Attempt Failed RDP Connection

This issue will occur if the dependency services are disabled. Please make sure the following services are enabled and running. –      DNS Client –      Function Discovery Resource Publication –      SSDP Discovery –      UPnP Device Host We can see from the security logon that successful connections are using Package Name (NTLM only):    NTLM V2 On the Server…

Read More

CBS log and CBS persist in %Windir%\logs\CBS

Batchfile :: This batch file stops CAB and CPS files filling up temporary storage caused by Trusted Installed and Windows Update services. @ECHO OFF :: Title for Batch Script title The Fumigator :: Display Text Echo Executing The Fumigator, hold your breath. :: Stop Windows Update Service net stop wuauserv :: Delete all files/folders WITHIN…

Read More

Thank you PHSA for sponsoring me in the Administering a SQL Database Infrastructure (M20764) for my 70-462 Exams

COURSE OVERVIEW In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure. This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure and can…

Read More

Determine which w3wp.exe process belongs to which web site

For IIS6 web server that is hosting two application pools. Occasionally, one of the w3wp processes will spike the CPU for a while, and both app pools seem to suffer the consequences. Goto cmd window then type c:\windows\system32\cscript c:\windows\system32\iisapp.vbs For IIS7 you need to use APPCMD from %systemroot%\system32\inetsrv\ as an administrator   %systemroot%\system32\inetsrv\appcmd list wp

Read More