Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 829831 - Last Review: October 27, 2006 - Revision: 1.2
Slow Response Time When You Click Systems Management Server Collection Objects
When you click to select a Microsoft Systems Management Server (SMS) 2003 collection object (such as a user account object or a computer object) after the collection is updated, the object is slow to be selected. However, when you click the same object again, the object selection occurs much faster.
The query in SMS 2003 causes this behavior. When you first select a collection or a collection resource, there are a number of Windows Management Instrumentation (WMI) queries that trigger SQL queries. It may take longer to run the query the first time if connections to the SMS WMI provider and Microsoft SQL Server must be started.
You can view the collection query process in the Smsprov.log file. The file is located in the SMS\Logs folder. The Collection query information is similar to the following query information:
[644][Wed 11/12/2003 17:10:36]:CSspQueryForObject :: Execute...
[644][Wed 11/12/2003 17:10:36]:Execute WQL =select * from SMS_CM_RES_COLL_SMS000HS where ResourceID=20
[644][Wed 11/12/2003 17:10:36]:Execute SQL =select all SMS_CM_RES_COLL_SMS000HS.ClientType,SMS_CM_RES_COLL_SMS000HS.Domain,
SMS_CM_RES_COLL_SMS000HS.IsAssigned,SMS_CM_RES_COLL_SMS000HS.IsClient,
SMS_CM_RES_COLL_SMS000HS.IsDirect,SMS_CM_RES_COLL_SMS000HS.Name,
SMS_CM_RES_COLL_SMS000HS.MachineID,SMS_CM_RES_COLL_SMS000HS.ArchitectureKey,
SMS_CM_RES_COLL_SMS000HS.SiteCode,SMS_CM_RES_COLL_SMS000HS.SMSID from _RES_COLL_SMS000HS AS SMS_CM_RES_COLL_SMS000HS
where SMS_CM_RES_COLL_SMS000HS.MachineID = 20
This behavior is by design.
APPLIES TO
- Microsoft Systems Management Server 2003
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate