One thing that we always set up on a new server is a Performance Monitor “black box”. The black box is basically a PerfMon collector that starts when the server does and runs continuously on the background, gathering performance data from number of vital counters. It has minimal performance overhead and is great at giving you a good idea on what has been going on in your servers during the last several days.
SQL Server tool improvements
While there’s plenty of new and exciting features coming with SQL Server 2016, Microsoft has also worked hard on improving the delivery of their SQL Server tools. Previously figuring out the correct tools or what version to install could be more than little confusing, but no more!
Managing shared folders in Windows Failover Cluster with Powershell
I’ve been using Powershell more and more lately, most of the time the motivation has been to do repeatable tasks much more quickly and efficiently but there has also been other cases where Powershell has been the only way to accomplish something. Most often this is due to lacking GUI or Windows issues that have prevented me from using the GUI in the first place. This post describes the latter scenario and the Powershell workaround.
Continue reading “Managing shared folders in Windows Failover Cluster with Powershell”
Distributed Replay
Distributed Replay is a feature that was first introduced with SQL Server 2012. It allows you to play a set of recorded transactions against a SQL Server database. This can be extremely useful if you’re doing hardware or SQL Server version upgrades and want to test the performance impacts of these changes, or if they’re going to break your application.
Few thoughts from the Data Driven SQL event
Just finished watching the Data Driven event that was broadcasted live from New York earlier today. As expected there was a lot of information about SQL Server 2016 and quite a few visitors telling how their companies used Microsoft SQL Server in their daily business. And these were some big businesses, having impressive amounts of data and transactions to handle. With SQL Server 2016 Microsoft is giving us a feature packed and complete data platform to work with.
Continue reading “Few thoughts from the Data Driven SQL event”
Poor results in I/O tests due to Windows Task Scheduler settings
Not a long ago I was doing a database cluster delivery to one of our customers and as a part of that process, I scheduled our regular set of test runs for the storage. The results of the tests we ran were bad and none of the changes we did at the SAN weren’t helping. After a while we figured out that the issue was not in the test software or at the SAN but in the scheduled tasks we used to run the different test!
Continue reading “Poor results in I/O tests due to Windows Task Scheduler settings”
Windows Firewall and antivirus software configurations for SQL Server.
One of the more important duties of a DBA is to make sure that their databases and the data is secure. In this post we’ll be looking at two utilities to increase the security of your server, the Windows Firewall and an antivirus software. Like with about everything else related to servers, you can’t just switch these on (well, you could, but…) and forget about them to get the best possible experience. They need to be properly configured for servers running Microsoft SQL Server. If you’re a DBA you might not be doing the configuration yourself, but you still need to tell your Windows administrators what they need to do.
Continue reading “Windows Firewall and antivirus software configurations for SQL Server.”
