Operating System Support for SQL Server Versions

There are currently six major versions of SQL Server that I commonly see being used in Production, along with five major versions of Windows Server. Only certain combinations of SQL Server and Windows Server are officially supported by Microsoft, but tracking down this information is a little tedious. Table 1 shows these possible combinations and […]

Using Windows Resource Monitor to Find Unusual Performance Bottlenecks

I recently had an interesting issue with a new SQL Server 2014 Enterprise Edition instance that was going to be hosting about 200 user databases that each use the SQL Server Filetable feature. The reported problem was that this new instance was taking two-three times longer to restore each full database backup than the restores […]

How to Reclaim Disk Space in your Windows\winsxs directory on Windows Server 2008 R2 SP1

I recently helped out someone who was running extremely low on disk space on their system drive, due to a bloated Windows\winsxs directory. This directory is where Windows keeps backup files for various things such as Windows Server 2008 R2 Service Pack 1. These files allow you to uninstall Service Pack 1, in case you […]