SQL server, many connections
We are hosting SQL across the world, it seems the last few versions of RDM are getting slower and slower to load our data, we also are adding new connections.
If I watch traffic between SQL and RDM, its going at 1/KB a sec, as though its doing very many small queries.
What method is being used to get the info, it just seems very chatty, and as you scale up, its getting slower and slower?
All Comments (7)
Hi,
I don't remember any change in the last few version about SQL Server but I will take a look. We are working on the server edition of our product to simplify the deployment. I think that it will be less chatty and the database will be hidden behind the server.
David Hervieux
Just to add, I recently setup a small SQL based deployment on our network for RDM (new to the product) and I came here looking for folks with the same issue.
Hi,
You use use the inherited folder security?
David Hervieux
Do you mean the "cascade security to children" checkbox on groups/folders? If yes, I have that set on one folder to keep people out of it, otherwise the rest are unchecked.
Our layout is as follows (hopefully it makes sense)
Root
-Internal servers (this has the cascade checkbox checked)
--Site Physical Location
---Network
---Servers
-Customers
--CustomerXYZ (there are 101 customer folders)
---Site Physical Location
----Network
----Servers
Grand total of 964 sessions currently, and will be growing. Let me know if that could be an issues or you have any pointers. We're a support company, so we have all our customer's setup in RDM for ease of support.
Hi,
We are using inherited security yes.
Like tommucha, we are doing the same thing, but only 181 session so far.
I think the server pricing would be a little out of our reach though. Wish it wasn so, exchange rates don't really work out for us!.
Still love your product though. My staff say its life changing! :)
Hi,
I have done some optimization (mostly caching) and I hope this help. Also could you verify the refresh rate in the data source configuration). Do you see a performance difference within an Admin user and a normal user? I will release a new beta version soon and includes this modifications.
edited by dhervieux on 11/26/2011
David Hervieux
I'll do some testing with a non-admin user and see how it goes. Right now my timeouts are the default from when I did the setup:
Auto Refresh - 0 sec
Connection Timeout - 30 sec
Command Timeout - 60 sec