TSQL to identify databases with high number of VLFs

If you aren’t aware there can be significant impact to performance when a database has a high number of VLFs within it’s Transaction Log. SQL Server divides each physical transaction log file internally into a number of virtual log files (VLFs) and it is these that contain the log records.  There is no fixed size for a…

1

SQL 2012 Core on Windows Server 2012 (Part 2 – SQL Install)

With the release of Windows Server 2012 I thought I would take the opportunity to look at running SQL 2012 Core on Windows Server 2012. This blog is part 2 of a series which will look at the configuration for installing SQL 2012 Core on Windows Server Core, and then finish with adding AlwaysOn functionality…

0

SQL 2012 Core on Windows Server 2012 (Part 1 – OS Install and Environment Setup)

With the release of Windows Server 2012 I thought I would take the opportunity to look at running SQL 2012 Core on Windows Server 2012. This blog will be part of a series which will initially look at the configuration of installing SQL 2012 Core on Windows Server Core, and then finish with adding AlwaysOn…

0