Testing SQL Response

At Red Gate, we only maintain a handful of SQL Servers. We are definitely not a company dependent on a large, heavily used network of SQL Servers, and therefore we’re not representative of some of the environments in which we believe (and hope) SQL Response will be deployed. We’re just one example.

I am sure you can imagine that, as testers, we feel the need to test SQL Response in more than just our own environment. To be confident that the software we release is fit for purpose for a range of users and situations, we need to establish a number of different, realistic scenarios in which to test it.

That’s where you come in. We’d like you to give us some information about your SQL Server instances so that we can try and understand what a typical SQL Server instance looks like; or, at the very least, see what the worst case scenario might be. (For now, we’re only interested in the numbers and sizes of things on your SQL Server, such as the number of databases, indexes, files, jobs, and so on not in any metrics surrounding activity or traffic.)

To help capture this information, we‘ve created two SQL scripts; one for SQL 2000 and one for SQL2005 and later.  All the data we capture will be anonymised and so cannot be retraced to a particular Server.  Our hope is that you will be willing to run these scripts on one or more instances that you feel are indicative of a typical SQL instance, or one that you feel is an example of your most utilised instance and then email the output to us at thefutureofmonitoring@red-gate.com (indicating which category of instance the results relate to). 

Download all as a zipped file or download each individually;

Note: we’ve passed these scripts to our in-house SQL experts, so they’re optimised for minimal impact on your servers.

Any other information you are willing to provide regarding your environment will also help. This will enable us to model the static part of your environments internally with appropriate numbers of databases of various sizes etc. (We hope to eventually collect data about SQL Server loading during the Early Access Program, but for now we’re focussing on the instances themselves).

We really look forward to receiving your emails. These will help us ensure we can successfully replicate real world SQL server instances in-house. We look forward to hearing from you and thank you for your support.

This entry was posted in Testing and tagged . Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

One Comment

  1. Emma Armstrong
    Posted December 21, 2009 at 10:03 am | Permalink

    We just wanted to say thank you to everyone who has run these scripts for us, the data will help us no end.

Post a Comment

Required fields are marked *

Add an Image


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>