Friday, September 19, 2014

New SQL Installations Check List   - Post Installation
1
Verify that SQL Server and dependency services configured are up and running
2
Verify that SQL Server Client tools are present on all nodes
3
Verify the Services are running under valid Service Account
4
Verify the Edition, version and appropriate Service packs installed.
5
Ensure windows fire wall is enabled and appropriate ports are enabled on the windows firewall
6
Confirm that all the protocols are enabled and Server is listening on all protocols
7
Verify that you are able to connect to SQL Server and through all protocols remotely/locally.
8
Provide access to the appropriate security groups/accounts
9
Lite Speed Installation
10
Tempdb Configuration (No Of Data files = No. Of CPUs)
11
AWE Enabled (32bit)
12
PAE Switch
13
Max Server Memory
14
Min Server Memory
15
Max Degree of Parellelism
16
Lock Pages in Memory
17
Enable Remote Connections and Check for the connectivity
18
Enable Fire wall and add the Port no in exception list
19
Create Admin database
20
Backup jobs (User & System)
21
WWSQLDB Growth job
22
Update Stats & Index maintenance jobs
23
Register the Server Name as part of tbl_server_List in EDSQLSvr
24
Raise a Request with the DPM team to have a tape backups


No comments:

Post a Comment