How to use OS commands to diagnose Database Performance issues?

2016-01-29 14:49 7 1 收藏

How to use OS commands to diagnose Database Performance issues?,How to use OS commands to diagnose Database Performance issues?

【 tulaoshi.com - Oracle教程 】

The purpose of this document is to provide a few OS commands for UNIX

 operating systems to gather information about Physical Memory (RAM), 

 swap memory,CPU usage and idle percentage, whether lots of processes

 are in the process run queue and whether too much paging and swapping 

 going on in the server or not so that we can use the information along

 with Statspack report to help diagnose the Database Performance issues.

 Sometimes, the information gathered using these commands will be helpful

 in finding the most OS resource consuming database or non-database 

 processes and will help in identifying the processes to further 

 investigations about why the processes are consuming so much resources and

 whether the corresponding query or application needs to be tuned. 

SCOPE & APPLICATION

-------------------

 This document can be used by anyone with moderate expertise to run UNIX

 OS commands in various operating systems like Solaris, HP-UX, AIX, TRU64,

 Linux, etc. The commands will help us collect OS related information

 to verify whether overuse of any of the OS resources can be affecting 

 the database performance or not. This document does not deal with OS 

 Kernel tuning.

How to use OS commands to diagnose Database Performance issues?

----------------------------------------------------------------

 You want to gather data for Physical memory, Swap space, CPU % usage

(本文来源于图老师网站,更多请访问http://www.tulaoshi.com)

 and idle, IO usage in the server in general and also to find a few most

 OS resouce consuming processes to get better understanding about 

 how the UNIX server is performing and whether any of these resources

(本文来源于图老师网站,更多请访问http://www.tulaoshi.com)

 are causing a bottleck in the database performance or not.

 Since the popular UNIX systems do not support the same commands or even

 same options for a command, we are proving different commands for different

 OS in the following section. Please refer to the corresponding OS man pages

 for detailed information about each UNIX command mentioned in this document.

 Solaris:

 =========

 $ /usr/sbin/prtconf |grep -i "Memory size"

 $ swap -s

 $ df -k

 $ /usr/local/bin/top

 $ vmstat 5 100

 $ sar -u 2 100

 $ iostat -D 2 100

 $ mpstat 5 100

 Out of these commands, top command  may not be installed in your server by default.

 In that case,you can get it for free from www.sunfreeware.com and install it preferably

 under /usr/local/bin directory and then use it. Please take a few snpshots of the 

 top command output and store it in a file.It refreshes the output screen every 5 sec.

 Prtconf command will show how much Physical Memory (RAM) the Solaris server has.

 Swap command will provide us with the usage of swap space including the RAM.

 Df command will indicate how much space is free in each mount point and also

 provides information about swap space(s).

 Top command wil provide the above information plus information about top CPU

 consuming processes, CPU usage in the system, etc.

 Vmstat will provide information about process run queue, memory usage,

 paging and swapping and CPU % usage in the server. Different options in vmstat

 can provide more specific information, if req

来源:http://www.tulaoshi.com/n/20160129/1494345.html

延伸阅读
private void sendmail_jmail() {//使用jmail进行邮件发送;需要添加引用jmail.dll //jmail.SMTPMailClass mail = new jmail.SMTPMailClass(); jmail.MessageClass msg = new jmail.MessageClass(); msg.From = this.tb_from.Text.Trim(); msg.AddRecipient(this.tb_to.Text.Trim()," Gallon来信",""); msg.Body= this.tb_mailBody.Text...
标签: Web开发
Sample script that deletes a SQL Server database. Supported Platforms SQL Server 2000  Yes Script Code 代码如下: strDBServerName = "."  strDBToDelete       = "ScriptingGuysTestDB"  Set&...
标签: Web开发
Form: http://www.webreference.com/programming/javascript/mk/ Author:Mark Kahn Many developers have a large library of JavaScript code at their fingertips that they developed, their collegues developed, or that&nb...
Add data to the database using ADO Tools Used : Visual C# .NET This program shows how to insert data in an access database using ADO and SQL query. I have an Access 2000 database in projectindebug directory. My database name is mcTest.MDB. You can create your own database and copy in your project's debug direc...
标签: ASP
  <% Conn_String = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("link.mdb") Set Conn=Server.CreateObject("ADODB.Connection") Conn.Open Conn_String sql = "select * from cat order by ID" set rs = Conn.Execute (sql) 'Connect to databa...

经验教程

913

收藏

39
微博分享 QQ分享 QQ空间 手机页面 收藏网站 回到头部