Posts Tagged ‘Troubleshooting’

NTCMD Discovery on Windows 2008 R2 Nodes

As of uCMDB 9.03, CUP1, Host Resources and Applications discovery will fail if executed against Windows 2008 R2 nodes with the NTCMD protocol.

xCmd v1.01 for NT4/2000 – executes commands remotely
Freeware! 2001 Zoltan Csizmadia
Connecting to remote service … Failed to start remote service
Couldn’t start remote service
Failed with error code:5
Access is denied.
Remote service executable is deleted.

To overcome this, a local administrator user needs to be created on each 2008 R2 host (admin privilege will not work).  Create a OS user as built in user and set the registry as per below:

To disable UAC remote restrictions, follow these steps:

  1. Click Start, click Run, type regedit, and then press ENTER.
  2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
  3. If the LocalAccountTokenFilterPolicy registry entry does not exist, follow these steps:
    • On the Edit menu, point to New, and then click DWORD Value.
    • Type LocalAccountTokenFilterPolicy, and then press ENTER.
  4. Right-click LocalAccountTokenFilterPolicy, and then click Modify.
  5. In the Value data box, type 1, and then click OK.
  6. Exit Registry Editor.

For more information, please visit:

Fragmented MSSQL uCMDB Tables

Run this command as regular select statement from table, for example:

select * from sys.dm_db_index_physical_stats (DB_ID('Database_Name_Here'), object_id('Table_Name_Here'), NULL, NULL, 'SAMPLED')

The Avg_fragmentation_in_percent column returned by sys.dm_db_index_physical_stats is the logical and extent fragmentation of the index.

For more information about sys.dm_db_index_physical_stats, see Microsoft SQL Server 2005 Books Online at:

Handling Fragmentation

The table column Avg_fragmentation_in_percent returned by sys.dm_db_index_physical_stats reflects the degree of fragmentation per index. Based on this value, you can determine whether to handle the fragmentation and which method to use in handling it.

Use the following rough guidelines to determine the best method to correct
the fragmentation:

  • Between 5% and 30%. Use the ALTER INDEX REORGANIZE command to reorganize the index. Index reorganization is always executed online.
  • Greater than 30%. Use the ALTER INDEX REBUILD command to rebuild the index. Index rebuilding can be executed online or offline. Rebuild the indexes online to achieve the availability similar to that of the Reorganize option.

Very low levels of fragmentation (less than 5%) should not be addressed by either of these commands due to the negligible benefit gained from removing such a small amount of fragmentation.

For more information on defragmenting indexes, refer to "Reorganizing and Rebuilding Indexes" under Designing and Implementing Structured Storage in SQL Server Books Online (link).

Return top