Announcing the General Availability of IDERA SQL Compliance Manager 7.0
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Customization of monitors & advisors become more easy with the latest MONyog 4.1
The highlights of this release are: * A brand new helper function interface: We have implemented an easy-form based interface for customizing helper functions. Any customization of helper functions or user defined functions being used with earlier versions have to be...
Move Groups Of Tables
I've just started to use the Schema Designer feature, and whilst handy it is driving me mad as I can't see any way of moving a group of tables all at the same time. Moving dragging one table at a time is slowing things down a lot! Any chance this could be...
Take your indexed columns out of functions to really boost SQL Server performance!
In a future article I will show how to quantify and rank your “heaviest” SQL Server queries according to the overall load they place on your system. That discussion will show that at most sites it’s often NOT the infrequent long-running queries which...
Performance of COALESCE vs. IS NULL
There are a great many articles out there expounding the virtues of using the ANSI standard COALESCE function over the non-standard IS NULL function. Indeed even the SQL Server MVP’s and SQL Server PSS have weighed in on the issue showing...
Monitoring Disk Space Of Nas Devices
I have 3 different NAS devices (Netgear, Lacie, IOmega) that I would like to monitor through uptime to see if their disk space is being used or full. I would like to see this feature implemented in Uptime, as well as knowing which user is using the most files in their...
Using Windows Stock Icons in Delphi
it is not a big discovery that all applications are running in the environment provided by the underlying operating system. Delphi is well-known for its rapid application development capabilities. The latest version of Delphi - Delphi 2010 - is the first release to...
Converting to grayscale with TBitmap.ScanLine property
In my previous post "Boian’s TBitmap Visualizer and converting to grayscale" I have described an algorithm for converting arbitrary TBitmap instances to gray using a selected formula. The problem is with the performance of the code that actually changes the color of...
Archive Alternative Methods
We have been looking at how Uptime stores its data and how me can make better use of Uptime.With the exception of the disk performance_fscap table all others were being archived out at 60 days due to the fact that reporting would fail if it was much more. This year we...
“MySQL server has gone away” Part 2: session timeout.
This is the second and last article of a small series on reasons for the error message: “MySQL server has gone away”. The first appeared here describing that "if a client sends a SQL-statement longer than the server max_allowed_packet setting, the server will...
"MySQL server has gone away" Part 1: max_allowed_packet.
Most MySQL users have tried getting this rather cryptic error message: "MySQL server has gone away". The MySQL documentation describes lots of possible reasons for this here: http://dev.mysql.com/doc/refman/5.1/en/gone-away.html However this page is of...
DataSnap Server Method Stream Parameters
This is a continuation of my posts on DataSnap server method parameters and return types. This post is about TStream and TDBXStreamValue. The sample client and server projects that go with this post can be downloaded here: http://cc.embarcadero.com/item/26854 See...
Ldap Monitor
hello, I downloaded friday 20 mars “up-time5″ for test. when i try to use 'test ldap service instance', I have always error=53. When i do a tcpdump on my ldap server, there is java reference in ldap query from up.time “javaSerializedData...
Monthly Capacity Reporting
Monthly Capacity Reporting I need to provide server by server (Wintel) some preety management pictures that show CPU both peaks and average with a trend line into the future. I get how to do the first part but have struggled to find a way to include peaks that would...
DataSnap Server Methods Parameters
Delphi 2009 introduced support for DataSnap server methods. If you are not familiar with this feature, here are two articles that describe server methods: DataSnap 2009 Overview , Getting Started with Delphi DataSnap 2009. DataSnap server methods support a variety of...
Building and consuming web services with Delphi 2009
Do you remember that Delphi 6 was the first IDE in the market with Web Services support? This trend continues and Delphi 2009 supports building web service servers and clients:-) In this post I'm going to describe all steps neccessary to build simple web service...
Custom Plugin Arguments
Hi, I've just installed version 5 uptime and have created a custom plugin to monitor the replication status of my mysql slave servers. I created teh in the xml that my script requires some arguments to run. The database username and password and the database name....
Monitor Failed
Good evening, I have found an error in my uptime monitor (actually got an alert a bit ago) and the message that I see is as follows: Monitor failed: Not enough space. This was a message from the standard ping-check on one of my nodes. I *suspect* that I may need to...
Export And Import Uptime Settings
Is it possible to export and import Uptime settings to an external format? I have a primary/secondary server. What i want to do is configuration manage the Uptime settings (i.e. alerts, reports, etc). I would like to be able to extract some type of data to be this...
Db2 Tablespace Monitor
This monitor allows you to monitor all of the tablespaces for your DB2 instance. The monitor collects the stats for all of the tablespaces defined on the DB2 instance. 1) Uncompress the contents of db2tablespace.zip into your uptime4/scripts directory2) Load the...
Db2 Buffer Pool Monitor
This monitor allows you to monitor all of the buffer pools for your DB2 instance. The monitor collects the stats for all of the buffer pools defined on the DB2 instance (For example, IBMDEFAULTBP, BP4K, 8K, 16K, 32K). 1) Uncompress the contents of db2bufferpool.zip...