Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Monitoring tools for locks and processed SQL queries?

 
   Database Help (Home) -> Sybase RSS
Next:  Help with Paradox 9 table schema  
Author Message
ola.theander

External


Since: Aug 19, 2008
Posts: 3



(Msg. 1) Posted: Tue Aug 19, 2008 5:33 am
Post subject: Monitoring tools for locks and processed SQL queries?
Archived from groups: comp>databases>sybase (more info?)

Hello everybody

I’m trying to solve a performance problem in an application that’s
using ASE 12.5 as the database engine. I suspect that it’s due to
locking of tables for certain queries that puts other concurrent
queries on queue and if these queries takes some time the other
clients will stall.

Therefore I would like to know if there is a tool that allows me to
monitor, preferable in near real-time, locks on tables including lock
type and if possible also processed SQL queries.

Any help on this issue would be most appreciated.

Regards, Ola

 >> Stay informed about: Monitoring tools for locks and processed SQL queries? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Setting up Sybase monitoring with SNMP - I know that Sybase has its own Unified Agent Framework program which should allow me to monitor Sybase using SNMP agent. I did managed to set it up but it's extremely slow. So I'm wondering if there is a way of monitoring my database server using net-snm...

test scenario: blocking locks - Hi, to test a procedure that is detecting blocking locks can anyone help me how to create a test scenario for blocks? Something like : Start SQL Statement1 for the first process Start SQL Statement2 for the second process I should have then 2..

3rd party - security tools - I'm going thru the ASE manuals for the certification test and came across the piece below on security. Any idea what 3rd party tools are available on Unix to implement such security ? TIA, Jack ********* In a distributed client/server computing..

Sybase performance monitor tools - Hello, In our installation we have around 60 production servers and 30 IQs. We are considering performance tools to be used widely in most of them (11.9 - 12.5) and 11.4 for IQ to help us improve our preventive actions in a more automated manner. Any..

optimizing sybase sql queries? - In MySQL, if you want to see what the bottle neck of an SQL query is, you can prepend the query with EXPLAIN. Does Sybase offer similar functionality?
   Database Help (Home) -> Sybase All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]