question

ocolakoglu avatar image
ocolakoglu asked

SQL Load test tool from trace file

Hi I need a good and effective load test tool running from trace file. For example I took a trace file into sql table when I select it as **SELECT DISTINCT SPID FROM TRCTABLE** It returns about 200 rows. So that for half hour there was at least 200 connections in the our productin server. And I want to simulate it on our new free server. How can i do this. Could you suggest a software or script for me?
tools
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Matt Whitfield avatar image
Matt Whitfield answered
You'd be wanting to look at replaying traces: [How to: Replay a Trace Table (SQL Server Profiler)][1] [1]: http://msdn.microsoft.com/en-us/library/ms187857.aspx
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ocolakoglu avatar image ocolakoglu commented ·
Thank you for your information. I have already tried it in our new server. New server has 64 cpus and 256 gb ram. the old server has 16 cpus and 64gb ram. I got the trace about 25 minutes and it is about 1 million rows. I hoped that when i replay the trace the new server will better than the older but the time in new server is about ten times slower. I prefer multiple thread also. Can you prefer any other way to me?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.