March 15, 2012 at 1:35 am
I have a new 64 bit server that has SQL 2008 on it. I am looking for a good stress tool that will measure how good the server is in terms of performance and what it lacks. Please advise which tool is suitable.
March 16, 2012 at 12:31 pm
There are tools downloadable from Microsoft to stress the I/O and consume memory in a general way.
Also, using SQL Profiler, you can capture T-SQL events on one server, and then re-play the trace on another server, which would give you an idea of how a new server would hold up to an actual daily workload.
How to: Replay a Trace File (SQL Server Profiler)
http://msdn.microsoft.com/en-us/library/ms189604.aspx
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 23, 2012 at 1:34 am
Sorry, was on leave. Thanks for the info.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply