SCCM Guru Webcast Q&A

On 9/14/2011, BDNA graciously asked me to speak at their SCCM Guru webcast on anything I wanted.  I thought it would be a great time to give back to the community that built me by trying to relay some of the knowledge that I’ve learned.  I wanted to spend a little more time thoroughly answering the questions instead of rushing through 30 questions, so I only actually answered 6 questions during that time.  But there were dozens of questions that people put to me.  I always intended on answering everyone’s question that came to me before the webcast or the Q&A during it.  I am hereby announcing a series here on (hosted by MyITForum) that will attempt to answer all of the questions put to me in respectable detail.

So, this post will serve as a placeholder you can come to which will link to the various questions and answers I will blog on in the coming days.


  1. MAXDOP  (2011-09-15)
    Can you explain what “Max Degree Of Parallelism” is and how I should configure that?
  2. Multiple Rows In Reports (2011-09-16)
    IPAddress or Subnet produce multiple rows in reports; how can I write a report to fix that? Same for OU.
  3. Troubleshooting – ConfigMgr vs SQL (2011-09-17)
    Troubleshooting if something is a ConfigMgr problem vs a SQL problem is sometimes difficult to pinpoint.  Where and what logs are the first places you check when troubleshooting?
  4. Memory Capacity Planning (2011-09-19)
    Often, we see SQL Server 2008 SP2, 64-bit consume all of max memory.  Multiple blogs discuss that this is by design and there are even suggested tables on setting up upper limits on SQL for SCCM.  Please share your knowledge on what is correct and best practice on memory capacity planning and allocation of SQL Server 2008 for SCCM 2007.
  5. Indexing Tables (2011-09-20)
    I’ve heard you mention indexing tables in the ConfigMgr database that aren’t indexed by default out of the box.  Which tables do you recommend and why?  What should I index, and from a “I only know just enough about SQL because it’s part of CM” point of view…Do you have a blog or some directions on how to index and how to determine it’s working as expected without impact.


Number2 (John Nelson)  
MyITForum - Forum Posts
MyITForum - Blog
Add to Google

Published Thursday, September 15, 2011 10:46 PM by jnelson


No Comments
Powered by Community Server (Commercial Edition), by Telligent Systems