August 7, 2010 at 9:23 pm
I am doing some testing on tempdb usage. Mentioned below is the create which i am using to test.My first test has mdf and ldf for tempdb on same RAID10 LUN and second one has ldf on different LUN. I was hoping that waittimes on write would decrease after the move the ldf to another ldf but it increased.I am little confused can someone please analyse my results and point me what i am missing. I am attaching all the scripts and snapshots from the results. Thanks in advance..
August 7, 2010 at 9:28 pm
This LUN that you moved the ldf to, what is the composition of it?
How many spindles are involved in the LUN, and what RAID type is it?
Compare that to the number of spindles in the first LUN - how many spindles are in the RAID10 LUN where you initially created the LDF?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 7, 2010 at 9:34 pm
i think 5 spindles..but both the LUNS are exactly the same..
August 7, 2010 at 10:46 pm
Is the new LUN completely dedicated to the log file for TEMPDB?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 8, 2010 at 4:14 am
Well the first one is dedicated one and the second one where is moved the files also has different LDF's on the same LUN.
August 8, 2010 at 9:59 am
Based on that information and the test results, I would leave the tempdb log on the same LUN as the data file(s).
There really isn't a hard and fast rule about the placement. And since you found it to perform better when the log is not on the same LUN as the rest of the logs - I would use that info as the basis for the decision.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 8, 2010 at 8:53 pm
hmmm..i think i should leave the way it is. Thanks for analysing.
August 8, 2010 at 10:38 pm
You're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply