- Client health status calculated from data in the SMS database
- Real time online/offline status of SMS clients
- Summary HTML report of client health
- Microsoft Excel pivot table with details retrieved from the Client Health database that can be used to help troubleshoot client health issues
Note: The SMS Client Health Monitoring Tool will only operate with a SMS 2003 SP1 database. For more information, including other limitations and requirements, see the documentation that is included in the download. The SMS 2003 Client Health Monitoring Tool is provided as an add-on tool for diagnostic and troubleshooting purposes and is not supported by Microsoft.
the full product names for SQL Server’s BI products will be SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
BizTalk Server and SQL Server Integration Services perform different yet very complimentary functions
BizTalk Server is the key product for:
- Automating Business process that tie in applications, systems, employees, disparate technology and trading partners (BPM)
- Enterprise Application Integration (EAI)
- Business to Business Integration (B2B)
SSIS is the key product for:
- Moving Information into the SQL Server environment
- Complex transformation of data for loading into a persistent data store
- N source to N destination database loading
- Integration of data with other SQL Server products
On Win2000 a 1GB DC will benefit from the /3GB switch. The benefit would start when the DIT and RAM are both over 0.5GB and reach a maximum when the DIT is 1GB and RAM is greater than ~1.3GB. Beyond that things don't get worse, they just don't get better.
On Win2003, the benefit doesn't really start until both DIT and RAM are greater than ~1.5GB, and you reach full benefit by the time both reach ~3GB.
If the DC isn't serving some other role than needs lots of kernel space (e.g., a fileserver) then there's an upside for all but the smallest configurations and essentially no cost.