ZAM Searches are Slow in Retrieving Data

  • 7004178
  • 12-Aug-2009
  • 27-Apr-2012

Environment

Novell ZENworks Asset Management 7.5 (ZAM)
Microsoft Windows Server 2003
Microsoft SQL 2005

Situation

Database searches are taking several minutes (10 minutes or more) to return results.
No errors are seen.

Resolution

Enable the Microsoft SQL Server Browser Service (sqlbrowser) on the database server.

Additional Information

Using SQL Server Browser
http://msdn.microsoft.com/en-us/library/ms165724(SQL.90).aspx

How to: Start and Stop the SQL Server Browser Service
http://msdn.microsoft.com/en-us/library/ms165734(SQL.90).aspx


(These links are provided as a courtesy. Novell is not responsible for, and does not endorse in any way, the content of external internet sites)