Transcript Session title - The Desktop Team

SQL SERVER
The Desktop Team
Raphael Perez
MVP: Enterprise Client Management, MCT
RFL Systems Ltd | [email protected]
@dotraphael | http://uk.linkedin.com/in/dotraphael/
http://www.thedesktopteam.com/
AGENDA
- Requirements
- Memory
- Databases
- Disk Layout
The Desktop Team - http://thedesktopteam.com
REQUIREMENTS (1)
- 64-bit version of SQL Server with Windows
Authentication
- Collation: SQL_Latin1_General_CP1_CI_AS
- Features: Database Engine Services and Reporting
Services
- SCCM does not support dynamic ports
The Desktop Team - http://thedesktopteam.com
REQUIREMENTS (2)
- SQL Server 2008 SP2 CU9+, SP3 CU4+
- SQL Server 2008 R2 SP1 CU6+, SP2
- SQL Server 2012 CU2, SP1, SP2
- SQL Server 2014 (only Upgrade)
The Desktop Team - http://thedesktopteam.com
REQUIREMENTS (3)
- Standard or Enterprise
- SQL Express for Secondary Site only
- SQ Server Express 2008 R2 SP1 CU6+, SP2
- SQL Server 2012 Express CU2+, SP1
- SQL Server Express 2014 (upgrade only)
The Desktop Team - http://thedesktopteam.com
MEMORY
- When installed on the same box, limit the memory:
50% to 80% of usable memory
- When installed on dedicated box, limit the memory
to 80% of usable memory
The Desktop Team - http://thedesktopteam.com
DATABASES
- 1 database file per core (max of 8)
- 1 tempDB file per 2 CPU’s (max 2)
- Disable/limit autogrowth
- Limit log file size
- Recovery mode set to simple
The Desktop Team - http://thedesktopteam.com
DISK LAYOUT
- Raid 10
- Split disk and scsi controller
- Split databases and log files
- Combine tembDB and tempdb log
The Desktop Team - http://thedesktopteam.com
DEMO
SQL SERVER
The Desktop Team
THANKS
The Desktop Team
E-BOOK:
HTTP://BIT.LY/1CPO60E
PAPERBACK:
HTTP://AMZN.TO/1B20VYB