Browse by Tags

All Tags » performance tips (RSS)

SQL for SMS/ConfigMgr Tip - Distribute data evenly from 1 SQL file to multiple SQL files by jnelson

BACKGROUND When you first install an application like SMS or ConfigManager, the underlying SQL database is sitting in one data file. Now, depending on...

UPDATE - SMS 2003 - Selecting from v_Add_Remove_Programs still slow, even after applying 939872 by jnelson

I previously wrote an article talking about the slowness we were having even after applying 939872 --> HERE There are some additional things I'd...

SMS 2003 - Selecting from v_Add_Remove_Programs still slow, even after applying 939872 by jnelson

!!!! UPDATE !!!! WHEN YOU'RE DONE, THIS ARTICLE HAS BEEN UPDATED --> HERE PROBLEM I don't know if this is a function of the massive size of...

SMS - #2's #1 suggestion - Learn to read/write WQL/SQL by hand by jnelson

My #1 suggestion after years of working with SMS/SQL/WQL and then coaching/mentoring/training people is that it REEEALLLY pays to know how to read/write...

SMS Performance Tip - Reorganize the Add_Remove_Programs_DATA tables for speed by jnelson

DISCLAIMER! OK, BIG disclaimer here. This procedure is neither endorsed, nor supported by Microsoft and for small to middle size SMS deployments might...
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems