locked
Performance test of SQL Server Agent Job using VSTS RRS feed

  • Question

  • Hi,

    Need the steps/procedure to perform the "Load/Performance test of SQL Server Agent job" using VSTS.

    Any help or direction would be of great help.

    Thanks
    Robin
    • Moved by Edwer Fang Wednesday, December 16, 2009 2:52 AM (From:Visual Studio Web Performance and Load Testing)
    Wednesday, December 9, 2009 11:30 AM

All replies

  • Hello Robin,

    When you mention 'perform the "Load/Performance test of SQL Server Agent job" using VSTS', do you mean you want to monitor and improve the performance of your Web applications through collecting SQL trace data during a load test run and analyzing later.

    If so, here are some articles you may refer to:
    http://msdn.microsoft.com/en-us/library/ms243169.aspx
    http://msdn.microsoft.com/en-us/library/ms404658.aspx
    http://msdn.microsoft.com/en-us/library/ms182589.aspx
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Send us any feedback you have about the help from MSFT at fbmsdn@microsoft.com.
    Thursday, December 10, 2009 7:35 AM
  • Hi Edwer,

     

    Thanks for the response.

    To make my requirement clear its like , we have got 2 SQL Server SQ1 and SQ2. We have One  SQL Job running in SQ2. The SQL Job consist of 5 steps wherein in each step it used to call a Stored procedure. The Utilmate result is after all the steps are being executed the data would be loaded in SQ2. Both the Sql server SQ1 and SQ2 are linked server.

    We want to perform the Performance testing of the SQL Job which is running in SQL server 1 thats is SQ1.

    Hope i am clear.

    Could you please let me know how can i perform the Performance test using VSTS 2008.

    Note : The SQL Job is scheduled every day.

    Any help is quite appreciated.

    Thanks

    Robin

    Thursday, December 10, 2009 12:14 PM
  • Hello Robin,

    So you are looking for the ways to test the performance of the related SQL Job on specified SQL Server machine. If so, sorry this may not be the right place for this issue as this forum is for the web performance and load testing.

    You may post your issue on the SQL Server Forum so you can get better and quicker response as there are more experts on SQL Server.

    Thank you for your understanding.
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Send us any feedback you have about the help from MSFT at fbmsdn@microsoft.com.
    Friday, December 11, 2009 6:01 AM
  • Thx for the response i posted the query on SQL Server forum.
    Friday, December 11, 2009 8:50 AM