Invention Grant
- Patent Title: Scalable database workload replay with mode selections
- Patent Title (中): 可扩展数据库工作负载通过模式选择重播
-
Application No.: US13009501Application Date: 2011-01-19
-
Publication No.: US08442941B2Publication Date: 2013-05-14
- Inventor: (Oliver) Gang Yao , (Shirley) Qing Yue Wang , (Elton) Zhi Yong Zheng , (Justin) Yi Cong Shen
- Applicant: (Oliver) Gang Yao , (Shirley) Qing Yue Wang , (Elton) Zhi Yong Zheng , (Justin) Yi Cong Shen
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Ogilvie Law Firm
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

Abstract:
To help a database administrator assess the impact of database server changes on applications, trace files are preprocessed into intermediate files with events sorted by generation order. Unused event classes and columns of a trace file are excluded, and pre-calculated data may be included. Intermediate files are then dispatched across a set of clients, and replay occurs in a synchronization mode or a stress mode. Synchronization mode releases events in submission order, whereas stress mode releases events in emulation of their original timing. Replay parameters include server idle time cap, query timeout value, a connect-time scaling factor for scaling time between trace start and connection login, and a think-time scaling factor for scaling the time between events on a replay client—database server connection. Each replay client generates a result file, which a replay controller aggregates for administrator analysis.
Public/Granted literature
- US20120185430A1 Scalable Database Workload Replay with Mode Selections Public/Granted day:2012-07-19
Information query