Thanks for your help. Was about to start trace, but threw some of Gail's queries at it first... those are exactly what I was looking for.

Thanks again!

In previous post- someone indicated that DBCC Opentran only includes logged transactions... so if this is a "select", there is nothing written to the transaction log and therefore doesnt appear...

SQL Service account should definitely NOT be a domain admin account! SQL Server will give the service account the minumum required permissions on the server. Domain admin is...

I would expect these to be logged transactions. The server is in full recovery mode and the connections are being made from a standard application.

Not an expert here, but I see you are using -n. from that same thread saw:

When you export native there are no record or row delimiters defined. The image...

have a look here, seems like same problem with resolution: http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/080f01a0-4011-4bf6-a7ea-5ef0d2479030

Just FYI, CXPAcket_wait, isnt necssarily a bad thing. Here is a simple example:

You do a query which SQL SErver decides to divide in half- two processes. First...

By db2, do you mean SQL 2005? By as/400 do you mean Window Server?

might be wrong forum

EDIT: Sorry- quitting smoking... I don't know the answer to your question....

Just checking in to show support for the word "upgradation". I think we should make that the standard technical term.

I am not kidding or teasing.

So, to be sure I understand correctly, you are asking about the windows permssions required by your DBA and your users- not asking about database level permissions- correct?

Your DBA is...

This makes sense and is totally in line with my understanding- but I dont understand why it appears to be using 8GB, not the full 16GB of RAM.

According...

I think there is memory pressure. Once counter- Memory\Pages Input/sec- is supposed to remain near zero with occasional spike... on this server it is more often a high positive...

target and total are both 1GB. Yeah- I have a request to hosting to put in /PAE, but I read from MS, that it shouldnt be needed.

It never goes...

Microsoft SQL Server 2005 - 9.00.3282.00 (Intel X86) Aug 5 2008 01:01:05 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build...

Thanks for your help gail. here's results from sp_configure:

nameminimummaximumconfig_valuerun_value

Ad Hoc Distributed Queries0100

affinity I/O mask-2147483648214748364700

affinity mask-2147483648214748364700

Agent XPs0111

allow updates0100

awe enabled0111

blocked process threshold08640055

c2 audit mode0100

clr enabled0100

common criteria compliance enabled0100

cost threshold for parallelism03276755

cross...