Database Administrator

Use Windows performance monitor to monitor common SQL Server metrics As mentioned in the above article, Win's Performance Monitor is an essential tool for monitoring database performance. Next I will introduce some common monitoring metrics, which

MongoDB Data Replication shard I. MongoDB introduction: MongoDB is a high-performance, open-source, and non-pattern document-based database. It is a popular NoSql database. It can be used in many scenarios to replace traditional relational databases

Specification of memory size in different Oracle versions, different oracle versions  **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to

I. Check hardware requirements:1. Memory:#/Usr/contrib/bin/machinfo | grep-I MemorySwap:1 GB-2 GB 1.5 times the size of the RAM2 GB-16 GB Equal to the size of the RAMMore than 16 GB 16 GBView the swap size:#/Usr/sbin/swapinfo-2. Disk Space:/Tmp

[PLSQL Developer] PLSQL Developer SQL Editor garbled, plsqldeveloper[Problem] We often write various statements in the SQL window of PLSQL Developer. To save these statements, you can save them as a text file or copy them and paste them into a Word

[Course sharing] This article introduces how to transplant and develop an embedded linux system (Environment setup, uboot porting, and embedded Kernel configuration and compilation), and how to implement uboot. Embedded linux system porting and

Oracle session blocking, oracle sessionSession blocking for a single instance Simulate 232 sessions being blocked by 1224 sessions select * from V$SESSION_BLOCKERS; SID SESS_SERIAL# WAIT_ID WAIT_EVENT WAIT_EVENT_TEXT

The interceptor of mybatis implements statistical analysis of SQL Execution time, And mybatis performs statistical analysis. Reprinted from: http://blog.csdn.net/andyzhaojianhui/article/details/72823055 The idea of the interceptor for mybatis comes

When calling the dynamic performance view related to Oracle in a process, package, function, or trigger, you must grant appropriate permissions. Otherwise, you will receive an error message indicating that the table and view do not exist. Even if

It took an entire afternoon (more than six hours) to sort out the summary, which is also a deep understanding of this aspect. You can look back later. After installing Hadoop, run a WourdCount program to test whether Hadoop is successfully installed.

Detailed explanation of Yahoo's MySQL Performance Analyzer, yahoomysql AnalyzerDetailed explanation of Yahoo's MySQL Performance Analyzer Author: chszs, reprinted to be noted. Blog homepage: http://blog.csdn.net/chszs一、introduction Yahoo opened its

For details about how to use the count function in MySQL, mysqlcount The count function is a function used to count records in tables or arrays. Here we will introduce the usage and Performance Comparison of the count function in MySQL. Count (*)

RedHat Linux 6.2 Oracle10g installation and configuration Manual The following are all root user operations: 1. Installation preparation 1.1 RedHatLinux Server 6.2 Installation File RatHatLinuxServer-6.2-x86_64.iso 1.2 Oracle10g Linux Installation

SQL Server data encryption and decryption: migrate the database protected by TDE to another instance (2), sqlservertde -- Understand TDE-https://technet.microsoft.com/zh-cn/library/bb934049 (v = SQL .105). aspx TDE performs real-time I/O encryption

Redis Research (14th)-management tools, redis research toolsTo do well, you must first sharpen your tools. When using Redis, if you can effectively use various Redis management tools, it will greatly facilitate development and management. I.

Mysql-related log summary and mysql Log Summary As an important means of querying problems, log should be recorded as much as possible for you to query some problems. MySQL has the following types of logs:Error log:-log-err Query log:-log Slow query

Incorrect practice: To port the data in the oracle 9i database to a lower version of oracle 8i, first use the exp command to export the command line in oracle 9i ): Exp username/password @ Global SID file = export database file name owner =

The simplest and most effective Bufferpool A buffer pool is a storage area in the memory. It is used to temporarily read and modify database pages (including table rows or index items ). The buffer pool is used to improve the performance of the

Many parameters can be selected during script generation. reasonable configuration of these parameters makes it easy for us to generate scripts as expected. Script generation options, such: Here is the SQL 2005 option, which is slightly different

Migration environment Configuration: Data source:BNET Development Environment Data Server:SunOS v880 5.8 Database:Oracle 9.2.0.4 & DB2 8.2 Migration tool:IBM DB2 Migration Toolkit 1.3I. Table migration 1. Index length limit In DB2, the maximum