Most Popular SQL Server

Why DPA Uses SQL Server Trace Flag 2861 and Zero Cost Plans

About zero cost plans in SQL Server OK, first thing first, what is a “zero cost plan” in SQL Server?  I did some digging around and found the following links, which I would encourage you to read before continuing with this post: http://msdn.microsoft.com/en-us/library/ms181055.aspx http://support.microsoft.com/kb/325607 If you’ve done this background reading, you should now be aware […]

Read More

Collecting and Alerting on Deadlocks for SQL Server

SolarWinds DPA can collect a count of the number of deadlocks to be displayed as a resource graph. For Ignite versions prior to 8.2, you can update two files in order to start collecting the number of deadlocks. Enabling DPA to Collect Deadlock Information The code below takes advantage of the system_health extended event session […]

Read More

Installing SQL Server Management Studio for SQL Server 2016

With the SQL Server 2016 release Microsoft has changed the way that they are delivering SQL Server Management Studio (SSMS). In previous releases SSMS was installed as a part of the SQL Server installation itself from the SQL Server Installation Center. That is no longer the case with SQL Server 2016. Now SSMS is not […]

Read More

Installing SQL Server 2016 on Server Core

One of Microsoft’s best practices for deploying SQL Server is to install it on Windows Server Core. Windows Server Core provides a more streamlined, efficient and secure platform than the full Windows Server implementation with the GUI. Even so few businesses have chosen to implement SQL Server on Server Core and there are a few […]

Read More