This document was generated from CDN thread
Created by: Tobias Balliel on 16-06-2010 10:39:53 AM
Hi,
is there a way to integrate the local MSSQL database into a external MSSQL database without setting up a tcs-cluster?
Tobias
Subject: RE: integrate SQL Database into external Database
Replied by: James Petersen on 17-06-2010 03:18:21 AM
Hello Tobias,
There is no way to do this at present. I would like to learn about why you would like this capability and how you might light to have it enabled.
Are you happy to respond in this forum, so that others may benefit from and or contribute to our discussion?
Jim Petersen
Product manager, recording and streaming
Subject: RE: integrate SQL Database into external Database
Replied by: Tobias Balliel on 17-06-2010 09:38:17 AM
Hello Jim Petersen, hi all,
We have over 600 recordings on our Content Server.
Unfortunately we now have a problem with the login.
The access authorisation is controlled with groups in our active directory.
Due to the high amount of videos and different access modes,
when a user loggs in to the TCS it takes about 40s until the recorded conferences list will load.
The local SQL-Server is apparently overloaded(100%CPU load during the login),
when each video has to be verified if the user is allowed to see it or not.
The user gets the impression, that the TCS ist unavailable and will close the page.
We have a very powerful MS SQL Server cluster, and it would be nice if we could use it for the TCS.
(without buying a second TCS, only for the possibility to configure the external database)
Tobias Balliel
ps. hopefully the SQLStatments will be optimized in future software versions.
//edit:
implementing a "add/change/edit MS SQL Database Settings" function
into the TCS Wizard or the Management Settings in the TCS-Webinterface
Subject: RE: integrate SQL Database into external Database
Replied by: James Petersen on 22-06-2010 04:16:19 AM
Hlello Tobias,
We test with TCS hosting tens of thousands of recordings and do not experience the symptoms you describe.
This is not an integration or development matter, so I recommend you work on this with the Tandberg support team. They will be able to help you and will obtain help from the deveopment team if necessary. We will happy to help if required via that forum.
Jim Petersen.
Subject: RE: integrate SQL Database into external Database
Replied by: Tobias Balliel on 22-06-2010 09:35:31 AM
hi Jim,
The fact that we have 2100 registered users/groups(with different Conference permissions) in our TCS, and over 10700 registered user in our Active Directory structure, is not a possible problem?
Tobias Balliel.
