<p style="text-align: justify;"> <p style="text-align: justify;"> <strong>1. Install WinDbg</strong> </p> <p style="text-align: justify;"> – Navigate to <a href="https://en.wikipedia.org/wiki/WinDbg" target="_blank">Debugging tools for Windows</a> on the Microsoft site and download the Windows Driver Kit (WDK) file from <a href="http://www.microsoft.com/whdc/devtools/debugging/default.mspx" target="_blank">here</a>. (<em>Please bear in mind that as at the time of this post, Microsoft in their infinite wisdom 🙂 have merged the standalone version of the tool as part of the Windows Drivers Kit</em>).
[Event ID: 1, SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=2716. Thread=2148. Server. Instance=MSSQLSERVER. VD=Global\331e46ea-551a-4bb1-b628-5abbeb9fa10f_SQLVDIMemoryName_0.]
– You also have options to Backup Log & Restore Database from the operation drop down list.
[table id=13 /]
– From windows command prompt: Cluster Log /Level:X– From PowerShell: Set-ClusterLog -Level X
– Under Other Resources -> Right-click on the SQL Server Instance name -> click Take this resource offline
– Under Please confirm action -> click Take SQL Server Instance offline
– When the instance is offline -> Right-click on it and select properties -> click on Dependencies tab -> click the Insert botton -> click the drop-down botton and select the new disk -> click Ok
– Right-click on the SQL Server Instance -> click Bring this resource online
Note: If you have more than 8 tempdb data files created, delete the data files after the eight (i.e. tempdev9 and above) by simply selecting each file and click remove.
Split SQL TempDB Script[sourcecode language=”sql”]
USE master
GO
CREATE TABLE #numprocs
(
[Index] INT,
[Name] VARCHAR(200),
Internal_Value VARCHAR(50),
Character_Value VARCHAR(200)
)
DECLARE @BASEPATH VARCHAR(200)
DECLARE @PATH VARCHAR(200)
DECLARE @SQL_SCRIPT VARCHAR(500)
DECLARE @CORES INT
DECLARE @FILECOUNT INT
DECLARE @SIZE INT
– Click Finish and you should have two targets
– SQL1: Click on Start -> Administrative Tools -> iSCSI Initiator.
– Click Yes to start the iSCSI service
– Click the Configuration tab and click change
– Under new intiator name, type in the name of the IQN initiator and click OK
– Click on Discovery tab -> Discovery Portal….
– Enter the IP address of the Target server.
Active Directory DNS role by default was installed during the installation of Windows Server 2008 R2 Active Directory in my earlier post. DNS is comprised of two zones “Forward Lookup Zone – Resolves hostname to IP address” and “Reverse Lookup Zone – Resolves IP address to hostname”. In this post I will configure the Reverse Lookup Zone which isn’t configured by default.
Requirements: Ensure Active Directory had been installed. Refer to this post