Server at 100% CPU Usage

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Locked
sswanson
Posts: 19
Joined: Tue Nov 14, 2006 10:27 am

Server at 100% CPU Usage

Post by sswanson » Thu Sep 13, 2007 2:58 pm

We've just upgraded to Vault 4.0.4 from 3.5.1 and everything appears to be working fine, save for that when I access the Admin Utilities through the web interface, when I try and click on a repository to pull up its information SQL's CPU usage shoots through the roof to 99% and the server that Vaults on drags to a halt. Before anything returns to normal the browser has to be killed or no one can do anything. Is this a known issue, and if so, is there a fix to it?

-Seth Swanson

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Thu Sep 13, 2007 4:19 pm

This isn't a known issue. Does it happen every tiime you access a specific repository?

Is there any helpful information in the Vault Server log? It's sgvault.log in %windir%\temp\sgvault. Anything in the Windows Event Viewer?
Linda Bauer
SourceGear
Technical Support Manager

sswanson
Posts: 19
Joined: Tue Nov 14, 2006 10:27 am

Post by sswanson » Fri Sep 14, 2007 7:44 am

Alright...for some reason the problem seems to have fixed itself. If it comes up again I'll make sure to get the log and send it off. Thanks.

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Mon Sep 17, 2007 6:27 am

Must have been the tech-support magic wand. :-)

Let us know if you encounter this again in the future.
Linda Bauer
SourceGear
Technical Support Manager

Locked