MobileDBA SQL Server Features

MobileDBA takes database administration to the next level. First, it provides DBAs with a remote wireless connection to their database from any location using PocketPC or Palm devices. Next, the device is loaded with Proactive Technologies’ leading edge software application that allows DBAs to completely administer their database as if they were in the office. Finally, the application is extremely easy to use, being an entirely “stylus” only driven application.

The MobileDBA software package includes server software that resides on an organization’s LAN, behind the firewall and thin client. MobileDBA was designed with security in mind. It has several layers of security and can seamlessly work with VPN, SSL, DESX and other encryption protocols.

Key Features:

Object Manager

MobileDBA Object Manager is a innovative administration option that allows the administrator among other things to explore database objects by schema or by object type from a common entry point.

• View complete information for all object types in the database.

• Create, modify, or drop critical database objects.

• Drill down to information related to the object.

• Grant or revoke object privileges.

• Recompile stored procedures.

Example: From the Table Details screen under Object Manager, the user can review or modify related information, like constraints, indexes, fragmentation, dependencies …

Session Manager

• Monitor user connections.

• View active or inactive session separately.

• View session statistics and details.

• View last SQL and run explain for SQL statement.

• View session locks.

• Kill session.

Example: Friday night family dinner doesn’t have to be canceled because DBA received a pager message that job runs for 6 hours instead of 30 min. Using Session Manager DBA can quickly check for deadlocks and resolve it by killing locking session, or looking at user’s SQL statement realize that table index is not used, then DBA can create and analyze index, using MobileDBA Object Manager.

Security Manager

• View, create, modify or drop Logins.

• View, create, modify or drop DBuser.

• View, create, modify or drop DBRole.

• Manage System Roles.

• Grant or revoke system privileges

• Grant or revoke object privileges.

Example: You are in an important planning meeting and receive a page that a newly hired manager needs immediate access to the corporate data warehouse. You can quickly add the new user without leaving your important meeting.

Database Manager

• View database details and statistics.

• Manage database parameters.

• Monitor and manage File Groups, Data Files and Log Files.

• Manage database privileges.

• Execute checkpoint or shrink database.

Example: You are driving to the airport with no phone jack available. You receive a page from the Help Desk that a user received error message saying that Data Warehouse database is out of space, and no other DBA is available. With MobileDBA you can pull onto a safe shoulder and resize the database in minutes, by increasing size of data file or adding new data file.

Performance Manager

• Proactive performance monitoring and resolution functionality.

• Data Cache Statistics reports.

• Procedure Cache Statistics reports.

• Performance Statistics reports.

• File Statistics reports.

• Memory Statistics reports.

• Transaction Logs Statistics.

• TSQL Caching Statistics.

Example: While using Performance Manager to remotely monitor available tablespace and tablespace allocation, an administrator can drill down to tablespace details and resize or change default storage parameters.

Instance Manager

• View main instance information.

• View and Modify instance configuration parameters.

• View Error Logs.

Procedure Manager

• View all stored procedures by schema and/or database.

• View procedure code, dependencies, parameters, privileges.

• Edit or drop procedure.

• Execute any procedure and view output.

• Create new Procedure.

SQL Commander

• SQL Commander is an interactive interface for a user to run any database command or query as if they were at their desk.

Example: A user can remotely create and run a customized report for a Business Manager from whom they have received an urgent cell phone call.

SQL Server Agent

• Manage Alerts.

• Manage jobs.

• Manage operators.

Example: DBA, using MobileDBA Agent, can schedule job for database maintenance and assign any type of Agent alerts to send messages to operators via pager, e-mail or Net Send.

Server Manager

• Secured connection to Windows server command line.

• Run server commands.

• Startup or stop SQL server or Agent services.

• View running services

With server manager functionality DBAs can use this application even when database is down. Administrators will be able to connect to database server simply by selecting DB name and providing OS userid/password. MobileDBA ServerManager supports SSL , ECC/DESX protocols and can be seamlessly used with Mobile VPN solutions.