Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

See How information is collected on page 25.

About viewing current Statement or Batch text

...

Association TabFunction
GeneralShows general information on the displayed statements or batches.
In SybaseShows information on performance and statistics of the displayed statements or batches.
StatisticsShows statistics of the displayed statements or batches.

See See About session states on page 25, Understanding In Sybase session states on page 25, and Understanding Non-In Sybase session states on page 27.

Anchor
HowtheCurrenttabcanhelpyouidentifyperformanceproblems
HowtheCurrenttabcanhelpyouidentifyperformanceproblems
How the Current tab can help you identify performance problems

You can identify a performance problem by doing one or more of the following :

...

actions.

...

Examining

...

Examining the resource consumption of an entire instance and database

...

  1. Observe the current state of the session and determine if it is active or waiting for a resource.
  2. Identify the session by different identifiers such as its login, the machine it is running on, or the programs it is running. The current active SQL code is displayed for active sessions.
  3. If you have hundreds of sessions running, and you want to focus your investigation on the sessions that were active in Sybase during the last minute, select Active Sessions from the Association Controls in the Association area.

Examining a single connection

You may need to explore a single running SPID, to obtain more information for it. To examine a single connection

  1. Drill down to the specific SPID in question. Continue examining its resource breakdown, its recent statements, or the batches in which the session was executed, during the last few minutes.
  2. Check if the session is blocked and by whom.


Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse