on 11-20-2010 12:50 PM
Hi
Currently Our Temp DB growing 30 GB we can delete the temp DB in Sap Bi7? Kindly guide us
Regards
Sriram
Hi all
Any updates ?
Regards
Sriram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
Regards,
Krishna
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mushtaq
How to do the optimize the Temp DB? can u guide us
Regards
Sriram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.