Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SNMP 1

Status
Not open for further replies.
marvin51796

marvin51796

MIS
Jun 26, 2002
102
US
Does anyone know if sybase uses SNMP, and can you setup something like MRTG to monitor sybase???
If So could you please give me some documentation or direction in this please
thnxs
 
Sort by date Sort by votes
AFIK, Sybase does not recognize or use SNMP messages (since it uses the network purely for communication of commands that are couched in Transact-SQL; it's not a network component per se). If you let us know what kind of monitoring you have in mind, someone may be able to suggest something.

BOL,

J M Craig
Alpha-G Consulting, LLC
nsjmcraig@netscape.net
 
Upvote 0 Downvote
My Boss uses MRTG and was wanting to know if we could setup some sorta interfaces to monitor growth of database like useing a sp_help databasename, but to make it available for other people to view without them logging into the database. Just something to monitor the database..
Thnxs for any help

 
Upvote 0 Downvote
Hmmm. You might consider having a process inside Sybase that's just a loop that wakes up once a day or something of the like (perhaps via the WAITFOR command) and executes some commands and then e-mails the results to an address that is a list (that could distribute the information passively, so to speak). See the info on extended stored procedures (I think there's even an example of e-mailing stuff in the Learning Transact-SQL guide, but I don't remember for sure--it's not hard in many environments).

AFIK, there's no a good way to invoke commands inside Sybase without being logged in. However, you could have a script or batch file that performs a series of monitoring commands that various folks could execute. On Unix I suppose you could give execute permission without allowing normal read permission (so they wouldn't be able to get at the login). In any case, you could create a login which only had permission to execute a few, innocuous commands and then you wouldn't have to worry about people getting hold of the user id and password.

If any other ideas occur to me, I'll try to remember to post them.

HTH,

John J M Craig
Alpha-G Consulting, LLC
nsjmcraig@netscape.net
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

emericklaw
  • Locked
  • Question
SNMP on Adaptive Server Anywhere 7
Replies
0
Views
17
emericklaw
emericklaw

Part and Inventory Search

Sponsor

Back
Top