Having the windows firewall enabled, you should open the port used by SQL Server. So it is recommended to configure the SQL Server to use a specific port for each SQL instance installed on your server from the TCP/IP Properties dialog box below: Many older applications require server aliases...
[sysctl] vm.swappiness = 1 vm.dirty_background_ratio = 3 vm.dirty_ratio = 80 vm.dirty_expire_centisecs = 500 vm.dirty_writeback_centisecs = 100 vm.transparent_hugepages=always # For multi-instance SQL deployments, use # vm.transparent_hugepages=madvise...
For example, in a default SQL Server 2019 (15.x) installation on Windows, the event file (.xel file) should be created in the folder C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log. For Azure SQL Managed Instance, specify an Azure Blob Storage loca...
Learn how to configure best practices assessment on an instance of SQL Server enabled by Azure Arc.
If a SQL Server instance runs under Network Service credentials, give the correct permissions on the shared folder to the machine account for the SQL Server instance. Enable encrypt connection when connecting to the source and target servers. Using TLS encryption increases the security of data ...
Migrate agents from one Orion instance to another Use a group policy to migrate agents on Windows Redeploy agents from the SolarWinds Platform Web Console to a monitored node Change the agent communication mode on the remote node Change the agent port to match the open port on...
Recommended Preparation (Best Practices) Stages of a Rolling Upgrade See Also Applies to:SQL Server When upgrading a SQL Server mirrored instance to a new version, to a new SQL Server service pack or cumulative update, or to a new Windows service pack or cumulative update, you can reduce dow...
Specify server_name to connect to the default instance of SQL Server on that server computer. Specify server_name[\instance_name] to connect to a named instance of SQL Server on that server computer. If no server computer is specified, sqlcmd connects to the default instance of SQL Server ...
Therefore, Trace Flag 834 is best suited for servers that are dedicated to SQL Server.Note: When enabled, the large-page memory model preallocates all SQLOS memory at instance startup and doesn't return that memory to the OS.Note: If you're using the Columnstore Index feature of SQL ...
I suggest utilizing virtualization and consolidating multiple VMs on one or a few hosts, instead of putting multiple independent and active databases on a single SQL Server instance. This will give you much better flexibility, manageability, and isolation between the systems, especially if multiple SQ...