Microsoft SMS 1.2 Management: Best Practices

Monday Jan 18th 1999 by ServerWatch Staff
Share:

Microsoft SMS is a systems management solution that provides an array of tools for LAN administrators to monitor and manage their network. From remote control to software distribution, SMS has satisfied a niche that has long been a problem for administrators - control over the hundreds or thousands of machines under their responsibility.

by Mike Lubanski

Introduction

Microsoft SMS is a systems management solution that provides an array of tools for LAN administrators to monitor and manage their network. From remote control to software distribution, SMS has satisfied a niche that has long been a problem for administrators - control over the hundreds or thousands of machines under their responsibility.

With the increased use of SMS for LAN management and business-critical application packaging and deployment, it is important to develop a plan for ongoing systems monitoring, management and troubleshooting. The type of management plan needed depends on many factors including size, criticality and usage of the system. Both the firm's support organization as well as the LAN administrators can determine this need. Since Microsoft SQL server operates as the engine of SMS, it is important to monitor and manage both systems, regardless of whether or not they are on the same machine or different boxes.

I developed these monitoring requirements because of both the business criticality of deployment services as well as some problems that were encountered when it was too late to prevent them, such as a failed software distribution. With some monitors in place, problems and, more importantly, outages can be prevented and operations can be notified at a stage when they have enough time to proactively react with enough time to fix the problems. The resulting document, excerpted below, covers systems management of the distribution systems.

Prerequisites and Assumptions

There are several prerequisites and assumptions that should be met in order to proceed with the monitoring.

  1. The SNMP service must be installed and configured on each server. The SNMP trap destination must be configured to point to a network management console where traps can be viewed, sort or acted upon by the support organization.
  2. To track any disk performance monitors, be sure that disk monitoring is enabled by executing "diskperf -y" on the target machine.
  3. The SQL specific counters should be installed on all SQL Servers. This is normally done through product installation. If SQL counters are not available, notify the SQL Administrator of that machine to ensure counters are visible.
  4. Each server must be installed with the SMS client component. This provides the event-log-to-trap translation e.g. all events added through the event-log-to-trap via the SMSADMIN console will send traps to the Network/Systems Management Console.
  5. The SMS specific counters should be installed on the SMS Site Servers using the fiperf.bat file and other associated files from the BackOffice Resource Kit. This will add the "SMS-Files" counter to the performance monitor. See more details in Appendix A.
  6. The SQL server is configured to send email when it has completed certain predefined tasks or if predefined alerts are triggered.
  7. This document assumes the use of SMS version 1.2 with service pack 3 or later and SQL Server 6.5 with Service Pack 3 or later on Windows NT 4.0 with Service Pack 3 or later.

 

SMS Management

Severity Legend:

1 = High priority, notify immediately

2 = Medium priority, notify within 1 hour

3 = Low priority, notify within 24 hours.

Problem Description

Method of Detection

Recommended Action

Severity

Monitoring Interval

Threshold

SMS Health Check          
SMS Remote Control Agent stopped Monitor the SMS Remote Control Agent service Attempt to restart the Remote Control service automatically. If still unable to restart, check the NT Event Log for any error messages and attempt to restart the service manually. 1 if failed.

3 if successful

15 min.

1

SMS Hierarchy Manager stopped Monitor the SMS Hierarchy Manager service Attempt to restart SMS Hierarchy Manager Service automatically. If still unable to restart, check the NT Event Log for any error messages and attempt to restart the service manually. 1 if failed.

3 if successful

15 min.

1

SMS Executive service stopped Monitor the SMS Executive service Attempt to restart SMS Executive service automatically. If still unable to restart, check the NT Event Log for any error messages and attempt to restart the service manually. 1 if failed.

3 if successful

15 min.

1

SMS Client Config Manager

Monitor the SMS Client Config Manager

service

Attempt to restart SMS Client Config Manager service automatically. If still unable to restart, check the NT Event Log for any error messages and attempt to restart the service manually. 1 if failed.

3 if successful

15 min.

1

SMS Inventory Agent stopped Monitor the SMS Inventory Agent service Attempt to restart SMS Inventory Agent service automatically. If still unable to restart, check the NT Event Log for any error messages and attempt to restart the service manually. 1 if failed.

3 if successful

15 min.

1

SMS Package Command Manager NT stopped. Monitor the SMS Package Command Manager NT service Attempt to restart SMS Package Command Manager NT service automatically. If still unable to restart, check the NT Event Log for any error messages and attempt to restart the service manually. 1 if failed.

3 if successful

15 min.

1

SMS Site Config Manager stopped Monitor the SMS Site Config Manager service Attempt to restart SMS Site Config Manager Service automatically. If still unable to restart, check the NT Event Log for any error messages and attempt to restart the service manually. 1 if failed.

3 if successful

15 min.

1

SNMP service down Monitor the SNMP service Attempt to restart the SNMP service automatically. If still unable to restart, check the NT Event Log for any error messages and attempt to restart the service manually. 1 if failed.

3 if successful

15 min.

1

SNMP trap service down Monitor the SNMP trap service Attempt to restart the SNMP service automatically. If still unable to restart, check the NT Event Log for any error messages and attempt to restart the service manually. 1 if failed.

3 if successful

15 min.

1

Runaway SMS Process Monitor the CPU and memory usage of SMSEXEC Process on the Servers using perfmon counters. From the PROCESS object, add the counter '% Processor Time' for all instances that are SMS processes (INVWIN32, PCMSVC32, PREINST, SITEINS, SMSEXEC). Check all of the SMS services. Restart services that are down in proper order. Gracefully reboot server if necessary.

1

30 min.

1

 

Problem Description

Method of Detection

Recommended Action

Severity

Monitoring Interval

Threshold

SQL Server Connectivity          
Could not obtain a SQL Connection Monitor the Application event log ID 17, specific trap ID 3221225489 Check the SQL Server and make sure it is up and the MSSQLServer and SQL Executive services are running.

1

15 min.

1

SQL connection broken Monitor the Application event log for event ID 243, specific trap ID 3221225715 Check the SQL Server and make sure it is up and the MSSQLServer and SQL Executive services are running.

1

15 min.

1

SQL connection reestablished Monitor the Application event log for event ID 244, specific ID 3221225716 Make sure you can log into the SMS database through the SMSAdmin console.

3

15 min.

1

Site Communication Management          
Cannot connect to remote site when getting inventory information. Monitor the Application event log for event ID # 251 Verify the remote site server is on the LAN and the shares are visible and have all the necessary permission for the SMS service account.

3

30 min.

3

Job Management          
Job does not start to execute within an hour i.e. it does not change from pending to active. Monitor SMS specific logs e.g. sched.log, hman.log on the Site Server. Trace the specific log file using smstrace.exe to investigate the exact cause of the problem. For example, if there is a backlog of jobs and the job is not getting executed check the \sms\logs\sched.log on the Site Server.

2

30 min.

1 hour

Too many active jobs Monitor number of active jobs through SMSADMIN Console Trace the specific log file using smstrace.exe to investigate the exact cause of the problem. For example, if there is a backlog of jobs and the job is not getting executed check the \sms\logs\sched.log on the Site Server.

2

30 min.

50

Too many pending jobs Monitor the number of pending jobs through SMSADMIN Console Trace the specific log file using smstrace.exe to investigate the exact cause of the problem. For example, if there is a backlog of jobs and the job is not getting executed check the \sms\logs\sched.log on the Site Server. If you need to remove the jobs, make sure you cancel the jobs before deletion.

2

30 min.

50

Too many failed or retrying jobs Monitor the number of pending jobs through SMSADMIN Console Trace the specific log file using smstrace.exe to investigate the exact cause of the problem. For example, if there is a backlog of jobs and the job is not getting executed check the \sms\logs\sched.log on the Site Server.

2

30 min.

25

 

 

Problem Description

Method of Detection

Recommended Action

Severity

Monitoring Interval

Threshold

Inventory Management          
Duplicate SMS ID's

The same computer name appears next to different SMSIDs in the Sites window.

The message "Unable to Locate clientname" appears after "Trying Additional Protocols"

Application Event Log ID 86 Select the most recent occurrence of the computer name and see if SMS can locate it. If so, delete the older occurrence of the computer name. You should remove or merge your duplicate inventory, using DBCLEAN.

If the problem persists, check to see why the SMS.INI file is being deleted, or why it is being locked during the verification process.

3

N/A

1

Disk Space Management          
Not enough disk space on the SMS Site Server in the following directory :

Sms\site.srv\dataload.box\deltamif.col\*.*

Monitor disk space and file count on the drive SMS is installed on and monitor the following directories using SMS-Files perfmon counter. Refer to Appendix D

1

2

3

1 hour

90 %

80 %

70 %

Not enough disk space on the SMS Site Server in the following directory :

Sms\site.srv\dataload.box\deltamif.col\process\*.*

Monitor disk space and file count on the drive SMS is installed on and monitor the following directories using SMS-Files perfmon counter. Refer to Appendix D

1

2

3

1 hour

90 %

80 %

70 %

Not enough disk space on the SMS Site Server in the following directory :

Sms\site.srv\dataload.box\badmifs\*.*

Monitor disk space and file count on the drive SMS is installed on and monitor the following directories using SMS-Files perfmon counter. Refer to Appendix D

1

2

3

1 hour

90 %

80 %

70 %

Not enough disk space on the SMS Site Server in the following directory :

Sms\site.srv\inventory.box\badmifs\*.*

Monitor disk space and file count on the drive SMS is installed on and monitor the following directories using SMS-Files perfmon counter. Refer to Appendix D

1

2

3

1 hour

90 %

80 %

70 %

Software Distribution Management          
Software package fails to be created Monitor event ID 109 in the Application Log. 1.Make sure that the package source directory is available.

2.Make sure there is enough disk space on Distribution Server. If software package is x MB, there should be at least 4x MB disk space available on the Distribution Server

1

30 min.

1

Software package fails to deliver Monitor event ID 108 in the Application Log. 1.Verify distribution server is up and running

2.Verify the availability of the LANSENDER and check network connectivity.

3.The SMS service account must exist on the package server and have the same password as the site server, and the service account must have admin privileges.

1

30 min

1

Windows NT Management          
Paging too high Monitor the paging frequency of the operating systems (page file usage) Excessive paging requires the need for upgrade of memory.

2

10 min.

> 30%

Paging too high Monitor the context switches per sec

Context Switches/sec is the rate of switches from one thread to another. Thread switches can occur either inside of a single process or across processes. A thread switch may be caused either by one thread asking another for information, or by a thread being pre-empted by another, higher priority thread becoming ready to run.

Switching to the subsystem process causes one Context Switch in the application thread. Switching back causes another Context Switch in the subsystem thread.

Check the thread and handle count for the SMS processes. High context switching may be indicative of a runaway process.

2

10 min.

>30 %

Paging too high Monitor the pages in and out per second High Paging is indicative of memory problems.

2

10 min.

>30 %

Low logical disk free space Monitor the logical disk space of the SMS machine. Delete unnecessary files to free up more disk space. Install new disk space if necessary.

1

2

3

15 min.

90%

80%

70%

CPU Queue Length too high Monitor the overall queue length of the CPU over a prolonged period of time. Use Performance Monitor to identify CPU bottlenecks and rectify as necessary

2

15 min.

> 2

Physical Disk Queue Length too high Monitor the overall queue length of the physical disks over a prolonged period of time. Check disks for potential problems

2

30 min.

> 2

 

SQL Server Systems Monitoring

The following information is for SMS-specific SQL Server problems.

Problem Description

Method of Detection

Recommended Action

Severity

Monitoring Interval

Threshold

Database Maintenance          
SMS Servers are performing slowly Jobs take very long time to execute
  1. Check for any SMS related hung processes through task manager
  2. Use the sendcode utility from the Backoffice resource kit : sendcode SMS SITE CONFIG MANAGER 192. This will jump-start the SMS Site Config Manager.
  3. Reset the Site.

1

N/A

N/A

Backlog of data(MIF) files.

File count is too high in the following directories: \sms\site.srv\dataloader.box\deltamif.col

\sms\site.srv\dataloader.box\deltamif.col\process

The ..SMS\Logs\Datalodr.log and the Windows NT Application Event Log on both the SQL Server computer and the Systems Management Server site server provide information about possible causes. You should also check the SQL Server error log. Run following query in ISQL window: SELECT COUNT(*) FROM MachineDataHistoryTable

If result is >100000 perform maintenance to the SMS database. Refer to Appendix D and B

1

24 hours

>5000

SMS Database space is low Use transact sql stored procedure to detect this Extend the database space

1

30 min

< 20 % of database size

SMS Log Space is low Monitor the perfmon counter SQL Server-Log space used % in the SQL Server-Log Object Increase the log device space through SQL Enterprise Manager

1

30 min

< 20 % of log size

Database is paging out Monitor the perfmon counter Cache Hit Ratio. It should be more than 95%. Check the amount of memory dedicated to SQL.

1

30 min

95%

Database Backup Maintenance          
SMS database backup fails An email is generated if the backup of the SMS database fails Check for the dump device and see if there is any disk space problems or other hardware problems

1

24 hours

1

SMS database restore fails An email is generated if the restore of the SMS database fails Check for the dump device and see if there is any disk space problems or other hardware problems

1

24 hours

1

 

Appendix A: FIPERF.BAT: Add File Counters to Performance Monitor

FIPERF adds counters to Performance Monitor that monitor the number, size, and age of files in various directories. This ability is particularly useful in SMS to monitor directories such as SMS\SITE.SRV\DATALOAD.BOX\DELTAMIF.COL.

The name of the new Performance Monitor object is SMS Files. Look at the Explain text in Performance Monitor for definitions of the counters. FIPERF must be run on the computer running the SMS site services.

Usage Notes:

  • Do not run these counters with too small a polling interval, which adversely affects server performance because the server continuously scans directories. A reasonable minimum polling interval is one minute, but one hour is recommended.
  • The directories that are monitored are stored in the Registry in \\hkey local machine\system\currentcontrolset\SMS Files\Linkage. Add or remove items from this list if you wish (see next note).
  • Due to the nature of Performance Monitor, whenever you bring up a list of counters, the counter DLLs are called to return data. This means that a scan of all the directories is performed. If these directories have many files, this could take from a few seconds to a few minutes. If you find that there is a large delay and that there are directories that you do not want to monitor, remove them from the Linkage key.

Removing FIPERF

To remove this software, run the following command (unlodctr is provided with Windows NT):

unlodctr SMS Files

Do not simply delete the Registry keys; you could lose other Performance Monitor counters.

Files required for FIPERF

FIPERF.DLL

SMSPERF.DLL

The following files are required for installing the SMS Files counter, but can be removed after installation:

FIPERF.BAT

FICTRNM.H

FI.INI

 

Appendix B: Regular SMS Database Maintenance

In order to keep a Systems Management Server site server and it interactions with SQL server operating at peak efficiency, it is necessary to perform periodic maintenance on the SMS database. This is especially important for central site databases that store large volumes of data.

The following maintenance items should be performed approximately every 4 weeks.

PERFORMING MAINTENANCE ON THE SMS DATABASE

Stop the following SMS services on the SMS Site server in the following order:

  1. SMS Executive
  2. SMS Site Config Manager
  3. SMS Hierarchy Manager
  4. All other SMS services running on the site server.
  1. Close all utilities that make a connection to the SMS database (i.e. SMS Administrator, SMS Database Manager, etc.)
  2. (Optional) If a backup of the site has not been made recently, do so with the following steps:
  1. Locally, at the Site Server, run REGEDT32.EXE. Highlight the SMS registry key and choose Save Key from the Registry menu: \HKEY LOCAL MACHINE \SOFTWARE \Microsoft \SMS
  2. Use SQL Enterprise manager to dump (or backup) the SMS database and the master database. Select Tools, Database Backup/Restore.
  3. Make a file backup of the \SMS directory structure on the SMS site server.

NOTE: Before and after major database operations, always consider running these database consistency checker commands from ISQLW:

  • dbcc checkdb
  • dbcc newalloc
  • dbcc checkcatalog

This will help insure that the operations will go smoothly, and that no damage occurred during the operation. This is especially important in providing intact database backups. This will help cleanup unused allocations, and detect errors in the database. These queries can take a long time to complete on very large databases. System performance and the size of the SMS database determine the actual time required.

  1. First from ISQLW run
  1. "use sms" - this will select the sms database
  2. "dbcc updateusage(0)" - this is done so that sp spaceused will report the current numbers correctly. Normally this only needs to be run after rebuilding the indexes. If not run after rebuilding the indexes, sp spaceused will just report the old numbers as they were before rebuilding the indexes.
  3. "sp spaceused" - this will display the current database size, unallocated space, data size, index size and unused space. Save the results for comparison. By analyzing the results of these cleanup procedures an SMS administrator will be able to determine how frequently a specific site should be cleaned up. If the database size is reduced by less than 10%, then the administrator should probably wait longer the next time before taking the time to do these cleanup procedures.
  1. Use the SMS Administrator utility to Delete Machine History older than 60 days. (In SMS Administrator, with the Sites window active, choose Edit, Delete Special, and then choose Machine History from the pop down menu.)
  2. IMPORTANT NOTE: It is possible to delete too much history information at one time (the amount that can be deleted at one time is determined by the size of the transaction log on the SMS database). Therefore, when deleting large amounts of history records, delete them in increments. For example, if you wanted to delete history records older than 60 days and you know that you have history information extending well past that point (i.e. 260 days), you would begin by deleting machine history older than 240 days, then 210 days, 180 days, 150 days, etc. until the desired 60 days of history is reached.

If you try to delete too much information at one time, you might get the "Couldn't complete the specified query" error in SMS Admin. This means that the transaction log did not have enough free space to process this mass delete. You can either dump the transaction log by right clicking on SMS database in SQL Enterprise Manager, select Edit, in the Edit Database window, select "Truncate" under Transaction Log. Alternatively, you can expand the size of the transaction log by selecting Expand.

  1. Again from isqlw run
  1. "dbcc updateusage(0)" and
  2. "sp spaceused" with the SMS database selected as default and save the results for comparison.
  1. Delete inactive machines in SMS Administrator. If inventory is reported regularly, it also a good idea to delete inactive machines from the database. In SMS Administrator, with the Sites window active, choose Edit, Delete Special, and then ensure that 'Machines with last activity' is the option selected. Be careful not to enter a date or period that is too recent. For example, For both Tier I and Tier II you should delete systems that have been inactive for 60 days. Close the SMS Administrator utility.
  2. Again from isqlw run
  1. "dbcc updateusage(0)" and
  2. "sp spaceused" with the SMS database selected as default and save the results for comparison.
  1. Delete duplicate machines in SMS Database Manager. If the SMS client is reinstalled on the same system, this can result in duplicate inventory records in the SMS database. Since only one record in the database can be active for a specific machine, the previous step to delete inactive machines would eventually delete duplicates as they aged in the database. Duplicate machines can also be viewed and deleted from the SMS Database Manager utility. Open the SMS Database Manager utility, select Machines, Display Duplicate Computers, click on Name, and delete all but the most recent entry for each machine listed. You can also highlight the duplicate machine records and select "Merge history for selected PCs" from the Edit option to merge duplicates. This would delete all the old inventory records and only keep the newest machine record. If necessary, repeat these steps for the systems listed under NetCardID.
  2. Again from isqlw run
  1. "dbcc updateusage(0)" and
  2. "sp spaceused" with the SMS database selected as default and save the results for comparison.
  1. From the SMS Database Manager utility, select Tools, then Delete Unused Common/Specific Records. This actually purges the deleted records in SQL and will reclaim space in the SMS database so that SQL server can reuse it. This procedure can take a long time as well. The amount of time required depends on how often the procedure is performed and how much space is going to be reclaimed. This procedure should be performed every 90 days .Close the SMS Database Manager utility.
  2. Again from isqlw run
  1. "dbcc updateusage(0)" and
  2. "sp spaceused" with the SMS database selected as default and save the results for comparison.

If any machines or records were removed, the indexes need to be rebuilt to remove the old index entries. You can skip steps 13 and 14 if many machines or records were not deleted from your site.

  1. Reducing the index space used by an SMS database: On a large central site that had been in use for several months, rebuilding the indexes reduced the space used by indexes by 50%, and total space used by the database went from 305megs to 225megs. The actual amount of reduction will depend on how many records have been deleted since the last time the indexes were rebuilt, and how fragmented the indexes have become. This will reduce paging, which will help avoid a disk bottleneck and reduce the disk space used by the SMS database and its backups. This procedure should be performed every 90 days.
  2. Use the SQLMAINT.EXE utility to rebuild the SQL indexes on the SMS database. This utility is supplied with SQL Server 6.5 and is located in the \MSSQL\BINN directory. With \mssql\binn\sqlmaint.exe in the path; from the NT CMD command line run:

    SQLMAINT.EXE -S h1grsvr -D smsdb -RebldIdx 10 -Rpt c:\dbmaint.rpt

    Where h1grsvr is the name of the server that SQL is on, smsdb is the name of the SMS database on which all indexes for all tables will be rebuilt, 10 is the percent of free space that will be left in the indexes, and C:\dbmaint.rpt is the location for the log reporting results. The procedure builds a table of all index information for the database, and then walks through rebuilding each index individually.

  3. Then with the SMS database selected as default, from isqlw run
  4. "dbcc updateusage(0)"

    This is done so that sp spaceused will report the current numbers correctly. If not run, sp spaceused will just report the old numbers as they were before rebuilding the indexes. Then again from isqlw run "sp spaceused" with the SMS database selected as default, and see the results. There should be large savings in index space used (unless this was recently done).

    (Optional) If all of the maintenance tasks have completed without errors, this is another good point to create a backup of the SMS system. Refer to step 3 to accomplish this if desired.

    NOTE: Before and after major database operations, always run these database consistency checker commands from ISQLW:

    dbcc checkdb

    dbcc newalloc

    dbcc checkcatalog

    This will help insure that the operations will go smoothly, and that no damage occurred during the operation. This is especially important in providing intact database backups. This will help cleanup unused allocations, and detect errors in the database. These queries can take a long time to complete on very large databases. System performance and the size of the SMS database determine the actual time required.

  5. Restart the SMS Services in the following order:
  1. SMS Hierarchy Manager
  2. SMS Site Config Manager
  3. SMS Executive
  4. d. Restart all other SMS services on the site server.

 

Appendix C :How to delete client history files:

To ensure accurate data reporting, it is recommended that you first delete the client's history file. This file is used to reduce network traffic and processing load on the server. Deleting this file will not have any negative effects on the Systems Management Server system.

To delete the history file:

  1. Determine the client's SMSID by examining its Sms.ini file (a hidden file located in the root of the client's SMS installation drive). The SMSID is stored within the [SMS] section as "SMS Unique ID."
  2. On the site server, go to the Sms\Site.srv\Inventry.box\History directory, and delete the client's history file. It is named SMSID.hms (for example, Abc00001.hms).

 

Appendix D: Troubleshooting Inventory MIF Backlog Problems

NOTE: Before you begin troubleshooting, dump the Systems Management Server and Master databases and then back up the Systems Management Server directory structure and the HKEY LOCAL MACHINE\SOFTWARE\Microsoft\SMS registry key.

Site Speed

The site speed (set in Site Properties on the Services tab) should never be set to Very Fast. A setting of Medium or Fast will process MIFs faster because the Site Configuration Manager does not have to continually perform watchdog cycles which gives the Dataloader utility a chance to run uninterrupted for a longer period of time.

SQL Server Configuration

If Open Objects is set to less than 5,000, Dataloader can get backed up. Tempdb should be 20 to 30 percent of the largest database on the SQL Server. User connections must be set appropriately. Currently they are set at 100.

For additional information about important tuning parameters, see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q166244

TITLE : SMS: SQL Server Tuning Parameters for Systems Management

Server

Use Performance Monitor to check the Cache Hit Ratio and make sure that the database is in cache (it should be above 99 percent), not paging out. Add RAM and/or dedicated memory to SQL Server if necessary.

Database and Transaction Log Size

Make sure that the Systems Management Server database and its transaction log are not full, and that the transaction log is 20 percent of the Systems Management Server database size. If the database is less than 20 percent free, failures may occur.

Services

Make sure that the Systems Management Server Executive Service is running on the site server.

Client Resynchronizations

Check the Windows NT event log for a high number of client resynchronizations (Event 186). If there are several resyncs, they may occur because duplicate SMSIDs are assigned. For additional information, please see the following articles in the Microsoft Knowledge Base:

ARTICLE-ID: Q127052

TITLE : SMS Unique ID (SMSID) Allocation

ARTICLE-ID: Q138021

TITLE : How Inventory Dataloader Finds Matching Computers in SMS

SQL Server Service Pack

Apply (or re-apply) the latest SQL Server Service Pack.

SQL Server Tracing

You can enable SQL statement input and output in the Dataloder.log by setting the

HKEY LOCAL MACHINE\Software\Microsoft\SMS\Tracing\SQL Enabled

registry parameter to 1. To disable SQL tracing, set the value to 0.

The Systems Management Server Executive service must be stopped and restarted for the change to take effect.

NOTE: SQL Tracing should be disabled when you are not performing troubleshooting steps. Leaving it enabled causes the Dataloader to slow down and the log to fill up more quickly.

DBCC Checks

Run SQL Server DBCC CHECKDB and DBCC NEWALLOC statements on the Systems Management Server database in Single User Mode.

Site Reporter

Check the ..SMS\Site.srv\Siterep.box to see if files are present. If there are, and the site is a child primary site, ensure that site-to-site communication is functioning properly. To determine this, do the following:

Look in the appropriate sender log.

Check the addresses.

Check the Windows NT Application Event Log.

Check the Outbox scheduling.

If files are present in the Siterep.box subdirectory, temporarily move them to another subdirectory to see if the MIF processing improves.

User Group MIFS

Check the SMS\Site.srv\Dataloder.box\Deltamif.col directory for UMF files. If there are several UMF files, and they are large, you probably have a large number of users, groups, or a complicated trust matrix in your environment.

You may want to change the default polling interval for user and group enumeration using the Setgug.exe utility. For additional information about the utility, please see the following articles in the Microsoft Knowledge Base:

ARTICLE-ID: Q168724

TITLE : SMS: List of Tools Available on the SMS 1.2 Compact Disc

ARTICLE-ID: Q171005

TITLE : SMS: Site Config Manager Service Locks Trusted Service

Account

MIF Size

Check the SMS\Site.srv\Dataloder.box\Deltamif.col and SMS\Site.srv\Dataloder.box\Deltamif.col\Process directories and note the MIF size. Larger MIFs (that is, MIFs that contain custom information or extensive software inventory) will be processed more slowly.

I/O Errors

  • If SQL Server devices and Systems Management Server directories are on the same drive or the drive is mirrored with a single disk controller, check for I/O disk errors reported in the SQL Server log file and/or Performance Monitor.
  • If disk I/O appears to be a bottleneck, you may need to move SQL Server devices to another physical disk drive, install a second controller, and so forth.

SMSMaint Script

Run the SMSMaint.sql script from the BackOffice Resource Kit.

SPID Performance

Monitor the SQL Server spid performance by using SQL WHO and Performance Monitor to correlate this to the Dataloader thread. For additional information, see the following article in the Microsoft Knowledge Base:

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved