Collect data from all databases and servers for monitoring, reporting and custom data warehouse applications

SQL Farm Combine™ provides a foundation and framework to automatically collect, aggregate and store data from many databases and servers. With this framework users can easily monitor SQL Server environments, write custom data collection tasks to get data from preconfigured groups of databases and servers, retrieve performance metrics from all SQL Server instances, as well as manipulate and transform the collected data for custom reporting and monitoring applications. The tool enables users to run multiple SQL scripts on multiple databases and SQL servers and instances, auto-save the returned results in one or more central databases or in files, and much more. Read below to find out more...

How does it work? SQL Farm Combine™ offers distributed querying capabilities that allow you to write SQL scripts (or simple SELECT statements) and then execute them against preconfigured groups of databases on any number of servers in parallel. The data returned from all databases and servers is then automatically aggregated by Combine and written to one or more "output" databases or to portable files that can be passed to other users. Sample data collection and monitoring projects are available for download on our website and allow you to monitor the status of SQL jobs on all servers, as well as collect database files statistics and information. Custom monitoring and data collection tasks can be easily built by following the instructions and samples in the user manual. Get performance metrics from all SQL servers & instances SQL Farm Combine™ allows users to write scripts and queries (e.g., to query dynamic management views, system tables, to execute stored procedures or run DBCC statements to collect performance metrics) and then automatically returns a single aggregated and unified result set from all databases and SQL server instances. Users control the SQL code that is executed, the databases and servers on which the queries and scripts are run, as well as the execution order to guarantee fast and easy data collection. Moreover, all aggregated data and results can be automatically stored to databases or to files that can be opened and viewed by other (including remote) users. Easily manipulate collected data or schema SQL scripts used to retrieve and auto-store data are part of a Combine project, and projects can contain many other custom scripts. Each script in the project is mapped to a preconfigured group of databases on any number of servers. When the project is executed (either on a scheduled basis or on demand), then every scripts is run against all its associated target databases and servers. In addition, the user has full control over the project and order of code deployment. Auto-store data in your custom schema or configure Combine to automatically create schema in run-time SQL Farm Combine™ auto-saves the collected data in one or more "output" databases, which are fully configurable and controlled by the user. In addition, you can either configure Combine to write results and data to existing tables or create new schema in run-time while data is being collected. Scheduled data collection tasks Data collection and auto-storage can be run on demand using the SQL Farm Combine™ user interface, or you can schedule the entire data retrieval and auto-storage process using command line utilities and scheduled tasks. Scheduled data collections are defined and created in SQL Farm Combine™, which includes end-to-end schedule management. Samples and user manuals are available for download on our website. Embed data collection capabilities in Web pages, Web applications or custom projects SQL Farm Combine™ can be called from Web servers or custom applications to automatically collect and return data to the caller. The tool can also be used (for example) to create a stored procedure that queries data from multiple database and servers, without any remote installations or dependencies. Typical examples of embedding SQL Farm Combine™ data-collection features in custom applications include calling data collection tasks from Web pages to get and display data from a large number of back-end databases, or collecting data from many SQL servers and instances using stored procedures for database applications. Get detailed data collection report and results Every time Combine is launched to collects data it saves a detailed report and audit trail. You can open this report in Combine and view each step performed during the data collection task. This report includes messages, SQL statements, execution plans and all other information returned from all databases and servers. Email notifications to track data collection tasks Combine can be easily configured to integrate with your SMTP server and automatically send email notifications in response to various events during the data collection task. Furthermore, you can instruct Combine to attach the data collection report & results to this email or only send email in the event of errors or issues. Write custom monitoring tasks or download sample tasks from our website Sample data collection projects and manuals are available for download on our website. The sample projects allow you to monitor the status of all SQL jobs across all servers, or monitor the database file size and filegroups on all databases and servers in your enterprise. The provided manuals include step by step instructions and templates to build custom data collection tasks that can be used in many monitoring and reporting applications. Need help with custom data collection & monitoring solutions? If you need assistance in writing custom data collection and monitoring tasks, our SQL experts are at your service. SQL Farms offers a wide range of SQL server related services and can assist you with all data collection and monitoring needs.