Software Directory
Our Network
Top Download Titles
|
|
|
|
MobileDBA SQL Server
|
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.
|
|
|
|
