Secret Server

Please use the Forums for general questions, feedback and feature requests

Want the latest Secret Server news? Sign Up for our Mailing List

 All Threads | New ThreadView:  Search:  
 Author  Thread: Slow loading of data.
Andy Sharman
Posts: 8
Slow loading of data.
Posted: 17 Dec 2009 4:17 AM

Hi.

We are getting a repeated number of users complaining of very slow loading of data when they log into Secret Server.

It appears that this occurs when a user does not have any search criterea stated or any folder selected.
In these instances it appears as though the system attempts to retrieve every record from the database to display to the user.

This therefore leads to a very slow access to user data.

We are running the latest version of Secret Server but got this issues with older versions also.

Any ideas.

Andy Sharman

[Reply][Quote]
Jeremy Agnew
Posts: 48
Re: Slow loading of data.
Posted: 17 Dec 2009 6:34 AM

Not sure if this will help, but we had simillar issues with some people. Turned out they had there result size set to 100 or All. We have over 800 passwords, so this can slow things down.

Try this, it helped my users

Go to search tab, set result size to 30 (or similar sized number), do a blank search. The Browse tab will remember your result size, and show only show 30 passwords at a time now, making folder browsing much faster.


--
http://www.ignitionmsp.com/
[Reply][Quote]
Scott
Posts: 31
Re: Slow loading of data.
Posted: 17 Dec 2009 8:32 AM

Thank you for your post Andy.

And thank you for your reply Jeremy. That is definitely the place to start assuming your users have hundreds of secrets.

This is probably not the cause either, but running in Unlimited Administrator mode will slow things down as well. It is recommended only in extreme cases and should be turned off when not needed anymore.

Andy, please let us know if this does not resolve your slow-down issues.

best,
Scott Santos
Thycotic Support

[Reply][Quote]
Andy Sharman
Posts: 8
Re: Slow loading of data.
Posted: 18 Dec 2009 2:35 AM

Hi.

Many thanks for your quick replies.

We will give it a go and let you know.

Is there a global setting that can be set for this so it applies to all users.

Andy

[Reply][Quote]
Scott
Posts: 31
Re: Slow loading of data.
Posted: 18 Dec 2009 7:26 AM

Andy,

At present, there is no administrator setting for the Secret search results display size.

I will add this as a feature request as I can see how this may be useful for administrators attempting to troubleshoot issues.

I am going to create a support ticket for you to further assist you in narrowing down the cause of these slow-downs.

Scott Santos
Thycotic Support

[Reply][Quote]
Andy Sharman
Posts: 8
Re: Slow loading of data.
Posted: 18 Dec 2009 4:37 PM

Scott.

Many thanks for your SQL scripts.

I will look at getting these ran on Monday to hopefully fix this issue.

Thanks again.

Andy

[Reply][Quote]
 Page 1 of 1