SQL Server Performance

SQL DBA to biztalk Server

Discussion in 'SQL Server 2008 General DBA Questions' started by starwarsbigbang, Dec 16, 2009.

  1. starwarsbigbang New Member

    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 ?
  2. satya Moderator

    Good luck and that is good news that your skill set is sprawl across other BI related tools from Microssoft.
    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.

Share This Page