What are the steps to capture workload from production and replay on test env.

Question

What are the steps to capture workload from production and replay on test env.

Oracle_91

SSChampion

Points: 14548
More actions
March 12, 2014 at 12:44 am

#283316

Hi Experts,
I want to perform performance testing on my test server?
How to capture workload from production and replay on test server?
Basically looking for detailed steps so that I can repro the same workload from production to test env.
Thanks in Advance.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 1

You can use Profiler Replay to do this. Starting 2012 you can use distributed replay to have a better scalable solution.

Check these ..

http://sqlmag.com/database-performance-tuning/sql-servers-trace-and-replay-tool

http://blogs.msdn.com/b/mssqlisv/archive/2008/06/26/use-sql-server-replay-tools-to-reproduce-and-resolve-customer-issues.aspx

http://technet.microsoft.com/en-us/library/ms189604(v=sql.100).aspx

--

SQLBuddy

Oracle_91 SSChampion Points: 14548 More actions · Answer 2

Oracle_91

SSChampion

Points: 14548

March 12, 2014 at 9:07 am

#1696436

Thank you very much.

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 3

SQLBuddy123

One Orange Chip

Points: 28294

March 12, 2014 at 9:13 am

#1696442

You are welcome Oracle_91 🙂

--

SQLBuddy

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 4

fsession12 39949 (3/12/2014)
Many thanks for the website link through PM matey, great add-on.
Just had a potential reduce right here so my site may well not been employed before, all up and running now although
____________________________________
best maternity jeans

Glad that you found it useful 🙂

--

SQLBuddy

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 5

sqlbuddy123 (3/12/2014)

fsession12 39949 (3/12/2014)
Many thanks for the website link through PM matey, great add-on.
Just had a potential reduce right here so my site may well not been employed before, all up and running now although
____________________________________
"link removed"
Glad that you found it useful 🙂
--
SQLBuddy

That post was SPAM. Look at the link posted. It's a typical ploy to try to keep their post active. I've reported it as spam.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 6

Thanks Jeff. I didn't notice that. Good Catch. Actually, I didn't click the link.

--

SQLBuddy