Manage Your SQL Server Applications with Tools from Quest

fact sheet Vendor: Quest Software, Inc. (www.quest.com) Vendor's Information: About Quest SQL Server Management Products About Quest Software vendor resources Empowered SQL Server Development with Toad for SQL Server Quest Software’s Toad for SQL Server offers broad functionality that lowers the barrier of entry, eases developer workload, and provides developers with accurate information so they can make intelligent decisions about database performance. Amplify Your Microsoft Investment For companies with a significant investment in Microsoft operating systems, server products, and desktop operating systems, Quest offers an opportunity to eliminate the chaos of dealing with multiple vendors while still fulfilling all of your IT management needs.

Quest Software offers an award-winning portfolio of products to help IT professionals get the most out of their investment in Microsoft SQL Server. Quest's tools help administrators more easily manage backup and recovery, capacity planning, performance analysis, and SQL Server administration.

Quest's SQL Server portfolio helps your business save time and money and protects against the loss of sensitive data.

SQL Server Performance Monitoring Saves DBA When the decision was made to centralize the administration of databases for one customer, ESOS, the West Midlands’ leading provider of HR and payroll services, turned to Quest for help with improving the SQL Server environment, including performance monitoring.

DBAs can use Quest's Spotlight on SQL Server Enterprise to detect and diagnose performance issues across their SQL Server environment because it provides an overview of enterprise performance at a glance. Administrators are instantly alerted to performance bottlenecks detected at the server level and metric-sensitive alarms point DBAs to the root cause of performance issues. The Xpert tuning module in Spotlight on SQL Server Enterprise resolves SQL performance issues by ensuring optimal code quality and providing indexing options.

Spotlight on SQL Server Enterprise can identify servers and resource areas where performance degradation originates. It allows DBAs to craft custom resource alarms and thresholds to include business processes and additional metrics. It also helps diagnose and resolve common issues quickly, including blocking locks, deadlocking, and index maintenance.

Quest's Foglight Performance Analysis for SQL Server makes it easier for DBAs to handle SQL workload performance tuning and troubleshooting. These tasks require collecting a wealth of information, which translates into planning, storage, custom report creation, and ultimately a great deal of a DBA's time. Using Foglight Performance Analysis, DBAs can make root cause detection, diagnosis, resolution, and reporting a simple and efficient process.

Foglight Performance Analysis for SQL features a Performance Analysis Web Console, a powerful, Web-enabled enterprise administration and alerting interface that empowers DBAs to create custom dashboards and reports and to automate and track performance tuning and problem resolution initiatives. Its intuitive, powerful interfaces, customized context-sensitive advisories, and a comprehensive instance-level baseline provide a wealth of information at a fraction of the impact of conventional collection methods.

DBAs can monitor enterprise-level performance at a glance with WebView, which allows Foglight Performance Analysis to become a Web-based enterprise SQL performance manager. By leveraging the power of the Foglight framework, Performance Analysis WebView provides a Web-enabled enterprise administration and alerting interface that helps simplify SQL application performance management. With WebView, administrators can manage the performance of both Oracle and SQL Server side-by-side. For standalone Performance Analysis customers, the addition of WebView gives them visibility across the entire database enterprise and the ability to automate and track performance tuning and problem resolution initiatives without opening individual client consoles.

Quest Software's Toad products are comprehensive database tools that help with development and administration for databases. Toad for SQL Server bridges the functionality gaps that exist in both Microsoft's SQL Server Management Studio and Visual Studio, and it does it all within a single toolset. Users can compare and synchronize schema and table data, execute SQL scripts against multiple SQL Server instances, rollback transactions from SQL Server transaction logs, manage SQL Server agent jobs, and recall SQL scripts run at any point in time.

With Benchmark Factory for Databases from Quest Software, administrators can conduct repeatable and measurable performance and scalability testing to help understand the impact of upgrades, migrations, or new hardware and software. Through the use of database workload replay and industry standard benchmark testing, Benchmark Factory helps DBAs deploy changes to their database environment with confidence.

LiteSpeed for SQL Server is Quest Software's database backup and recovery solution. Its low-impact, high-performance compression technology allows companies to reduce storage requirements, reduce backup times, and speed recovery duration while maintaining complete control over the backup and recovery process.

LiteSpeed for SQL Server enables faster, flexible, secure backups and restores. It provides administrators with an enterprise view of their backup and recovery environment, visibility into the transaction log and transaction log backups, and a timeline view of backup history and schedules.

Quest Capacity Manager for SQL Server enables DBAs to gain control of disk space, growth rates, and database performance by providing a centralized view of the environment and intelligent index maintenance, providing advice and metrics for consolidation projects.

DBAs can use Capacity Manager for capacity planning for SQL Server database and the applications they support, such as Microsoft SharePoint for example. Capacity Manager's centralized console provides a holistic view of capacity across the database environment. It simplifies table partitioning to improve performance. Its intelligent index maintenance ensures that index maintenance occurs during maintenance windows.

Quest Discovery Wizard allows administrators to detect SQL Server instances and monitor the current network for changes. It provides a number of discovery methods that help DBAs reveal even the SQL Server instances that cannot be detected using the native tools.

Discovery Wizard will help administrators find how many databases there are and how much data they contain, see a history of the databases including when they were created and installed, learn what versions of SQL Server are deployed and what their service packs are, and determine databases that are good candidates for consolidation.

Quest Software's Change Director for SQL Server provides DBAs with a powerful automated solution for managing and tracking schema changes to SQL Server databases. Change Director helps automate the time-consuming and error-prone process of schema change management and allows users to schedule and deploy stable and consistent changes, monitor and alert on unplanned or unauthorized changes for auditing and compliance, and undo changes through an integrated transaction log reader.

In today's economy, SQL Server tools from Quest Software can help your DBAs spend their time on mission-critical projects and new initiatives instead of on the minutiae of database management and administration.

Read More: Manage Your Windows Environment with Tools from Quest »

Read More: Let Toad for Oracle Master the Database »