Re: Extremely Long Transactions

just an update for anyone watching on the list.

we've contacted john, and we're looking at some issues related to the vault database itself.  when we get to the bottom of this, i'll post the results to the list.

jeff
sourcegear


*********** REPLY SEPARATOR  ***********

On 2/11/2004 at 2:33 PM John Saunders wrote:

>I'm running the SQL Profiler while waiting for a very long transaction to
>finish (clicking on the "Change Source Control" toolbar icon in VS.NET for
>the first time in a session). I see that the following query was run:
>
>exec dbo.spgetfsobjectversionproperties @repid = 1, @objverid = 843034
>
>If I understand the "Duration" column, it's saying that it took 425 seconds
>for this query to complete.
>
>This is a small project, and I'm not sure what the devil the system is
>doing. BTW, it's got sqlserver.exe pegging the CPU during this.
>
>Any clues on this?
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
>John Saunders                   E-mail: [email protected]
><mailto:[email protected]>  
>Internet Engineer                                Tel: +1 508 621 3818 
>WWW: www.surfcontrol.com <http://www.surfcontrol.com>
>Fax: +1 508 621 3921 
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
>      SurfControl - the World's #1 Web & E-mail Filtering Company 
>===================================================================== 
>
>
>Get the latest news on SurfControl and our products,
>subscribe to our monthly e-newsletter, SurfAdvisory at:
>http://www.surfcontrol.com/resources/surfadvisory/surfadvisory_signup.aspx
>
>*********************************************************************
>The information in this email is confidential and may be legally
>privileged. It is intended solely for the addressee. Access to this
>email by anyone else is unauthorized. If you are not the intended
>recipient, any disclosure, copying, distribution or any action taken
>or omitted to  be taken in reliance on it, is prohibited and may be
>unlawful. If you believe that you have received this email in error,
>please contact the sender.
>*********************************************************************
>SurfControl Inc.
>100 Enterprise Way, Suite A110
>Scotts Valley, California 95066
>831-440-2500
>_______________________________________________