Forum

Posts by crowda (crowda)

crowda
crowda
Posts: 18

renlang, i'm having the same issue. I"m not following exactly what you did to fix this. Can you tell me what steps you took to resolve it?

6 yrs Problem with SQL Server Refresh
crowda
crowda
Posts: 18

Well in the Good one, I just give everyone access to everything, but in the Finance I have some sub groups.

Am I doing something wrong? The view Edit, and Delete permissions part seem to be working right. It's just the View Password that is not.

6 yrs RDMS Users can't view passwords
crowda
crowda
Posts: 18

Any word on this? I really need to get my folks access.

6 yrs RDMS Users can't view passwords
crowda
crowda
Posts: 18

I just sent you the support stuff. From David Crow

6 yrs RDMS Users can't view passwords
crowda
crowda
Posts: 18

Not sure what config you need to see.
RDMS+good


RDMS+bad

6 yrs RDMS Users can't view passwords
crowda
crowda
Posts: 18

I'm trying to sort out why my user's can't view passwords in RDMS. I've got a role tied to an AD group and it allows add, create, delete, etc, but not reveal password.

I've got other Roles in different RDMS databases setup similarly and they seem to work fine so i'm not sure what's going on with this one.

What can I look at to troubleshoot this?

6 yrs RDMS Users can't view passwords
crowda
crowda
Posts: 18

if I use a SQL server data source it allows me to use the logged in user's login credentials. With the RDMS data source this doens't seem to be allowed. Am I missing something or is that correct?

I like being able to use the AD groups with RDMS, but this is a slight annoyance.

6 yrs RDMS Data Source Requires Password
crowda
crowda
Posts: 18

Would the server version improve performance with this many entries?

6 yrs SQL Server Performance
crowda
crowda
Posts: 18

Thanks, any help would be appreciated. I'm getting a lot of pushback about how slow this is running.

6 yrs SQL Server Performance
crowda
crowda
Posts: 18

That one was a credential edit. This is from a session edit.

LoadConnections [Microsoft SQL Server/SQL Azure : VC3 RDM] - 64-bit...
LoadConnectionsFromDataSource...
LoadDataSourceSettingsFromDataSource...
GetDataSourceSettings : 1 ms
LoadDataSourceSettingsFromDataSource : 3 ms
OfflineManager.Save : 38 ms
GetConnections...
Database.GetConnections...
Reading connections from database : 0 ms
ConnectionInfos.Foreach...
Decrypt (multi-threaded) : 295 ms
Deserialize (multi-threaded) : 0 ms
ConnectionInfos.Foreach : 11 ms
Database.GetConnections : 320 ms
GetConnections : 328 ms
PrepareConnectionList : 0 ms
ThreadQueue.AddRow : 406 ms
OfflineManager.Save : 39 ms
DoMergeConnections : 2511 ms
LoadConnectionsFromDataSource : 2902 ms
LoadConnections [Microsoft SQL Server/SQL Azure : VC3 RDM] - 64-bit : 3030 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
BuildGroupList...
FirstLoop : 3 ms
FindConnectionGroup : 76 ms - Count:122
BuildGroupList : 17 ms
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 2294 ms
PreCreateGroups : 107 ms - Count:1
BeginUpdate : 137 ms
TreeView.LoadConnectionList : 2554 ms
FrmConnection.DoInitializeComponent...
FrmConnection.RegisterDescriptors...
FrmConnection.RegisterDescriptors : 78 ms
FrmConnection.DoInitializeComponent : 753 ms
FrmConnection.LoadGroups...
FrmConnection.LoadGroups : 44 ms
FrmConnection.LoadConnectionInControls...
FrmConnection.freConnectionMorePanel...
FrmConnection.freConnectionMorePanel : 7 ms
FrmConnection.freConnectionVPNPanel...
FrmConnection.freConnectionVPNPanel : 42 ms
FrmConnection.freConnectionAdvancedPanel...
FrmConnection.freConnectionAdvancedPanel : 0 ms
FrmConnection.CreateConnectionSettingsFrame...
FrmConnection.CreateConnectionSettingsFrame : 14984 ms
FrmConnection.LoadCredentialSessions...
FrmConnection.LoadCredentialSessions : 543 ms
FrmConnection.LoadCredentialSessions...
PersonalConnectionManager.Refresh...
PersonalConnectionManager.Refresh : 2 ms
FrmConnection.LoadCredentialSessions : 17 ms
FrmConnection.LoadCredentialsToControls...
FrmConnection.LoadCredentialsToControls : 7 ms
FrmConnection.Panels.LoadConnectionInControls...
FrmConnection.Panels.LoadConnectionInControls : 1203 ms
PersonalConnectionManager.Refresh...
PersonalConnectionManager.Refresh : 1 ms
FrmConnection.LoadConnectionInControls : 17347 ms
FrmConnection.Shown...
FrmConnection.Shown : 23 ms
LoadConnections [Microsoft SQL Server/SQL Azure : VC3 RDM] - 64-bit...
LoadConnectionsFromDataSource...
LoadDataSourceSettingsFromDataSource...
GetDataSourceSettings : 7 ms
LoadDataSourceSettingsFromDataSource : 13 ms
OfflineManager.Save : 37 ms
GetConnections...
Database.GetConnections...
Reading connections from database : 0 ms
ConnectionInfos.Foreach...
Decrypt (multi-threaded) : 0 ms
Deserialize (multi-threaded) : 0 ms
ConnectionInfos.Foreach : 10 ms
Database.GetConnections : 28 ms
GetConnections : 38 ms
PrepareConnectionList : 0 ms
ThreadQueue.AddRow : 52 ms
ThreadQueue.AddRow : 24 ms
OfflineManager.Save : 37 ms
DoMergeConnections : 4872 ms
LoadConnectionsFromDataSource : 4994 ms
LoadConnections [Microsoft SQL Server/SQL Azure : VC3 RDM] - 64-bit : 5125 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
BuildGroupList...
FirstLoop : 3 ms
FindConnectionGroup : 73 ms - Count:122
BuildGroupList : 16 ms
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 2267 ms
PreCreateGroups : 104 ms - Count:1
BeginUpdate : 134 ms
TreeView.LoadConnectionList : 2520 ms

6 yrs SQL Server Performance
crowda
crowda
Posts: 18

BuildGroupList...
FirstLoop : 0 ms
FindConnectionGroup : 0 ms - Count:2
BuildGroupList : 3 ms
LoadConnections [Microsoft SQL Server/SQL Azure : VC3 RDM] - 64-bit...
LoadConnectionsFromDataSource...
LoadDataSourceSettingsFromDataSource...
GetDataSourceSettings : 1 ms
LoadDataSourceSettingsFromDataSource : 4 ms
OfflineManager.Save : 46 ms
GetConnections...
Database.GetConnections...
Reading connections from database : 0 ms
ConnectionInfos.Foreach...
Decrypt (multi-threaded) : 1 ms
Deserialize (multi-threaded) : 0 ms
ConnectionInfos.Foreach : 12 ms
Database.GetConnections : 36 ms
GetConnections : 49 ms
PrepareConnectionList : 0 ms
ThreadQueue.AddRow : 17 ms
ThreadQueue.AddRow : 63 ms
OfflineManager.Save : 37 ms
DoMergeConnections : 4009 ms
LoadConnectionsFromDataSource : 4143 ms
LoadConnections [Microsoft SQL Server/SQL Azure : VC3 RDM] - 64-bit : 4264 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
BuildGroupList...
FirstLoop : 3 ms
FindConnectionGroup : 77 ms - Count:122
BuildGroupList : 16 ms
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 2349 ms
PreCreateGroups : 99 ms - Count:1
BeginUpdate : 139 ms
TreeView.LoadConnectionList : 2603 ms
FrmConnection.LoadGroups...
FrmConnection.LoadGroups : 444 ms
BuildGroupList...
FirstLoop : 0 ms
FindConnectionGroup : 0 ms - Count:2
BuildGroupList : 11 ms
LoadConnections [Microsoft SQL Server/SQL Azure : VC3 RDM] - 64-bit...
LoadConnectionsFromDataSource...
LoadDataSourceSettingsFromDataSource...
GetDataSourceSettings : 1 ms
LoadDataSourceSettingsFromDataSource : 6 ms
OfflineManager.Save : 33 ms
GetConnections...
Database.GetConnections...
Reading connections from database : 0 ms
ConnectionInfos.Foreach...
Decrypt (multi-threaded) : 0 ms
Deserialize (multi-threaded) : 0 ms
ConnectionInfos.Foreach : 8 ms
Database.GetConnections : 26 ms
GetConnections : 34 ms
PrepareConnectionList : 0 ms
ThreadQueue.AddRow : 11 ms
OfflineManager.Save : 36 ms
DoMergeConnections : 4516 ms
LoadConnectionsFromDataSource : 4620 ms
LoadConnections [Microsoft SQL Server/SQL Azure : VC3 RDM] - 64-bit : 4743 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
BuildGroupList...
FirstLoop : 3 ms
FindConnectionGroup : 76 ms - Count:122
BuildGroupList : 18 ms
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 2403 ms
PreCreateGroups : 98 ms - Count:1
BeginUpdate : 146 ms
TreeView.LoadConnectionList : 2662 ms
BuildGroupList...
FirstLoop : 0 ms
FindConnectionGroup : 0 ms - Count:2
BuildGroupList : 9 ms

6 yrs SQL Server Performance
crowda
crowda
Posts: 18

Any ideas?

6 yrs SQL Server Performance
crowda
crowda
Posts: 18

I'll give a thumbs up to Labtech integration as well.

6 yrs Using RDM to open Labtech sources
crowda
crowda
Posts: 18

Oh, sorry, I did a refresh.

Here is what it looks like when I do the editor.

BuildGroupList...
FirstLoop : 0 ms
FindConnectionGroup : 1 ms - Count:3
BuildGroupList : 3 ms
BuildGroupList...
FirstLoop : 0 ms
FindConnectionGroup : 1 ms - Count:3
BuildGroupList : 5 ms
LoadConnections [Microsoft SQL Server/SQL Azure : vc3-rd-01] - 64-bit...
Connection cache up to date
LoadConnections [Microsoft SQL Server/SQL Azure : vc3-rd-01] - 64-bit : 114 ms
FrmConnection.DoInitializeComponent...
FrmConnection.RegisterDescriptors...
FrmConnection.RegisterDescriptors : 73 ms
FrmConnection.DoInitializeComponent : 654 ms
FrmConnection.LoadGroups...
FrmConnection.LoadGroups : 44 ms
FrmConnection.LoadConnectionInControls...
FrmConnection.LoadCredentials...
PersonalConnectionManager.Refresh...
PersonalConnectionManager.Refresh : 16 ms
FrmConnection.LoadCredentials : 578 ms
FrmConnection.LoadConnectionInControls : 2248 ms
FrmConnection.Shown...
FrmConnection.Shown : 21 ms
LoadConnections [Microsoft SQL Server/SQL Azure : vc3-rd-01] - 64-bit...
Connection cache up to date
LoadConnections [Microsoft SQL Server/SQL Azure : vc3-rd-01] - 64-bit : 131 ms

6 yrs SQL Server Performance
crowda
crowda
Posts: 18

LoadConnections [Microsoft SQL Server/SQL Azure : vc3-rd-01] - 64-bit...
OfflineManager.LoadConnections...
LoadConnectionsFromOfflineFile...
DeserializeData : 0 ms
ReadFromOffline : 1 ms
LoadConnectionsFromOfflineFile : 5 ms
OfflineManager.LoadConnections : 96 ms
LoadConnectionsFromDataSource...
LoadDataSourceSettingsFromDataSource...
GetDataSourceSettings : 1 ms
LoadDataSourceSettingsFromDataSource : 6 ms
OfflineManager.Save : 17 ms
GetConnections...
Database.GetConnections...
Reading connections from database : 471 ms
ConnectionInfos.Foreach...
Decrypt (multi-threaded) : 3836 ms
Deserialize (multi-threaded) : 199 ms
ConnectionInfos.Foreach : 13 ms
Database.GetConnections : 4540 ms
GetConnections : 4549 ms
PrepareConnectionList : 12 ms
ThreadQueue.AddRow : 34 ms
ThreadQueue.AddRow : 374 ms
ThreadQueue.AddRow : 161 ms
ThreadQueue.AddRow : 139 ms
ThreadQueue.AddRow : 157 ms
ThreadQueue.AddRow : 156 ms
ThreadQueue.AddRow : 157 ms
ThreadQueue.AddRow : 149 ms
ThreadQueue.AddRow : 168 ms
ThreadQueue.AddRow : 184 ms
ThreadQueue.AddRow : 193 ms
ThreadQueue.AddRow : 191 ms
ThreadQueue.AddRow : 197 ms
ThreadQueue.AddRow : 202 ms
ThreadQueue.AddRow : 197 ms
ThreadQueue.AddRow : 125 ms
OfflineManager.Save : 13 ms
DoMergeConnections : 7414 ms
LoadConnectionsFromDataSource : 12018 ms
LoadConnections [Microsoft SQL Server/SQL Azure : vc3-rd-01] - 64-bit : 12317 ms
TreeView.LoadConnectionList...
GetGroupInfos : 0 ms
BeginUpdate...
BuildGroupList...
FirstLoop : 3 ms
FindConnectionGroup : 70 ms - Count:118
BuildGroupList : 16 ms
ApplyGroupCustomImages : 0 ms
LoadConnectionInTreeNode : 2322 ms
PreCreateGroups : 96 ms - Count:1
BeginUpdate : 126 ms
TreeView.LoadConnectionList : 2556 ms

6 yrs SQL Server Performance
crowda
crowda
Posts: 18

Sure

6 yrs SQL Server Performance
crowda
crowda
Posts: 18

Yes Intelligent Cache is on and I tried the disable refresh before edit and that speeds it up slightly, but there is still a pretty good delay. We could try splitting up the database by region or something, but that seems like a poor choice. Is there no database indexing or something we could do to speed it up?

6 yrs SQL Server Performance
crowda
crowda
Posts: 18

We've got a new installation of SQL Server on a dedicated system. We've got about 7300 entries in the RDM database. Performance is noticeably slower than on a data source with only 2500 entries.

When opening the Edit Credentils dialog on the larger database it takes about 5 seconds for the screen to open.

Is there any tuning or troubleshooting we can do with this?

-David

6 yrs SQL Server Performance