1 / 11

SQL SERVER

SQL SERVER. The Desktop Team. Raphael Perez MVP: Enterprise Client Management, MCT RFL Systems Ltd | raphael@rflsystems.co.uk @ dotraphael | http://uk.linkedin.com/in/dotraphael / http://www.thedesktopteam.com/. AgendA. Requirements Memory Databases Disk Layout. Requirements (1).

ashby
Download Presentation

SQL SERVER

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL SERVER The Desktop Team Raphael Perez MVP: Enterprise Client Management, MCT RFL Systems Ltd | raphael@rflsystems.co.uk @dotraphael| http://uk.linkedin.com/in/dotraphael/ http://www.thedesktopteam.com/

  2. AgendA • Requirements • Memory • Databases • Disk Layout

  3. 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

  4. 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)

  5. 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)

  6. 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

  7. 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

  8. Disk Layout • Raid 10 • Split disk and scsi controller • Split databases and log files • Combine tembDB and tempdb log

  9. DEMO SQL SERVER The Desktop Team

  10. THANKS The Desktop Team

  11. E-book: http://bit.ly/1cPO60ePaperback: http://amzn.to/1b20vyB

More Related