Viewing configuration settings without access to SQL Server

Have you ever been asked to help with a database issue but you can’t get access? Maybe you’re helping out a colleague over Skype, responding to a #sqlhelp request or asking for help yourself and want to provide more information. Quite often, there’s a simple configuration setting that may not be optimal but checking every setting could be time consuming and something could be missed (there’s a lot of settings).

You could start by running some scripts like sp_blitz (really useful) but they don’t always give you the complete picture. Aireforge Studio can take an in-depth snapshot of a single instance or the entire estate. This can be really useful to do before or after carrying out any changes. You could also attach the saved comparison file to the support ticket, so you know exactly how it looked before and after any changes made.

Here’s a quick tutorial on how you could share configuration information about your SQL Server instance or instance(s) with another person or organisation.

Taking a configuration snapshot

If you’re new to Aireforge Studio check out the getting started page, although it’s a quite simple application. Once downloaded, create a profile and add the server(s) in question.

Note: If you wish to compare more than 200 servers, contact the team and we’ll relax the limit for you.

Go to the compare tab and select the comparisons you wish to run or select Full to run them all. A full comparison should finish in a few seconds and won’t display any results if you only compared one server or if all of your servers are identical. Now save the results as an .afd (Aireforge Data) file and send it to the other party.

save

Viewing the results

The receiver will also need to have Aireforge Studio installed. Once installed you can either double click on the .afd file to open, or load the file from within the application. To view the results change Differences to All Rows and the View to Grid. If information has been collected from more than one server, you could also use the summary view to quickly see any differences.

results

Aireforge Studio performs 39 preconfigured checks but if it doesn’t gather the information you require, you can create your own custom comparisons.

Any problems, however small, please contact Aireforge support.

You can also use our Wantoo board to request new features or improvements? .

Visit Aireforge

Download Aireforge Studio

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s