[ITM6] Monitoring Agent for Microsoft SQL Server / Problem Running Multiple Agents
Martin Butler <[email protected]>
| Newsgroups | gmane.comp.sysutils.tivoli.general |
|---|---|
| Message-ID | <OF9F18A043.A2FE179D-ON85257B1A.007EAF9B-85257B1A.0080C517__539.955547037785$1361575632$gmane$org@ca.ibm.com> |
I have a Windows 2003 (64 bit) server with three varieties of MSSQL
running, and 17 unique instances, all of which have to be monitored.
I have a [standard] base OS agent and a custom OS agent installed on this
server.
After remotely pushing the SQL agent to 12 instances (SQL 2005 & 2008), all
of which worked perfectly, the thirteenth installation completed but never
showed up on the TEMS/TEPS despite running locally on the server.
The only way to get this (and any subsequent) agents to connect to the hub
was to change the protocol to ip.pipe (I want to use ip.spipe for all
agents if possible)
I think I am hitting a network port contention (baseport + N*4096) although
I expcected that on agent number 17 (not 15).
I have since tried stopping/starting agents using the MTEMS and the Service
Control Panel with varying results. In some cases, changing the protocol
from ip.spipe to ip.pipe (and back again) resolved my problem. In other
cases, this had no bearing.
Of the 12 instance agents that I originally had working, I can now only run
7 fully functional.
Is it possible that I have locked ports up ? If so, for how long ?
I have read about SKIP and COUNT modifiers to control the port search
algorithm. Has anyone had success using this on a similar scale ?
Target server:
Operating System: Windows 2003 (64 bit)
SQL Server 2000 (32 bit)
SQL Server 2005 (32 & 64 bit)
SQL Server 2008 (64 bit)
Agents
Monitoring Agent for Windows OS / 06.22.04.00 (64 bit)
Monitoring Agent for Microsoft SQL Server / 06.30.00.00
Appreciate any help.
Martin 410 Albert Street (Embedded
(M.A.) image moved to
Butler file:
pic00325.gif)
Senior IT Waterloo, Ontario
Services N2L 3V3
Professional
- Tivoli on
Demand
Services
T7Z Canada
DM
Phone: +1-519-880-2920
e-mail: [email protected]
_______________________________________________
TME10 mailing list
[email protected]
Unsubscribe:[email protected]
pic00325.gif
(image/gif, 360 B) - not displayed