퀘스트 커뮤니티
전문가 문의, 최근 이슈에 대한 토론, 관심을 가지고 있는 제품 등 다양한 활동을 할 수 있습니다.
지금 가입하세요 »
퀘스트의 지원 서비스
  • 전 세계적인 지원
  • 최상의 엔지니어
  • 고객 만족에 대한 약속
  • 유연한 지원 서비스
자세한 정보 »

Spotlight on Sybase ASE

Sybase 문제 실시간 진단

As a Sybase DBA, you need a real-time graphical display of the critical components in your database environment, and that’s exactly what Spotlight® on Sybase ASE provides. 이를 통해 사용자는 I/O 및 사용자 활동을 이해하고, 어느 때보다도 신속하게 문제를 식별 및 해결할 수 있습니다. 또한, 이를 통해 대부분 사용자의 시간 소모적인 수동 작업 시간을 단축할 수 있습니다.

  • 고유한 그래픽 인터페이스를 통해 데이터베이스 및 운영 시스템 활동을 실시간 관찰합니다.
  • CPU 사용률, I/O 사용률 또는 차단 프로세스에 기반하여 문제 있는 사용자를 찾습니다.
  • 히스토리 브라우저를 통해 성능 진단을 기록 및 재생합니다.
  • 각 Adaptive Server에 대한 경보 레벨을 수동적으로 보정하는 필요성을 최소화합니다.
  • 자세한 진단 및 신속한 문제 해결을 위한 능동적 경보를 통해 문제 해결 시간을 단축합니다.
  • 여러 개의 Sybase Adaptive Server를 동시에 모니터링합니다.

System Requirements

Before installing Spotlight for Sybase ASE, ensure your system meets the following minimum hardware and software requirements:

Platform233 MHZ minimum
Memory128 MB of RAM minimum; 256 MB of RAM recommended
Hard Disk Space50MB
Monitor1280 x 1024 or higher
Note: You should also set the display to use the 64K color palette (65536 colors) or higher.
Sound Card and Speakers Use to sound an alert when a threshold is reached.
Operating SystemMicrosoft Windows 2000 Service Pack 4 with Update Rollup 1 or later
Microsoft Windows XP Service Pack 1 or later
Microsoft Windows Server 2003 R2
Microsoft Windows Vista
Microsoft Windows 7
Microsoft Windows 2008
Microsoft Windows 2008 R2
Database ClientThe installation program will install a database client if one is not installed.
Database Server Adaptive Server 11.9.2 or later
Adaptive Server Enterprise (ASE) 15.7

Language Supported:

  • US English

Take a tour of Spotlight on Sybase ASE

스크린샷 1/13

스크린 샷 #2 스크린 샷 #3 스크린 샷 #4스크린 샷 #5 스크린 샷 #6스크린 샷 #7스크린 샷 #8스크린 샷 #9스크린 샷 #10스크린 샷 #11스크린 샷 #12스크린 샷 #13

Main Spotlight on Sybase ASE Window

The main Spotlight on Sybase ASE window provides a quick and intuitive view of the activity of a Sybase instance.

The Spotlight on Sybase ASE window helps you locate system bottlenecks quickly. Related server statistics are grouped together on panels that are connected by a series of graphical flow and icons. Spotlight on Sybase ASE updates these flows in real time so that you can see how quickly data is moving through the system. The icons change color as their values move through the range of thresholds.

The following graphic shows the main features of the Spotlight on Sybase ASE window.

이미지 1/13 Main Spotlight on Sybase ASE Window

Alarm Log

The Alarm Log page displays a table of logged alarms for your defined Spotlight connections. When you first open the Alarms Log, the Connection control displays the name of the current connection.

You can:
  • View alarms for a specific connection.
  • Filter the Alarm Log table so that all, some, or none of these alarms are displayed.
이미지 2/13 Alarm Log

데이터베이스

The Database Summary drilldown provides access to information about:

  • Number of databases
  • Size of the fullest database, transaction log, and temp DB being monitored
  • Percentage of space being used by the fullest database, transaction log, and temp DB being monitored
이미지 3/13 데이터베이스

Engine_CPU

The CPU Summary drilldown provides access to information about the amount of time the ASE spends on server-related tasks and the number of engines configured.

이미지 4/13 Engine_CPU

Engine_Wait

The Wait Summary sub-page provides charts that illustrate details for the following:
  • Server Wait Count - The total number of wait events for the adaptive server.
  • Server Wait Time (msec) - The amount of time the adaptive server has spent in a wait state.
  • Engine Wait Count - Comparison of the number of times processes have waited on respective engines.
  • Engine Wait Time (sec) - Comparison of the amount of time processes have spent waiting on respective engines.
이미지 5/13 Engine_Wait

Error_Log

The Error Log drilldown provides access to details about error messages for the ASE you are diagnosing.
이미지 6/13 Error_Log

HistoryBrowser

An important feature within Spotlight is the ability to display, collect and replay the behavior of a Spotlight connection at a specified point in time such as when an important alarm was raised.

The details shown via the History browser are identical in format to those displayed by Spotlight in its "live" state, so you can view historical data in the same way as you would view a live connection.

이미지 7/13 HistoryBrowser

Lock_Lock/DeadLock

The User Locks drilldown provides access to information about the number of lock waits that exceed the Lock Wait threshold, the number of locks in use, and the number of deadlocks detected on the ASE.
이미지 8/13 Lock_Lock/DeadLock

Lock_Lock/DeadLock

The User Locks drilldown provides access to information about the number of lock waits that exceed the Lock Wait threshold, the number of locks in use, and the number of deadlocks detected on the ASE.
이미지 9/13 Lock_Lock/DeadLock

Network

The Network drilldown provides access to information about the number of packets sent and received by the ASE.
이미지 10/13 Network

ServerConfig

The Server Configuration drilldown provides general information about the server machine including login, settings for ASE configuration elements, alarms, and error logs.
이미지 11/13 ServerConfig

UserPerformance/ UserWaitEvent

The Process Activity drilldown provides access to details of user connections, problem users, and processes running on an ASE.
이미지 12/13 UserPerformance/UserWaitEvent

UserPerformance/ UserWaitEvent

The Process Activity drilldown provides access to details of user connections, problem users, and processes running on an ASE.
이미지 13/13 UserPerformance/UserWaitEvent
 

자세한 정보

관련 제품

제품 지원