sql server odbc: Insert Performance Degradation -- sql server odbc

Insert Performance Degradation

RG
2/17/2005 8:39:09 AM

sql server odbc: I am working with SQL Server 7 on win2k server. There was a vb6 ado ODBC
application written accessing this SQL Server 7 db. Unfortunately, through a
series of workstation upgrades, the source code was lost.

Recently, the performance of table inserts degraded significantly. I am
trying figure out as to what is causing it.

I am guessing there is some sort of locking problem going on.

Is there a utility which allows you to trace ODBC activity?

If anyone knows of any other utility or method to diagnose the problem, I
would greatly appreciate help.

Re: Insert Performance Degradation

Sue Hoegemeier
2/22/2005 3:09:52 PM

If you think there is some locking, blocking going on then
you likely want to monitor this in SQL Server. You can start
by using the system stored procedures sp_lock, sp_who2 and
querying master..sysprocesses.
You may also want to take a look at the following article:
INF: How to Monitor SQL Server 7.0 Blocking
http://support.microsoft.com/?id=251004

-Sue

On Thu, 17 Feb 2005 08:39:09 -0800, "RG"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.