Welcome to MSDN Blogs Sign in | Join | Help

March 2008 - Posts

How to set MAX_SERVER_MEMORY

Posted Monday, March 31, 2008 2:08 AM by boduff
OK I'm on a roll here blogging as my brain is full up on the MCA course. Here's a good tip on how to calculate the MAX_SERVER_MEMORY a) calculate worker threads (assuming set correctly, as default max 255 may be too low for huge beasts) select max_workers_count Read More...
0 Comments
Filed under:

SQL Server Memory Architecture. Myth Busting and how sad is AWE/32 bit.

Posted Monday, March 31, 2008 1:05 AM by boduff
I have a little picture below to show how memory is broken up in the SQL Server Working set. Some key Myths to dispel: a) The Max Memory Setting only sets the target memory for the buffer pool not for the whole of SQL Server working set. So do not set Read More...
2 Comments
Filed under:

The Pressure of the MCA/Ranger Course

Posted Sunday, March 30, 2008 11:31 PM by boduff
Exam #3 at the SQL Ranger course is tomorrow and a few of the candidates and Instructors have spoken about the huge pressure on Candidates. Most people come from a community where they ARE the SQL experts and highest authority. Their managers, co-workers Read More...
1 Comments
Filed under:

The SQL Server Disaster Game

Posted Sunday, March 30, 2008 9:51 PM by boduff
I have been doing a great course with Paul Randal on disaster recovery for SQL Server. He has a great blog on just about everything to do with DBCC and disk structures and recovery. See http://www.sqlskills.com/blogs/paul/default.aspx Here is a little Read More...
0 Comments
Filed under: ,

Mid Way Through Ranger 03

Posted Saturday, March 29, 2008 6:30 AM by boduff
I've just survived week 3 of the SQL Ranger Rotation 04 here in Redmond. Whats its been like: a break neck sprint through level 300-500 content on SQL nearly every aspect of SQL. Man I thought I was good on SQL Server until Paul Randal started explaining Read More...
1 Comments
Filed under: , ,

Managing SQL Server for MOSS

Posted Friday, March 07, 2008 4:07 PM by boduff
There is a new white paper available on managing SQL Server for MOSS environments. http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409 Great tips on Index defragging and use of DBCC. One thing that I'm not sure I entirely agree with is the adding Read More...
1 Comments
Filed under:

Off to Ranger/MCA Training

Posted Friday, March 07, 2008 9:56 AM by boduff
I'll be off to the states for the four week MCA:Database training. http://www.microsoft.com/learning/mcp/architect/database/default.mspx Speaking to people who have been on the course before this is really exciting. We get to spend four weeks in training Read More...
1 Comments
Filed under: , ,

My Trip to the land of XML Messaging

Posted Friday, March 07, 2008 9:34 AM by boduff
Sorry I've been off the radar a while. I've been working as a Solution Architect on a large telco solution. I'm very happy with the results, We managed to make good use of lots of SQL Server programmability features such as XML, service broker, SQL CLR, Read More...
1 Comments
Filed under: ,
 
Page view tracker