temp db | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

temp db

hi all, i refer SQL SERVER MAGAZINE October 2005..i came with this doubt when i read an article on
IDENTIFYING PROCESSORS FOR TEMPDB SETTINGS. can any one give a brief note on logical processors and phisical procesors with respect to
number of tempdb files…?
krishna chaitanya.s
project engineer-SQLDBA

Read this. http://support.microsoft.com/kb/328551 It helpes us out tremendously. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Also thishttp://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21261789.html#12966983 thread for relevant information. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.