SQL Server Performance

Stimulating Table Data for Performance Tuning?

Discussion in 'Third Party Tools' started by sonnysingh, Aug 31, 2006.

  1. sonnysingh Member

    Hi All

    I am looking for advice and statistics on Third party tools for performancing tuning.. which also have availability of stimulate the data option.
    what I mean is suppose...

    Table A have 1000 records at present (using in the query)
    But we need 1000000 records (rows) in order to tune this Query.

    so Third party tools will have the option to input that level of data for tables and run the performance for this query....
    do we have any tools in the market which provide this kind of interface????

    Thanks in advance..
  2. ghemant Moderator

    Hi,
    if its on the developement server you can add that much of rows also in chunk (but obvious to you ) and you may refer third party tool athttp://www.idera.com/Products/SQLscaler/.

    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ------------------------
    http://hemantgirisgoswami.blogspot.com
  3. RockyLee New Member

  4. sonnysingh Member

    thanks guys...
    I do not want to add the rows as it will be very lengthy process. I just want third party tools ysage for it. This tool let enter ther estimated rows could be present or grow percentage of data in the next couple of years ( 1 to 5 years) and tools can produce performance issue and ideal performance solution for this query on the basis of entered information...

    any other tools and comments on them????

    regards guys..
  5. satya Moderator

    For the third party tools usage refer to the Software Spotlight section in this website.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page