I am a SQL Server DBA and we are going to move to have to support Biztalk server also. Can anyone tell me what id the skillset I should have to support both. How different SQL Server and Biztalk server is ?
Good luck and that is good news that your skill set is sprawl across other BI related tools from Microssoft. http://msdn.microsoft.com/en-us/library/aa577454(BTS.20).aspx http://blogs.msdn.com/biztalkperformance/ FYI It is recommended to draw up a thorough server monitoring plan once you have established your baseline performance metrics for a server. A few elements that should be incorporated into a server monitoring plan are: Identify those server events which should be monitored. Determine and set up monitors and alerts to inspect the events Determine whether filters are necessary to reduce the quantity of monitoring information which you want to collect and then configure any necessary filters. Establish a logging strategy to log event data that should be analyzed. Alternatively, you can monitor and analyze server activity when it occurs. View and analyze data collected by events in the Performance console.