Install SQL Monitor 4 on Windows Server 2008 – Part 1


SQL Monitor 4 is a web-based UI application that enables you to keep track of MS SQL Servers performance and issues in real time on multiple devices anywhere with alerts.

We will install and configure Red Gate SQL Monitor 4 as follows:

  • Web Server and Base Monitor components on same server computer running Windows Server 2008, and IIS 7.0
  • Data Repository on a separate server running Windows Server 2008 and MS SQL Server 2008
  • Monitored MS SQL Servers are running Windows Server 2008 and MS SQL Server 2008

Important notes

  • The Web Server computer and Base Monitor computer both require .NET 3.5 SP1
  • If you’re using IIS, SQL Monitor’s application pool must be mapped to .NET 2.0, and not .NET 4.0
  • The SQL Monitor Web Service is not installed if you use IIS as your Web Server
  • SQL Monitor Base Monitor Service Account need Log on as a service privilege
  • Monitoring host Windows machines account should be an administrator on the machine
  • The account used to monitor your SQL Server instance should have the following permissions (For SQL Server 2005, SQL Server 2008 and SQL Server 2012):
    • member of the db_datareader role on the msdb system database
    • member of SQLAgentReader role on the msdb system database
    • member of the db_ddladmin database role on all databases (needed to run DBCC SHOWCONTIG required by the Fragmented index alert)
    • VIEW ANY DEFINITION server permission
    • ALTER TRACE server permission (if you want to enable trace data)
    • VIEW SERVER STATE and VIEW DATABASE STATE database permissions on all databases
    • sysadmin role required for Integrity check overdue alerts and to allow SQL Monitor to turn on the deadlock trace flag (this flag is required for Deadlock alerts to be raised; you can turn on the flag manually if you don’t want to enable sysadmin permissions)

Please ensure the following is performed prior to running the installation:

  • .NET 3.5 SP 1 is installed on the server where you will install the SQL Monitor 4 web server
  • Windows domain service accounts for the web server and base monitor computer is created, e.g. sqlMonitorSvc
  • A blank database for the SQL Monitor data repository is created (e.g. sqlMonitorData), and granted required role membership for the installer to setup the tables (e.g. db_datareader and db_datawriter, or simply use  db_owner)

Creating the SQL Monitor 4 Data Repository Database

  • Launch SQL Server Management Studio and connection to the database server and instance where the database will reside
  • Right click Databases and select New Database…
  • Enter the Database name and click OK
  • Expand Security > Logins
  • Right click Logins and select New Login…
  • Login name: click Search to find the Windows domain accountsqlMonitorSvc
    • Ensure Windows authentication is selected
  • Under User Mapping, and grant the following database role membership to thesqlMonitorData database:
    • db_owner

Installation

When you’re ready, kick off the SQL Monitor 4 installation and make the following selection:

  • Choose where to install components:
    Install both the Web Server and Base Monitor on this computer
  • Choose type of Web Server:
    Use existing IIS Web Server (ensure the IIS web server is detected – should see a green tick)
  • Choose location for SQL Monitor web application files
    Choose a location that will host the contents for SQL Monitor 4 web site, e.g. d:\websites\sqlmonitor
  • Set up Base Monitor
    • Install Base Monitor files to: e.g. C:\redgate\sqlmonitor\basemonitor
      (The monitoring service .exe file will be stored here)
    • Install configuration file to: e.g. C:\redgate\data\sqlmonitor
      (This location needs to be a folder to which the Base Monitor service has write access)
    • Base Monitor port number: use the default of 7399 (for security, select a custom port – need to be unused)
      (This port is used internally by the SQL Monitor monitoring service for sending data   to the Data Repository and receiving requests from the Web Server)
  • Set up Data Repository
    • Click Set up Data Repository… (use an existing SQL Server database – Recommended)
      • Database Server: hostname of the SQL Server where the SQL Monitor 4 Data Repository resides
      • Database: name of the database created for SQL Monitor 4 Data Repository
    • Connect to Data Repository database using:
      • Authentication: Windows Authentication
      • Username: <<the Windows domain account to SQL Monitor 4 Data Repository – must be in same domain>>
      • Password: <<password for the above Windows domain account>>
  • Error and feature usage reporting
    • Error reporting
      • Send error reports: <<not selected>>
    • Feature usage reporting
      • Send feature usage data: <<not selected>>

You will now see a summary of your install selection. Check to ensure they are correct, then click Install to begin the installation. Here are screenshots to help with the above steps:

sql-monitor-1 sql-monitor-2

sql-monitor-3 sql-monitor-4

sql-monitor-5 sql-monitor-7

sql-monitor-9 sql-monitor-10

After the installation has finished, follow these steps to create and configure an IIS website for SQL Monitor 4 (this is the web-based UI):

  • Launch IIS and create a new website
    • Name: <<Your own SQL Monitor 4 IIS website name>>
    • Physical path: <<location for SQL Monitor web application files selected in above installation step>>
    • Port: 8080 (or a port of your choice – needs to be not in used)
    • IP Address: <<all unassigned or select an IP Address to use>>
  • While still in IIS Manager, click on Application Pools
    • Select SQL Monitor website application pool
    • Set .NET Framework version to: .NET Framework v2.0.50727
  • Recycle the SQL Monitor application pool
  • Restart the SQL Monitor website
  • Browse the SQL Monitor website
    (should see the SQL Monitor prompt to create an administrator password)
  • Check I have completed these steps for setting up SQL Monitor on my IIS Server
  • Click Finish

Once the installation is complete and you browse the SQL Monitor website for the first time, you will be ask to create a password for the Administrator logon.

That’s the end of the installation part of Red Gate SQL Monitor 4. We will look at configuring SQL Monitor 4 in Part 2 next time.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s