March 15, 2012 at 3:48 am
Hi folks,
I am the DBA of an SQL Server 2008R2 system hosted on a VM. Let me talk about the processing power first:
1) When I type 'msinfo32' command, I get the information as 8 cores,8logical processors
2)When I connect to the sql instance, and right click on server and try to read processor information, I see 8 processors.
So should I conclude that I have been 8 logical processors to my SQL by my VM admin.
Now, I wanted to configure my TemDB optimally. so based on the number of processors, I put 8 files with equal size and equal growth rate based on the suggestion that Tempdb should have number of files equal to the number of processors.
However, I would like to mention that I had been given a drive T for Tempdb, so i stored all the files there. Now, I am not sure if all files got stored in the same location(LUN) or different because the logical drive that I am seeing may span to different locations on actual storage.
Please comment on my questions.
Regards
Chandan Jha
March 15, 2012 at 5:51 am
Someone please help me clear my doubts.
March 15, 2012 at 6:24 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2012 at 6:49 am
GilaMonster (3/15/2012)
http://sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.aspx
Thanks. I will go through this article again, but can you read rest of my question about processors on the VM and clear some doubts.
Thanks Monster!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply