cancel
Showing results for 
Search instead for 
Did you mean: 

Temp DB in Bi7

Sriram2009
Active Contributor
0 Kudos

Hi

Currently Our Temp DB growing 30 GB we can delete the temp DB in Sap Bi7? Kindly guide us

Regards

Sriram

Accepted Solutions (1)

Accepted Solutions (1)

Sriram2009
Active Contributor
0 Kudos

Hi all

Any updates ?

Regards

Sriram

Former Member
0 Kudos

Sriram,

John explanation should have given you decent idea and answer to your question.

Go through the following document, which clearly explained design considerations for MS SQL running ERP ( OLTP) and BI/BW (OLAP)

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SAP_SQL2005_Best%2...

Regards,

Krishna

Answers (3)

Answers (3)

former_member189546
Active Contributor
0 Kudos

Hello,

The database tempdb provides a storage area for temporary tables,

temporary stored procedures, and other temporary working storage needs.

Please check the following parameters in your system.:

Set Working Set Size = 0

Priority Boost = 0

When SQL runs out of memory, and needs more, it overflows into Tempdb,

this could be why the system needed more Tempdb space.

This could explain the increased Tempdb growth. Please check

the amount of memory for SQL Server in your system.

By default, the tempdb database automatically grows as space is needed

because the MAXSIZE of the files is set to UNLIMITED. Therefore, tempdb

can continue growing until space on the disk that contains tempdb is

exhausted. To prevent tempdb from growing without limits, set a MAXSIZE

for tempdb by using the ALTER DATABASE statement or SQL Server

Enterprise Manager.

Another way would be restart SAP Server including SQL Server,Then Tempdb

will be cleared and size comes to normal.

Check note

879941 Configuration Parameters for SQL Server 2005

regards,

John Feely

Sriram2009
Active Contributor
0 Kudos

Hi Mushtaq

How to do the optimize the Temp DB? can u guide us

Regards

Sriram

Former Member
0 Kudos

sorry i forgot to link the whitepaper, now i did. Please follow the whitepaper recommendations, it has detailed explanation.

If you have any questions in it, let us know.

Thanks

Mushtaq

Former Member
0 Kudos

TempDB is a system DB used for temporary objects, if you delete TempDB you SQL Server will crash. you have to optimize your tempdb configuration. Please check [this|; white paper's section 'tempDB consideration' for recommendations from Microsoft.

Please let us know if you further questions.

Thanks

Mushtaq