Cancel
Showing results for 
Search instead for 
Did you mean: 

Chosing Right Microsoft SQL License.

Solution Partner Valued Contributor Solution Partner Valued Contributor
Solution Partner Valued Contributor

Hello ,

 

Two questions are coming about again SQL J . ı'm working an new project and as you know , generally , i don’t prefer to  provide the SQL License for the companies so i said that , you should provide SQL License to install or manage TC database. But , for new project , they want to me to provide SQL License .

As you know , SQL works as two different type and they are SQL Standard and SQL Enterprise. Also these two types are divided internally accoriding to the their licensing types. I think , i can suggest to company to SQL Standard.

 

SQL Standard is providing CAL License type and that licensing type is working related to number of users. The question is coming on that point , Do i have to buy license according to the number of TC user ? (Such as : The company has 64 TC users ) or Is it enough to buying a Microsoft SQL Standard License with CAL License for just one user.?

I couldn't find any inf. about it from the installation document or other sides.

Thanks a lot for answers and helps.

 

Best Regards

Gurkan

9 REPLIES

Re: Chosing Right Microsoft SQL License.

Solution Partner Valued Contributor Solution Partner Valued Contributor
Solution Partner Valued Contributor

Also ,

The other question is that , to use healty database we have to set some maintenace plan on SQL . I don't have so much experinces about SQL and i know just 3 maintenance task (i don't know it is right word sorry) they are ;

1-) Replace -Repair Task - It tydie up the tables , to reach information quickly.

2-) Database Backup - providing database backup

3-) Shrink - to create free space on Server

Do you suggest to me to additional maintanance tasks to keep database always healty ?

Thanks for helps.

 

Gurkan

Re: Chosing Right Microsoft SQL License.

Solution Partner Honored Contributor Solution Partner Honored Contributor
Solution Partner Honored Contributor
CAL's are usually computed against the number of processors and not the number of users. They could try rolling it out on a machine with 2 CPUs running 8 processors each (x16 CAL's). I would not buy MS SQL for a customer. Even Siemens tells them to purchase from the vendor (Microsoft). Are you bigger than Siemens?

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

Re: Chosing Right Microsoft SQL License.

Solution Partner Honored Contributor Solution Partner Honored Contributor
Solution Partner Honored Contributor
Yes, get a DBA or stop selling/supporting MS SQL. It's complicated. Small changes can have a large effect on performance (good or bad).

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

Re: Chosing Right Microsoft SQL License.

Siemens Phenom Siemens Phenom
Siemens Phenom

Don't use "Shrink". It hurts performance.

I regularly use the following maintenance tools (daily or weekly) depending on the need at the site:

  1. Rebuild Index
  2. Update Statistics
  3. Clean up History
  4. Check DB Integrity
  5. Back up
  6. Cleanup

There are also a number of settings for optimal performance.


Larry Carpenter, P.E.
CAxPLM Architect @ Siemens Molecular Imaging
Past Board Member @ PLM World, Inc,

Re: Chosing Right Microsoft SQL License.

Legend
Legend

Hi

 

We have MS SQL Enterprise for our production and it works well but it's necessary to have the know-how how to setup the infrastructure correct with fast disk etc. 

 

I came across one thing with MS SQL Standard last week as we have that version as well. I use this database server for development databases.

When I should run the Teamcenter index_verify command and from the report update the index. I opened up the Management Studio and run the ALTER INDEX command that I got from the report there and got this reply:

Online index operations can only be performed in Enterprise edition of SQL Server.

 

So I recommend to have Enterprise version for production as the index on the tables in Teamcenter are many and you will not have time to do it manually.

 

When it comes to buy license for another company I do think you are on deep water if that company shall be compliant towards Microsoft. A review can hit them hard so let them buy the licenses.

 

 

Jörgen Mähler, PLM Lead Hydro
TC11.5 | TcIC11.5 | Swim 11.4 | Supplier Collaboration
NX 11,12 | Catia V5 | Solidworks 2018 | AutoCad2018

Re: Chosing Right Microsoft SQL License.

Siemens Experimenter Siemens Experimenter
Siemens Experimenter

In a special resaerch project we used MS SQL Server 2016 for Teamcenter. MS Sql Server and Teamcenter are running on VMs. Now the evaluation period for SQL Server has expiered and I need to know which licenses are needed. From my understanding there are 2 options:

1. Microsoft SQL Server Standard 2016 + 1 (or2)  User CAL

2. Microsoft SQL Server Standard 2016 2-Core

Is this correct?

Re: Chosing Right Microsoft SQL License.

Solution Partner Valued Contributor Solution Partner Valued Contributor
Solution Partner Valued Contributor

Hi @kzknl4  ,

 

Yes you are right , there are two options as you mentioned.

 

Best Regards

Gurkan

Re: Chosing Right Microsoft SQL License.

Siemens Experimenter Siemens Experimenter
Siemens Experimenter

Hi Gurkan,

thanks for the quick confirmation.

If we have more than one Teamcenter instances, do we need 1 User CAL per TC instance?

 

Best Regards

Georg

Re: Chosing Right Microsoft SQL License.

Solution Partner Valued Contributor Solution Partner Valued Contributor
Solution Partner Valued Contributor

Hi Georg ,

 

Yes it should be like that. As i know , you will need CAL user license , according to the user of teamcenter and how many users should use the teamcenter and write to database. In addition maybe you can use the SQL Instance for different teamcenters. Please check the link below.

 

https://docs.plm.automation.siemens.com/tdoc/tc/11.2/help#uid:index_server_win:partdbinstall_v1:tsql...

 

Best Regards

Gurkan