SAP Note 879941 - Configuration Parameters for SQL Server 2005

Component : Microsoft SQL Server -

Solution : https://service.sap.com/sap/support/notes/879941 (SAP Service marketplace login required)

Key words :
alter database <sid> set auto_create_statistics onalter database <sid> set auto_update_statistics onalter database <sid> set auto_update_statistics_async, alter database <sid> set recovery full auto update/create statisticssap strongly recommends, alter database <sid> set page_verify checksum, alter database <sid> set page_verify torn_page_detection, windows clustera typical windows cluster environment consists, set working set size, low data cache hit ratio, recovery modelthe recovery model affects, concurrently running sap work processes, sql-dmo extended stored procedures

Related Notes :

1237682Configuration Parameters for SQL Server 2008
1134345Using locked pages for SQL Server
1126568Enable star join optimization with SQL Server 2008
986907SQL Server settings for R3load based system copy
327494Configuration Parameters for SQL Server 2000