Check your SQL Server versionĪfter you install SQL Server, check the version number against the latest cumulative updates list, especially if you did not opt to or could not use Windows Update during SQL Server Setup. Let’s take a look at each of these in more detail in the subsections that follow. Increase SQL Agent and SQL Error log retention from the defaults. Set up scheduled backups, index maintenance, log retention maintenance, and integrity checks.īackup service master and database master keys. Review size and location of the Windows page file. Review Maximum server memory settings for other features.Ĭonfigure antivirus exclusions for SQL Server processes and files.Įnable the server setting “optimize for ad hoc workloads.”Įvaluate whether Lock pages in memory is necessary. Evaluate whether these are appropriate for your environment, but you should consider and apply them to most SQL Server installations.Ĭheck your SQL Server patch level version, and apply patches if necessary. The order of these items isn’t necessarily specific, and many deal with SQL server and/or Windows configuration settings. You should run through the following checklist on your new SQL Server instance. After you install SQL Server, there are a number of changes to make or confirm on the Windows Server and in settings for SQL Server.
0 Comments
Leave a Reply. |