Loading patent…
AssigneeMicrosoft Corporation
InventorsDmitry Sonkin, Maciej Sarnowicz, Bruce Prang, Djana Milton, Arunprasad Marathe, Vivek Narasayya, Manoj Syamala, Sanjay Agrawal
Estimating the term…
An automated database tuning tool may include a user interface component and a tuning engine. The user interface may be a graphical component that interfaces with a user to collect configuration parameters for a tuning session for a specified database. The configuration parameters may be stored in a tuning database. A tuning engine that performs the actual tuning process may generate physical design recommendations and reports. The recommendations and reports may be stored in the tuning database, enabling the tuning tool to be run off-line or in background. Communication between components of the tuning tool may occur via stored procedures.
A system for tuning a database comprising:
A server for tuning a database in background, the server comprising a plurality of stored procedures for performing functions in response to a client request, wherein the functions comprise a first procedure that initiates a tuning session, a second procedure that monitors the tuning session and a third procedure that cancels the tuning session.
A method for tuning a database in background comprising:
A client for accessing a database tuning tool on a server, wherein the database tuning tool stores procedures for initiating a tuning session in background, monitoring the tuning session and canceling the tuning session, the client issuing a request for a procedure to be executed.
A computer-readable medium comprising computer-executable instructions for a plurality of stored procedures comprising a procedure to initiate a database tuning session in background, a procedure to monitor the database tuning session, a procedure to modify the session, a procedure to clone the database tuning session, a procedure to delete the database tuning session, a procedure to retrieve results of the database tuning session or a procedure to retrieve reports for the database tuning session
Dependencies are inferred from the claim text.