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.
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
View complete information for all
object types in the database.
Create, modify, or drop critical
Drill down to information related to
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,
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.
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.
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.
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
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.
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.
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
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.
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.