Tag: Configuration
This tag groups together all the articles and posts related to SQL Server configuration
-
How to compare the server configuration and settings (sp_configure settings) of two SQL instances and identify the differences?
Have you ever wanted to compare the server configuration settings of two SQL Servers, but struggled with creating linked servers between the servers or by manually comparing the data? No longer! This post provides you with a PowerShell script, that takes two SQL Server names as input parameters, quickly compares the server configuration and highlights…
-
SQL Server ‘max server memory (MB)’ – the magic formula for calculating buffer pool size
As an SQL Server DBA, have you got a formula for calculating the value for ‘max server memory (MB)’ parameter, that restricts the memory used by SQL Server buffer pool? If not, read on and use the script provided in this post, to come up with a suitable value using various different formulae.
Latest Articles
