Slow Get Label in Fortress 1.1.4.18402

[adofito]

Hi there,

We have just moved the fortress SQL Database to a new SQL 2008 server. And it is really slow getting labels. Everything else is fast.

I also created a new repository with only the latest stuff because our old repository had around 500k revisions already and we wanted to make it faster with cleaner content, but to no success.

It even times out sometimes. I have enabled debugging mode in Fortress and I see that Fortress gets stuck right after:

Code: Select all

----3/23/2010 12:28:31 PM    xxxxx--xxx.xxx.xxx(xxx.18.1.xxx)--SSL Disabled	DB: ConvertLabelPathsToObjIDPaths finished. 
----3/23/2010 12:28:31 PM    xxxxx--xxx.xxx.xxx(xxx.18.1.xxx)--SSL Disabled	DB: CheckLabelFiles started. 
----3/23/2010 12:28:32 PM    xxxxx--xxx.xxx.xxx(xxx.18.1.xxx)--SSL Disabled	DB: CheckLabelFiles finished. 
----3/23/2010 12:28:32 PM    xxxxx--xxx.xxx.xxx(xxx.18.1.xxx)--SSL Disabled	DB: ConvertLabelPathsToObjIDPaths started. 

Then, nothing happens for 20 minutes.

Can anybody help me on this?

-Carlos

PS. I am setting up a couple of test servers to test the new Fortress 2.0 but in the meantime I really need to solve this.

[Beth]

What happens if you try to get a label from a client right on the server using localhost to connect?

Are you using folder security?

[adofito]

We are using Windows 2008 with no GUI installed in the server so I can't run the client from the server but I can use the command line version of it in the server. I will try that.

No folder security.

-Carlos

[adofito]

Maybe I should've said this before but we have Fortress and the SQl server running in the same box now. It's a powerful box so I hope that is not a problem.

-Carlos

[Beth]

How large is the individual label you are trying to get?

How many labels do you have?

Are you performing regular database maintenance? Details on what we recommend for maintenance are posted here: Maintenance: The Vault Server database

How did you go about moving your SQL database to the new SQL server?