|
In This Issue
·
New
stuff at TNT Software
·
What
Happened to My Dynamic Console?
·
Unable
to get ELM installed...?
·
Multiple
Databases
·
Improving
SQL Performance - Some Suggestions from TNT Software Support
·
NOT
Strictly Business
TNTSoftware.com
FREE - Try
us for 30 days
Compare
Products
Sarbanes
Oxley Information
Security
What's
New?
Government
pages
Testimonials
"I
don't see how anyone can run Windows machines without ELM. It's like watching
TV without TIVO."
Case
Studies
See how companies worldwide are using ELM to
proactively manage their environments
2001
Main Street
Vancouver, Washington 98660
Phone:
360.546.0878
Fax:
360.546.5017
Toll-Free:
877.546.0878
http://www.tntsoftware.com/
Email
TNT Software
|
New Stuff at TNT Software
~ TNT Software is at TechMentor Las Vegas this week.
Stop by booth 306, say hi to Brent and John, take a look at ELM 4.0, and
practice your juggling skills.
~ On Friday morning, September 30th, TNT Software
drew five names from those who registered for a free Full Conference
Registration. Congratulations to Erick Maki of Dorsey & Whitney LLP, John
McCraney of Amcol International, Dave Schuler of Blackhawk Transport Inc.,
Marty Hoenig of Communications Data Services, and Mark McHugh of ProCard, Inc.
See you there!
~ Users' Group Meeting - what happened? As many of
you know, we postponed the Users' Group meeting while we ironed out location
difficulties. But a few of you insisted on carrying on. To our surprise and
delight, a small group turned out the morning of the 27th, so we met in the
conference room! Everyone had a good time, learned a lot, and, yes, ate lunch!
What Happened to My Dynamic Console?
Those of you who have been using ELM 3.1 or earlier will see
a change in the ELM 4.0 console for the streaming of events. In ELM 4.0, there
is a default setting that disables the streaming of events into the console.
This feature was added to facilitate finding/isolating specific events that
might be hard to find when events are continuously streaming.
To change the default and enable continuous streaming, go to
Windows Control Panel and launch the ELM applet. On the 'Options' tab,
de-select the checkbox for "Disable Real-time Event View and Alert View
Updates", click ok and re-launch your console.You should now have a dynamic
console.
Unable to get ELM installed...?
Unable to get ELM installed, seeing an error at the install
step where it tries to connect to the database? Running SQL Server Express
2005?
If you answered "yes" to those questions, here's the
probable cause: By default, the Express edition installs as a SQL named
instance. By default, it is named 'SQLExpress'. To connect ELM to a named
instance of SQL Server you must specify the NetBIOS name and the SQL server
instance name in the 'Server' text box during installation. The syntax would
be:
-
Server: ServerName\SQLExpress
-
Database: ELM_PRIMARY
You should specify this same syntax in the next dialogue for
the ELM Failover database if connecting to the same instance of SQL. Ensure
that you do not include two backslashes before the NetBIOS name as this will
cause the connection to fail.
Multiple Databases
Have you encountered this message?
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative
database size would exceed your licensed limit of 4096 MB per database.
You may have seen this especially for your archive database.
To switch to a new archive database, run through the database wizard and when
you get to the 'Archive Database' page type in a new database name (e.g.,
ELM_ARCHIVE_2). When you click "next," ELM will prompt you that the database
doesn't exist and ask if you would like to create it. Select yes. You may want
to set the initial size to something larger than the 100MB since the more often
SQL has to grow a database, the more of a performance hit SQL takes. Sizing a
database correctly at its creation will take this extra load off SQL.
Improving SQL Performance - Some Suggestions from TNT Software Support
-
First implement the SQL maintenance job for ELM, by selecting the 'Install
maintenance Microsoft SQL job' option on the ELM Primary database page of the
Database Wizard. This will allow SQL to run a four-step maintenance plan weekly
to help keep the ELM database optimized. This job is scheduled to run weekly at
3:00AM every Sunday; it will perform an integrity check, an optimization of the
database, followed by a backup of the ELM database data file and transaction
log file. This job will also keep a four week history of your database backups
that will be stored in a subdirectory under the SQL installation directory; be
aware of this since the backup files can eat up precious drive space.
-
By performing a backup of the database at normal intervals you will keep your
SQL transaction log from continuously growing, and the re-indexing of the
database will help SQL perform queries more efficiently. Go
here for more detail about re-indexing and its effects on SQL
performance.
-
Another option that can be set on databases is the 'Auto shrink' option; in
most cases this should NOT be used as this will cause SQL to incur overhead for
shrinking a database that will more than likely grow again, using more SQL
resources. Go to the options tab on your database properties through SQL
Enterprise Manager and turn this option off if it is enabled unless you have a
specific reason for using this. Initially sizing your database to an average
size for normal operation will keep from using SQL resources to continuously
grow the database. See the 'Database Guidelines' topic located in the ELM help
file under 'Administrator Guide'|'Planning Guide' for information about sizing
your database.
-
Using the pruning features of ELM is another way to keep the data size of the
ELM Primary database manageable. Keep only the data that is required for daily
operations; any other data that needs to be kept for historical reasons can be
kept in the optional Archive database. Archiving is specified by the pruning
filter in the ELM Database Wizard; when the Archive database is enabled, you
will have the opportunity to specify which pruned data sets are placed in the
Archive database. Keep in mind that the database pruning filters are processed
sequentially from top to bottom. In a sophisticated configuration, this could
affect the resulting Archive db.
-
Disk swapping is something that many of you run into. This is usually due to
the number of drives that are available to SQL and how the databases are
configured on those drives. Adding more drives/spindles to your SQL Server,
usually in a RAID configuration, will allow SQL to read/write data faster as
I/O latency is reduced. Also, placing your database data files and transaction
log files on separate logical disks will increase performance. This holds true
for placing the SQL 'tempdb' database on its own drive.
Here is a great source of information for hardware tuning and SQL
server.
NOT Strictly Business
-
"Stewardesses" is the longest word typed with only the left hand and "lollipop"
with your right.
-
Maine is the only state whose name is just one syllable.
-
No word in the English language rhymes with month, orange, silver, or purple
(unless you count Roger Miller's "maple surple").
-
"Dreamt" is the only English word that ends in the letters "mt".
-
There are only four words in the English language which end in "dous":
tremendous, horrendous, stupendous, and hazardous.
-
There are two words in the English language that have all five vowels in order:
"abstemious" and "facetious." (Admit it, you are going to say ...... a e i o u)
-
TYPEWRITER is the longest word that can be made using the letters only on one
row of the keyboard.
-
The average person's left hand does 56% of the typing.
October 10th in History
732 - Following an invasion of France by Abd-er-Rahman and a force of
65,000 Saracens, Charles Martel and a force of Frankish infantry defeated the
invaders at the battle of Tours.
1865 - John Wesley Hyatt patented the billiard ball. Hyatt won $10,000
in a contest as the first person to invent a substitute for the commonly used
ivory ball.
1913 - United States President Woodrow Wilson triggered the explosion of
the Gamboa Dike, which ended the construction of the Panama Canal.
1933 - The first synthetic detergent, Dreft, went on sale.
1956 - Elvis Presley's hit recording of Love Me Tender entered
Billboard's popular record charts on this date, stayed on the charts for 19
weeks, and was Number 1 for 5 of those weeks. The song, from Presley's first
film with the same title, was adapted from the tune Aura Lee, written in 1861.
1972 - On this date, The Washington Post, in articles by reporters Carl
Bernstein and Bob Woodward, uncovered a massive effort on the part of CREEP,
Committee for the Reelection of the President, to disrupt the Democratic
campaign. Their activities and findings were later immortalized in the film All
The President's Men .
Born on October 10th:
1813 Guiseppe [Fortunino Francesco] Verdi composer d: 1901
1900 Helen Hayes [Brown] actress d: 1993
1946 Ben Vereen singer, dancer
1955 David Lee Roth singer
1969 Brett Favre football
|
