Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

performance

What are the different ways you will come to know that there is performance problem in a database..
0
thomasliju
Asked:
thomasliju
  • 2
1 Solution
 
johnsoneSenior Oracle DBACommented:
You get a phone call.  If there is a problem, users are very quick to point it out.  If nobody is complaining, it isn't a problem.
0
 
thomaslijuAuthor Commented:
If we get the complaint what we do first..
0
 
slightwv (䄆 Netminder) Commented:
>>If we get the complaint what we do first..

Call the DBA and System Administrator.

Before you post that you are the DBA or System Administrator, please don't.

This question is way to vague to answer in a Q&A site like this.

Narrow down what specfic system part is showing signs of stress:
Memory, Disk or CPU.

That is half the battle right there.  Once you figure that out, dig deeper.

For example:
Are you licensed for ADDM and AWR?
Are you licensed for the Diagnostics or Performance packs?
Are you familiar with StatsPack?

From strictly a database perspective, most DBAs have collected scripts over the years that grab specifics and help them narrow down where problems are.

No, I cannot post mine.

Many scripts can be found with a simple Google search.
0
 
thomaslijuAuthor Commented:
Yes AWR report helps and look for

db_file sequential read
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now