Capacity Planning For Tempdb - Monitor

Question

Post reply

Capacity Planning For Tempdb - Monitor

curious_sqldba

SSC-Dedicated

Points: 36494
More actions
August 2, 2010 at 7:35 am

#157121

i will be doing some testing by splitting tempdb across different drives, but i do not know what counters do i need to select in perfmon or somewhere else to select which would help me in making in decision whether the performance has improved or not after moving ldf to another drive.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

Please refer this article for some direction.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 2

thanks..but i am still lost...i do not have any space issues..my only concerned is i should be able to make a decision that moving tempdb log file to another drive improved the performance. Which dmv would help me? please suggest

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 3

sys.dm_io_virtual_file_stats

http://sqlblog.com/blogs/louis_davidson/archive/2007/07/27/sys-dm-io-virtual-file-stats.aspx

Manu

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 4

thanks Manu..is num_of_reads gives the total reads since the server was built or restarted? I think since built because even after i recycle the server , the number was same. Please confirm. Thanks

ben.rosato SSCommitted Points: 1929 More actions · Answer 5

Do you have a performance problem or are you just moving things for the sake of moving them?

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 6

i have done enough testing after and before moving them, in my case moving is not the solution. Thanks

ben.rosato SSCommitted Points: 1929 More actions · Answer 7

iqtedar (9/28/2010)
i have done enough testing after and before moving them, in my case moving is not the solution. Thanks

Solution to what?