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 Number2Blog.com (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.
POSTS IN THIS SERIES:
- MAXDOP (2011-09-15)
Can you explain what “Max Degree Of Parallelism” is and how I should configure that?
- 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.
- 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?
- 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.
- 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.
MORE TO COME!!!