Enabling High Performance Power Plan via PowerShell

One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard configuration changes. Much of this process was already done by my predecessor Nic Cain (blog|@SirSQL) who had written an interactive PowerShell process for doing the SQL Server installs and making some of the configuration settings. I just needed to add some enhancements and new features to that. One thing I added to the script was to automate setting the power
read more

Network Packet Size: to Fiddle With or Not to Fiddle With

A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s something that DBAs should be aware of. There is a server configuration in SQL Server that controls the size of packet in which SQL Server sends out data. This setting is called network packet size (B). Yet another size we need to know about in SQL Server. As DBAs, we tend to think of size in terms of 8K pages
read more

Day 31 of 31 Days of Disaster Recovery: Backup and Restore of the Resource Database

It has been a long journey to the final day my 31 Days of Disaster Recovery series, but we have finally reached the final post, day 31. My final topic for the series is born out of a conversation I had today with my good friend and fellow DBA, Ed Watson (blog|@SQLGator). today, I want to talk about backing up and restoring the resource database. The resource database stores critical system objects safely separated away from the master database. It
read more

My Kingdom for a Port

One of the steps in setting up database mirroring is to assign a port to the endpoint. It’s common practice to simply give it port 5022, but what if that port is already being used? The endpoint creation doesn’t verify the availability of a port and will be created successfully. You won’t know that the port is already being used until you get a communication error when trying to start the mirroring session. Then you have to go through troubleshooting
read more