Google Answers Logo
View Question
 
Q: Sybase database performance/availability info script ( No Answer,   0 Comments )
Question  
Subject: Sybase database performance/availability info script
Category: Computers > Software
Asked by: observer_ip-ga
List Price: $150.00
Posted: 28 Feb 2006 10:36 PST
Expires: 30 Mar 2006 10:36 PST
Question ID: 701921
Please, provide script allowing to receive below data from SYBASE 12/15

Has Cold load failed
Has Warm backup failed
Has SRDF failed
Has Disk mirroring on cluster failed
Is Database available

Measure tempDB size
Measure remaining database space 

% of space used up on data device
% of space used up on log device

Database SLA Compliance (general method)

# of Deadlocks per second
# of blocked users or processes

Average end-user response time
Average db response time
Log of users accessing DB
# of locks per second
# of full table or index scans per second

Determine the largest worktable created in tempDB within each hour
Data Cache Hit ratio
Procedure Cache Hit ratio
Logical I/O
Top 10 Users 
Top 10 tables by locking activity
Top 10 most used queries
Top 10 queries by duration
Top 10 most used stored procs
Top 10 stored procs by duration
Top 10 connections by duration
Total connections
Active connections
Network In
Network Out
Network I/O delay count

Has Sybase license expired

Top 10 Fragmented tables 
Top 10 fragmented index's 
Total Number of queries per day
Committed Transactions
Transaction Profile
List of all sql's fired every 24 hours. This should be in a replayable form.
Engine utilization per engine
Device utilization
Storage utilization
Worker process mem failure
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy