But I encountered an issue right away, using cfhttp to call the FogBugz API. Here is the code I tried:

<cfhttp method="get" url="https://webapper.fogbugz.com/api.asp"></cfhttp>
<cfdump var="#cfhttp.FileContent#">

I kept getting “Connection Failure”. If you’re familiar with the FogBugz API (or if not but you have a good imagination and can take a guess what that URL might do) you might notice I’m not even doing an “action”. You can even try that URL in a browser and see that it displays a message about not being logged in, which is a response from the API. I wasn’t even getting that far. It’s like there was some invisible wall in between my cfhttp call and the API.

Because calls to the FogBugz API need to run over SSL, I thought I had to add the cert to the cacerts store in my JRE to make the SSL bit work. That took a while to do since I’m on a mac and the cacerts never looked right. Eventually though I got a cert added, but the cfhttp call still wouldn’t work. I never did figure out what the root cause was, but I did work around it.

I wrote some java code to do the job:

objUrl = createobject("java","java.net.URL").init("#local.baseURL#&#local.queryString#");
conn = objUrl.openConnection();
...followed by some InputStreamReader and BufferedReader to get the output.

And now it works. So I know my cacerts thing is right and it’s a deficiency in cfhttp itself. What, I can’t be sure, but I don’t care. So if you’re struggling with ColdFusion and FogBugz integration using cfhttp, try this instead. And if you have gotten cfhttp to work with the FogBugz API, please share your code!

But, don’t just take my word for it. Let me dazzle you with some real-world numbers. One of the systems that we tuned recently was peaking at 200-300 requests per second. Here’s a screenshot, so you can see for yourself:

ColdFusion Rocks!

Mind you, this was a single 32-bit Windows machine, so it wasn’t even a leading-edge hosting platform. (All of the ColdFusion hosting environments that we design and implement these days are all-64-bit, which makes an enormous difference in terms of CPU utilization, RAM, etc.) All of this performance was coming out of a humble little 1.4GB memory space. When you get things right in terms of properly tuning a ColdFusion system–garbage collection, query activity, etc., etc.–then ColdFusion will stack up against any other Web application platform, or even lead the pack, when it comes to speed.

So, let the word go forth today–the notion that ColdFusion is somehow inherently slow is bollox. For those of you not familiar with British English, the American English translation is: Bullshit! (The title of the blog post is in honor of our British Co-Founder, Mike Brunt, who was the lead performance engineer on this engagement.) Happy tuning to you all, and please give us a ring if you’d like our help making your ColdFusion systems as fast and stable as possible.

So, I felt I had to share a recent plug from a customer of our ColdFusion Support Plans. This customer went out of his way to send a postcard (below). Touching, and appreciated beyond words. And, it just goes to show you–ColdFusion best practices can be sexy! I think I’ll go shopping for a black mock turtleneck now…

All kidding aside, kudos to our ColdFusion Support Engineers, and please give us a shout if we can help you maximize your investment in the ColdFusion platform.

ColdFusion Support Testimonial

• First, work for 10 years to become the very best at solving ColdFusion performance and stability problems.
• Along the way, create a suite of services that’s complete–addressing any performance and stability need for a ColdFusion system (application-layer, server-level, data tier, network-layer, etc.).
• Next, find out what ColdFusion customers really want in terms of support. In 2009, we worked with key ColdFusion hosting partners, and also conducted a survey of our thousands of ColdFusion customers, in order to find out what folks wanted and needed.
• Refine, rinse, repeat. We put all of this together–our knowledge of the limited effectiveness of the reactive approach to performance and stability problems, the feedback we’d gotten from partners and customers about the “typical” support plan experience, and about the kind of support deemed both useful and flexible–and then we worked with some former senior management for “official” ColdFusion support services from Allaire/Macromedia/Adobe to put together something new, and better.
• Launch! In December, we launched our formal support plans for ColdFusion.

Here’s a brochure site we put up describing the plans:

There’s a lot of information there, but, please don’t hesitate to contact us to discuss any and all details. We’ve tried to clarify/simplify information about the plans as much as possible, but, nothing beats hearing it live from a ColdFusion performance engineer with 10 years of experience in the trenches of ColdFusion engineering.

Update: Since the response has been so overwhelming, we’ve decided to up the giveaway limit to the first 200 respondents!

Thanks so much in advance, and a Happy Thanksgiving to all!

Each time I’ve installed a new version of SQL server — be it 2005 or 2008 — it took me a bit a random clicking to get a ColdFusion datasource connected to SQL Server.

Here are some tips.

1. Make sure the service is running. Well duh… but this has tripped me up before, so just check and save yourself the headache.
2. Make sure that TCP/IP is enabled.  To do this, open Start => All Programs => Microsoft SQL Server 2008 => Configuration Tools => SQL Server Configuration Manager. In the left column, expand SQL Server Network Configuration. Select your SQL Server instance (note the instance name e.g. SQLEXPRESS) and then double-click TCP/IP in the right column to open the TCP/IP Properties. Under the Protocol tab, make sure Enabled is Yes.
   
3. While you’ve go the TCP/IP Properties window open, click the IP Addresses tab. From this tab, you can see what IP address SQL server is running on. Equally important, you will see the Port Number. The default port number is 1433, but I’ve got three versions of SQL Server running and each one uses a different port number.
   
4. Login to your ColdFusion administrator and create a new SQL Server Datasource. The Server will be the IP Address (e.g. 10.0.1.6) followed by a colon (:), followed by the instance name (e.g. SQLEXPRESS). You get the port number from the IP Properties window in step 3 above (e.g. 1094).
   

That’s it. If you’ve got Windows Firewall running, make sure you can accept traffic over the port being used by SQL Server.

ColdFusion TNT

The 1-Day ColdFusion TNT Audit is the fastest possible way to begin to identify, prioritze and fix the causes of ColdFusion performance and stability problems. Here’s what we deliver in just one day of effort:

• A review of your SeeFusion configuration, in particular query monitoring and database logging settings.
• A review of your JVM configuration, in particular memory utilization settings.
• A review of your ColdFusion log files, stack traces, and any other diagnostic information you’ve gathered.
• A review of your ColdFusion Administrator settings.
• An analysis of your SeeFusion metrics.
• A written report detailing and prioritizing your system’s bottlenecks, complete with extensive data in tables and charts sorted by a variety of methods.

ColdFusion TNT

If your ColdFusion systems are experiencing performance or stability problems, contact us today.

Important Note: The 1-Day TNT Audit is not ideal for customers with specific and/or severe performance/stability problems. For those situations, our comprehensive TNT engagement is the best solution. The TNT Audit is intended as a way to get to know us while considering additional services, and to obtain a very useful “snapshot” of your system. It is not the intensive investigative/problem-solving engagement that our standard TNT Services represent.

Creating a Maintenance Plan

In SQL Server Management Studio, expand the Management folder, right-click Maintenance Plans and select New Maintenance Plan…

Give the Maintenance Plan a name and click OK. The new empty Maintenance Plan will open in Design Mode. All of the available tasks are in the left hand column Toolbox under Maintenance Plan Tasks.

To add any task to the maintenance plan, simply drag the task from the Toolbox into the design frame. Once the task is in the design frame, double-click to edit.

Reorganize Index Task

The reorganize index task updates table and view indexes so the search order is more efficient. The task dialogue is pretty simple. Use the Database(s) drop down to select one or more databases. Then use the Object drop down to select whether Tables, Views, or Both should have their indexes reorganized. For this example, I’m going to reorganize both Tables and Views. When done, click OK.

Back Up Database Task

The Back Up Database Task creates a Full, Differential, or Transaction Log backup. In this example, I’m going to create a Full backup which will create a *.bak file.  This task dialogue is also pretty simple. Set the Backup type to Full and then select the Database(s) to backup. Jump down to the bottom third of the dialogue and select the Create a backup file for every database radio button. Then browse to the folder where the backup files are to be saved. When done, click OK.

Join the Reorganize Index Task to the Backup Database Task by dragging the green arrow between the two. Once the two tasks are joined, right-click the arrow and select Completion.

Shrink Database Task

The Shrink Database Task should come after the back up task because the shrink cannot be executed on a database until a Full backup has been created. In the task dialogue, select the Database(s) and just accept the defaults. When done, click OK. If you’ve noticed your log files getting out of hand, the shrink task will bring the file size down. In a recent test, my active log file went from over 2GB to just over 200MB.

Join the Back Up Database Task to the Shrink Database Task, and set the type to Completion.

Maintenance Cleanup Task

As the last task in the Maintenance Plan, I’m going to cleanup the backup directory by removing any *.bak files that are older than 2 weeks. If you’re doing this type of maintenance, you’ll want to make sure you’ve got some sort of server backup that keeps a longer history of your *.bak files off-server.

Open the task dialogue and skip down to the Search folder and delete files based on extension.  Navigate to the backup folder that was set in the Back Up Database Task. Then set the file extension to bak. Note the extension is simply bak. You don’t need to include a . (dot). Skip to the bottom of the dialogue and set the age of the deleted files to 2 weeks. When done, click OK.

Join the Shrink Database Task to the Maintenance Cleanup Task, and set the type to Success.

Execute the Maintenance Plan

Save the maintenance plan. From the Object Explorer, right click the new plan and select Execute to test it.  If everything runs without error, you can set the plan to run on a schedule.

On the design mode screen in the Subplan grid, click on the calendar icon and set the schedule for executing the plan. When done, click OK.

That’s it. The plan will now run as a scheduled task. Not only does the plan backup the database, but it’s also reorganizing the indexes, shrinking the database and cleaning up  the backup directory. Best of all, once it’s setup, the plan executes without your intervention and at a time that is best for your system.

Here’s how to use these scripts:

1. Copy the files to solr installation directory. i.e /Applications/ColdFusion9/solr or /ColdFusion9/solr. Change the scripts to have execute permission.
2. Open cf-init-solr.sh and cf-solr-startup and be sure that CF_DIR is set to your coldfusion9 install directory.

From there, run:

sudo ./cf-init-solr install
to install the scripts.

sudo ./cf-init-solr uninstall
to remove the scripts.

All done!

Download the scripts now.

There are still a few $30 tickets left, so register now before the prices go up!