Periodic Maintenance Tasks for Vantage w/SQL

Yahoo Archive
1
I have heard that someone on the list runs conversion 6430 on a monthly
basis. This fixes problems when the PartBin and PartWhse On Hand Quantities
don't match.

In SQL we do a shrink operation on the TempDB every week. This keeps the
temporary database from growing so huge that it takes up all of the server
disk space.

If it matters, we are on 803.407C

Jeff



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
too_much_hg
Sent: Friday, May 01, 2009 11:12 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Periodic Maintenance Tasks for Vantage w/SQL








What do people do to keep their systems working at their best ?

I ran the nullfixer.r program against my database and it found/fixed a bunch
of records.

What exactly does the nullfixer.r program do ?
How often should I run nullfixer.r ?

What other programs/tasks are out there ?
What do they do ?
When would I run them ?

Are there any programs/tasks that I should run on the SQL side ?

Database Indexing ?
Database Defrag ?
Logfile Cleanup ?

I am having difficulty finding documentation on this kind of stuff.

Thanks,
Neil





[Non-text portions of this message have been removed]
2
What do people do to keep their systems working at their best ?

I ran the nullfixer.r program against my database and it found/fixed a bunch of records.

What exactly does the nullfixer.r program do ?
How often should I run nullfixer.r ?

What other programs/tasks are out there ?
What do they do ?
When would I run them ?

Are there any programs/tasks that I should run on the SQL side ?

Database Indexing ?
Database Defrag ?
Logfile Cleanup ?

I am having difficulty finding documentation on this kind of stuff.

Thanks,
Neil