in addition to being a standalone product, idera offers a free upgrade to sqldm for sql server 2000/2005. if you already have a spotlight license, you can upgrade your license. idera also offers sqldm enterprise for sql server 2000/2005 and express for sql server 2000/2005.
idera also offers online access to sqldm for sql server 2000/2005. this is especially useful for systems administrators who prefer to monitor sql server from their desktop. you can access sqldm over the web as a remote desktop, or via secure http or ftp. you can download sqldm for sql server 2000/2005 from the idera web site. this requires a spotlight license.
at $595, sqldm enterprise is the more expensive product, and the one that idera markets as the enterprise monitoring solution. sqldm enterprise is designed to be used with an existing sql server installation. it provides monitoring features for all sql server components, including the sql server agent, the sql server browser, sql server agent service, and the sql server browser service. sqldm enterprise provides a complete set of performance and health metrics for the system. it also provides several management features such as the ability to restart services and restart sql server. sqldm enterprise also provides alerts on sql server metrics, but unlike spotlight, it provides two alert types: alert and critical alert.
sqldm enterprise is very comprehensive and has a lot of flexibility. unfortunately, because of the large number of sql server components that it monitors, this can be a real chore to keep track of. the sqldm web page contains very comprehensive documentation that explains exactly what each component does. it also has a large number of screenshots, which are a very good reference. i found the icons that are used to represent various components and metrics very useful for remembering what components are monitored. 3d9ccd7d82