The October edition of DBArtisan tips and techniques covered three tips for using DBArtisan.
You can view a recording of the event here: October Tips and Tricks
DBArtisan offers a number of different options to help you manage the performance of your databases. First, DBArtisan has a built-in process monitor that helps you understand who is connected to your database along with each user’s current activity and session-related data. For more robust performance details, DBArtisan’s Performance Analyst is a powerful client-side database monitor that runs fully contained in the DBArtisan console.
The following topics walk you through some of the performance management features:
DBArtisan incorporates a powerful SQL scripting environment, the SQL Editor. The SQL Editor lets you write, debug, test and deploy solid SQL code for your database applications. You can open multiple SQL windows.
Code is analyzed as you add content to an ISQL editor session and offers the following automated features:
As far as security goes - Users, profiles and permissions can be propagated across multiple databases/instances easily using DBArtisan's Script Execution Facility. This tool will allow a DBA to execute security settings across multiple databases and/or schemas. See this link for details - Script Execution Facilities
Register for our next Tips and Techniques demo here: November Tips where we will cover:
Powered by IDERA