Post reply

Any way to do load testing??

  • June 12, 2003 at 6:55 am

    #105764

    I wanted to capture profiler trace and run it to test server to debug issues is it possible guys??

    Prakash

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • June 12, 2003 at 10:03 am

    #461084

    Yes, you can capture all the queries executed and your prod server. But before starting with profiler, you should create an exact copy of the prod db in your test server, then start with profiler and then apply the changes at your test server.

    If your prod server is heavily queried, you can run sp_trace stored procedures instead of profiler and capture the data into a file. Wich is faster.

  • June 12, 2003 at 10:21 am

    #461093

    Thanks racosta

    This is a major decision to be taken by me.... just wanted to confirm again that if i capture the profiler trace from production and run that onto test server that's possible first and second the load which was happening parallaly on production server the same will simulated on test server??

    I am not having sql server installed on my machine now so can't test this scenerio. If any of u guys hav done that please confirm!!!

    Thanks again...

    Prakash

    Prakash

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

Viewing 3 posts - 1 through 2 (of 2 total)

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