Assuming you have minimal expertise in SQL Server, the first thing I
would do would be to shut down Gentran and perform some basic dbms
maintenance. For example, shut down SQLServer and make sure the
database files are defragged. If you can find a way to monitor
real-time what SQLServer is doing (I know you can with Oracle, but I've
not done it with SQLServer) you could see which queries or operations it
is executing and see if your database might benefit from some additional
indexes. These could be added for your housecleaning then later dropped
without doing any damage.
The NT admin manuals (at least in one of the volumes) has descriptions
of the database tables. With a bit of effort you could probably figure
out which tables and rows could be cleaned up with SQL. However, going
this route you'll need to be careful about depdendencies, i.e.,
violating foreign key constraints or ending up with orphan records.
Mike
Sean Brown wrote:
>
> Hey All,
>
> I'm in a bind and am in need of a quick fix. We are running Gentran:NT
> server version 3.01. We stopped support a long time ago and this
> machine was running stable and meeting our needs for a long time.
>
> A few months back for whatever reason our support staff stopped doing
> maintenance on this server and now the Mailbox system is full of data.
> We are running a single server install with SQL Server running on the
> same machine. What's happening now is that the server is so taxed the
> CPU is at or around 100% most of the time with the culprit being SQL
> Server.
>
> I have tried to clean out the mailboxes through the mailbox
> application but even one mailbox take many hour to clean out and
> during that time no one can connect to the server.
>
> My question is this; Does anyone with experience on this server know a
> shortcut to reliably clean out the mailboxes maybe with a SQL script
> or something?
>
> Time is of the essence and I would appreciate any input.
>
> Thanks,
>
> Sean B.
> Detroit, MI
>
>
--
---------------------------------------------------------------
Michael C. Rawlins, Rawlins EC Consulting
www.rawlinsecconsulting.com
...
Please use the following Message Identifiers as your subject prefix: <SALES>,
<JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
Job postings are welcome, but for job postings or requests for work: <JOBS> IS
REQUIRED in the subject line as a prefix.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/EDI-L/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/EDI-L/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
