Do you know how to add a custom SQL query to PerfMon? I can't figure it out.

Is System Monitor a 3rd party tool?

I think your right about that. Not sure if 32GB is the right number, but maybe 34GB for SQL maximum memory which would give the MPA+OS+Other Processes 6GB to...

Sorry, 36,000,000 was a typo. I meant 36,000MB.

36,000,000 is from the MAX server memory SQL setting.

Yes, the OS is using the other 4MB.

But shouldn't there be some free room?

Also, it should be noted that Standard to Developer is no downgrade.

In terms of features, Developer is identical to Enterprise.

I recently had to downgrade a server from Enterprise to Developer as we wanted to ensure the proper licensing compliance on a dev box.

What I did was:

1.) Clone the server...

True, more maintenance. However, I had no idea what maintenance was until I starting partitioning. That will drive you nuts. 🙂

Why not just create a view that has the columns in the desired order, and just add anything new to the physical table at the end?

What version of Informix? If it's an older RS/6000 based "Online" version.....it would be easy to get my wife to give up chocolate than getting the data out via...

Thanks. That code works great. We are going to start table partitioning all our data into yearly partitions as well.

For my business, it begins on the first day of October and ends on the last day of the following September.

I need one that will always display the last day of the fiscal year.

Ok, I figured out that I needed to rebuilt my indexes that exist in the partitioned space (parition by partition) and then performance got much better.

Also, cummulative data...specifically anything from...

I just finished setting up a server that does exactly what you need. In fact, here is what I setup:

1.) A single core VM with a single drive the...