Thursday, March 10, 2011

SQLskills Immersion Events - Deep SQL Server Training (MCM) in London

London, UK: mid-June 2011 

http://www.sqlskills.com/T_SQLskillsImmersionEvents.asp

Starting in 2011, SQLskills will be providing three 5-day classes and one 4-day class that will cover all the training material we think makes a well-rounded DBA. They aim to provide the training that will solidify your understanding of the required material, using only the best instructors - Paul S. Randal, Kimberly L. Tripp, Jonathan Kehayias, Brent Ozar, and Bob Beauchemin

The four classes are as follows - click the link for a more extensive description of the material covered:

1. Immersion Event on Internals and Performance (5 days)
Data Storage Internals, Designing for Performance, and Indexing for Performance
Instructors: Paul S. Randal, Kimberly L. Tripp

2. Immersion Event on Performance Tuning (5 days)
IO Subsystems, Workload Analysis, and Performance Tuning Methodologies
Instructors: Brent Ozar, Paul S. Randal, Kimberly L. Tripp, Jonathan Kehayias

3. Immersion Event on High Availability and Disaster Recovery (4 days)
Virtualization, Consolidation, High Availability, and Disaster Recovery
Instructors: Brent Ozar, Paul S. Randal, Kimberly L. Tripp, Jonathan Kehayias

4. Immersion Event on Security, PowerShell, and Development Support (5 days)
Database Security, PowerShell Scripting, and Optimizing Procedural Code
Instructor: Bob Beauchemin.

All classes are limited to 32 students to ensure plenty of time for questions and discussions. These classes are lecture+demo, with hands-on labs for self-study. Just like all classes that we teach, there is no time for instructor-led HOLs given the amount of material we cover.

Set Max memory on SQL Server

Always set max server memory option to maximum physical memory of the server

exec sp_configure 'min server memory (MB)', 500
go

-- Error
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'min server memory (MB)' does not exist, or it may be an advanced option.

-- Solution
exec sp_configure 'show advanced options', 1
go
RECONFIGURE
go
exec sp_configure 'min server memory (MB)' ,500
go
exec sp_configure 'max server memory (MB)' , 'your server physical memory'
go