enrique_aeo
asked on
temp DB - add files
Hi experts
i have this server:
Nombre Servidor: BDSIS02
Sistema Operativo: Windows Server 2008 R2 Enterprise 64-bit (6.1, Build 7601) Service Pack 1 (7601.win7sp1_gdr.140303-2 144)
Marca: IBM
Modelo del sistema: System x3650 M3 -[7945AC1]
Procesador: Intel(R) Xeon(R) CPU X5680 @ 3.33GHz (24 CPUs)
Memoria: 65536 MB RAM
Memoria disponible SO: 65524 MB RAM
I have the following storage units
SQL_CT2(M:)
SQL_CT1(K:)
SQL_CT1(J:)
SQL_CT3(I:)
SQL_CT4(P:)
Total TB: 12
If I want to increase my tempdb:
Currently I occupy space purely bd totaling 6564.84 (including database system) would be 20% (6564.84) -> 1.3 TB data files that you create must be different is to better performance units or simply to this in a different unit E as would their recommended size.
When the tempdb should be added only data files (* .ndf)
i have this server:
Nombre Servidor: BDSIS02
Sistema Operativo: Windows Server 2008 R2 Enterprise 64-bit (6.1, Build 7601) Service Pack 1 (7601.win7sp1_gdr.140303-2
Marca: IBM
Modelo del sistema: System x3650 M3 -[7945AC1]
Procesador: Intel(R) Xeon(R) CPU X5680 @ 3.33GHz (24 CPUs)
Memoria: 65536 MB RAM
Memoria disponible SO: 65524 MB RAM
I have the following storage units
SQL_CT2(M:)
SQL_CT1(K:)
SQL_CT1(J:)
SQL_CT3(I:)
SQL_CT4(P:)
Total TB: 12
If I want to increase my tempdb:
Currently I occupy space purely bd totaling 6564.84 (including database system) would be 20% (6564.84) -> 1.3 TB data files that you create must be different is to better performance units or simply to this in a different unit E as would their recommended size.
When the tempdb should be added only data files (* .ndf)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
or the maximum size is 5GB for each of the files (8 in this case)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I do not remember where I read that article to calculate the size of the temporary bd should be 20% of the sum of all user Bd, if not, then as calculate the minimum and maximum size of Tempdb bd. Thank you.
Scenario 1: If all bd would add 200MB to 1000MB then the tempDB so serious 25MB for each file, right?
Scenario 2: If all bd would then add 10TB 2TB for tempDB so serious 0.25TB for each file, right?
If I am wrong please tell me how to calculate the size of each file bd tempDB is both scenarios. thanks
Scenario 1: If all bd would add 200MB to 1000MB then the tempDB so serious 25MB for each file, right?
Scenario 2: If all bd would then add 10TB 2TB for tempDB so serious 0.25TB for each file, right?
If I am wrong please tell me how to calculate the size of each file bd tempDB is both scenarios. thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I agree.
then
2TB tempdb = size of the largest table. Therefore 8 files 0.25TB each, correct?
then
2TB tempdb = size of the largest table. Therefore 8 files 0.25TB each, correct?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
20% of all my bd user is 1.3 TB, then that should divide by 8, so the size of each file must be 162.5 GB, is that correct?