Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts tagged SQL Cluster

I ran into an interesting issue while installing SQL 2012 SP1 in a failover cluster configuration and utilizing the local TempDB feature.  If you are unfamiliar with the new feature in SQL 2012 that allows you store TempDB on a local drive in a failover cluster you can read more here.  Here is a screen […]

This post has been sitting in the draft folder for way too long, March of last year to be precise.  So although this is no longer new information, it has not been talked about all that much.  I’m talking about the new feature in SQL Server 2012 that allows you to put TempDB on local […]

I presented for the PASS DBA Virtual Chapter several weeks ago and talked about different ways that Active Directory can affect your SQL Server.  We only had an hour so I had to scale the content back and because of that I had a ton of questions.  I answered what we had time for on […]

I recently had the need to move the MSDTC for a cluster to a new SAN drive.  It’s a quite simple thing to do, but you can’t redirect the MSDTC resource to a new drive.  Let’s just walk through the basic steps. The first thing you need to do is get the new drive added to the cluster and […]

The syspolicy_purge_history SQLAgent job is used by Policy Based Management in SQL server to clear out the policy evaluation history kept by PBM. The job consists of the following three steps. First to check to see if PBM is enabled and exit if it is not. Run the msdb.dbo.sp_syspolicy_purge_history system stored procedure to clear the history Use […]

How to set SQL Mirroring TIMEOUT and 2 scenarios where you want to.