The results from SQLIO are greater than what I calculate the array can provide because I was using 8 threads, I presume?
Wonder what IOMeter would give?
http://www.sqlservercentral.com/blogs/sqlmanofmystery/2011/06/29/understanding-benchmarks/[/url]
Steve Jones - SSC Editor (10/7/2013)
You can get a trace from your existing system and run that.
What do I use to get a 'trace' and will it tell me how much tempdb is utilized?
...and thanks for your help with this!
I'm not sure but maybe Steve means a Profiler Trace? I would run a server side trace and filter as many things out as possible only tempdb? But not sure if that's what he meant...or if he meant something tracing w/extended events maybe?
Another idea comes to mind is you can search for a query on the Virtual io file stats DMV. This will show every read/write IOs that was written to the SQL Server for each data and log file since reboot. Although it won't show in size how large each SQL statement/transaction to TEMPDB it can give you an idea the number of reads/writes compared to your "date files"
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀