We help IT Professionals succeed at work.
Research Question

Tempdb file can be used by SQL server 2016 standard edition FCI

16 Views
Last Modified: 2020-10-23
hi,

as SQL server 2016 standard edition FCI has limited on number of CPU core , 24 core and RAM limit , 124GB, may I know is there any number of tempdb file limiation for SQL server 2016 standard edition ?

Comment
Watch Question

Máté FarkasSQL Server Consultant
CERTIFIED EXPERT

Commented:
These kind of limitation are not depended on Edition of SQL Server.
So you can create many-many files (32k) of a database.
https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15
marrowyungSenior Technical architecture (Data)

Author

Commented:
hi,
I read this :
https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-ver15

nothing about tempdb at all, please correct me if I am wrong.
currently we have 8 tempdb files and we have 20 CPUs in this SQL server 2016 standard edition FCI, so adding 12 mores tempdb data file of equal size so that total number of tempdb data file is 20 makes sense?


Máté FarkasSQL Server Consultant
CERTIFIED EXPERT

Commented:
You read a wrong article because it is about supported features and not about limitations. Please read the article I sent.
Yes, it not just makes sense but it is recommended to have as many database files as cpus in tempdb.
marrowyungSenior Technical architecture (Data)

Author

Commented:
ok .tks.
 I have to do this operation this sat. hope when I have trouble I can come here and message you. but very less likely.

time should be 6-7AM in your time :):)

marrowyungSenior Technical architecture (Data)

Author

Commented:
btw, the link you show me do not say it is for tempdb, am I right?
SQL Server Consultant
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
marrowyungSenior Technical architecture (Data)

Author

Commented:
ok let me try.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions