Connection Issues

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike G - 29 Apr 2008 15:03 GMT

Hi,

I am working with a client whose primary software for their firm uses
MS SQL. They have been experiencing frequent issues with data missing
from query windows, or old data that has been deleted or archived
reappearing; the client closes the program and things are back to
normal. In talking with the support staff for the vendor, they assure
me that we have "an ideal enviroment" for running their software, but
are insisisting that the problems the client is experiencing are
"connection issues" and can't have not been able to point me in any
directions to check other than looking at the hardware environment
which they have said is "ideal". Can someone possibly explain what
other places we might look for connection issues? The client is
running SBS 2003 Premium, which includes SQL 2000. We have all
service packs installed on the server and the workstations.

If more info is needed please feel free to ask.

Thanks,
Mike Garoutte
Milwaukee, WI

Reply to this Message

Roy Harvey (SQL Server MVP) - 29 Apr 2008 17:52 GMT

I would look for transactions that are not being committed. In
general it is a Bad Thing for a transaction to remain open during any
user activity. It sounds like that is happening, and the connection
is being broken before or without the user doing whatever has to be
done to make the change final.

An alternate explanation would be that they application stages
transactions in other tables before updating the main tables, and the
user is not taking whatever final step there is that applies the data.

Roy Harvey
Beacon Falls, CT

>Hi,
>
[quoted text clipped - 17 lines]
>Mike Garoutte
>Milwaukee, WI

Reply to this Message

Mike G - 30 Apr 2008 14:49 GMT

Hi Ron,

Thanks for your reply. I have to be honest that I am not sure how to
check for uncommitted transactions. When the record is saved, I would
assume it
would be updated in the database. One thing that frequently happens
while editing a record the
staff at the clients office will click the "Save & Close" button to
save the changes to the record and they get a message that the record
has
been deleted by another user, even though the record has not been
deleted. We are putting a gigabit nic in the server Thursday night.

Thanks for your help.
Mike

On Apr 29, 11:52 am, "Roy Harvey (SQL Server MVP)"
<roy_har...@snet.net> wrote:

> I would look for transactions that are not being committed. In
> general it is a Bad Thing for a transaction to remain open during any
[quoted text clipped - 32 lines]
>
> - Show quoted text -

Reply to this Message

Roy Harvey (SQL Server MVP) - 30 Apr 2008 16:21 GMT

DBCC OPENTRAN can be used to find open transactions.

Roy Harvey
Beacon Falls, CT

>Hi Ron,
>
[quoted text clipped - 50 lines]
>>
>> - Show quoted text -

Reply to this Message