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.
Thursday, March 10, 2011
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
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