You are lucky, I'm in both environement more than 10 years.

What you need to do.

1. Shutdown with nowait

2. set -T3608 in your server run file, this will recover your master...

I also experienced some memory leak with using QA_create

Believed it or not, the MDAC is the enemy in a lot of cases that I had deal with. Make sure your server and client are on the latest MDAC...

We have active/active setup. 2 GB is not the limitation as long as pae awe is enabled. For active/Active, you should use fixed memory config. instead of dynamic. You need...

dbcc traceon (1204,1205,1206, 3605) will print handful of deadlock related information to the errorlog. I don't think any customized SP, can do more than this unless you keep running server side...

How you connect ?

Is same error happen even you use isql, osql or query analyzer ?

Run Profiler, with Audit/login. Errors/Attention, exception,OLEDB error.

Do you ss anything odd ?

I'm not familar with Informatica ETL tool, is there anything you need configure for this aspect.

For SQL part, you have 4 Gb of memory, is AWE, pae enabled ?

For H/W,...

What's the connection method from the APP ?

If using MDAC, is MDAC on same level ?

If using JDBC, are the up to the jdbc sp1 ?

I really don't think trigger get timed-out on SQL2K. What tools are yiu using to delete the data. try to delete thru. isql or osql. They should not get timed-out...

In general, the message indicate somewhere the cluster is not setup correctly or something wrong on the H/W (most possible is RAID controller). In our situation, after replace the RAID...

Are you using IBM SCSCI H/W ?

I believed it works. I had several link serves link to various Sybase DB on both NT and Unix. But, I do notice you may need installl Sybase ASE OLE...

The better way

select count (*),col1,col2,col3,col4

from tbl

group by col1,col2,col3,col4

having count (*) >1

What I'll do.

1. defrag the index or dbcc reindex the DB

2. Update stats

3. check is the Optimize performance is set to 'background service' [Control Panel --> System]

4. How much...

Make sure you are able to ping/telent the IP and port. If not, you have to check how to open the Ip/Port. As long as IP/port is reachable it should...