Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2012-10-25 : 09:55:41
|
| We’ll be doing some changes organization wide, which will affect the Tempdb performance: RCSI, TDE, SAN replication etc. We need to find out what affect these options cause on the tempdb. Basically, we need some counters or reports to indicate the tempdb performance before and after implementing these changes. I did some research but didn’t really find anything significant. Has anyone done such a thing? Any suggestions?Note: we are not necessarily looking for performance tuning of tempdb; we might eventually end up on that road. However, at this point, we need something to indicate temdb performance before and after implementing the new features. ------------------------I think, therefore I am - Rene Descartes |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-10-25 : 10:35:29
|
| Assuming you've checked all the optimizations are in place - http://www.sqlserver-dba.com/2011/04/tempdb-performance-and-strategy-checklist.html, use various IO tools to measure before and after. The key is to identify the IO profile of the TempDB , and rerun in different scenarios. Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2012-10-25 : 11:09:48
|
| Jack, thank you for your response. The link you mentioned talks about the best practices; However, I am trying to find out how tempdb will be affected by the changes I am going to implement. ------------------------I think, therefore I am - Rene Descartes |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-10-26 : 01:53:06
|
| ravilobo, A quick approach is to run the IO based tests - before and after the changes .Assuming you've got tempdb on a separate drive , monitoring read\writes IO is a useful tool. SQLIO is one such tool -Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2012-10-26 : 09:52:55
|
quote:
Originally posted by jackvA quick approach is to run the IO based tests - before and after the changes .Assuming you've got tempdb on a separate drive , monitoring read\writes IO is a useful tool. SQLIO is one such tool -
Wow! Thank you sir. SQLIO makes a lot of sense. I just watched a video on SQLIO by Brent Ozar. It's a nice little tool.------------------------I think, therefore I am - Rene Descartes |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
|
|
Tempdb benchmarking