Professional Web Applications Themes

Program that inserts values? - Microsoft SQL / MS SQL Server

Is there a program that insert million of random values into mssql databases? I'm looking for a stress test and indexing improvment under heavy load and millions of rows....

  1. #1

    Default Program that inserts values?

    Is there a program that insert million of random values into mssql
    databases?
    I'm looking for a stress test and indexing improvment under heavy load and
    millions of rows.


    Jason Guest

  2. #2

    Default Re: Program that inserts values?

    Hi

    You may want to look at DB Hammer in the resource kit to see if it does what
    is required:

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01f1.asp

    Other alternatives are things like load runner.

    Maybe some VBS will do what is required?

    IMO the nature of the data inserted should usually reflect how your
    application is used and the data it generates and not be random.

    John


    "Jason Davis" <com> wrote in message
    news:%23$phx.gbl... 


    John Guest

  3. #3

    Default Re: Program that inserts values?

    Jason,

    Just one comment about this - while this is a useful thing
    to do, there are situations where what's good for random
    values turns out to be terrible for real-world values.

    Here's a simple example of a query that takes an unexpected
    number of reads, but that wouldn't show up with random data:

    set statistics io on
    go

    select min(OrderDate) as LastUnshipped
    from Northwind..Orders
    where ShippedDate is null
    go

    set statistics io off

    -- Steve Kass
    -- Drew University
    -- Ref: 3F590301-2676-4B8C-8BE6-FF40438AC7D3


    Jason Davis wrote:
     

    Steve Guest

Similar Threads

  1. 1-to-Many Inserts
    By Fandomlife in forum Macromedia ColdFusion
    Replies: 3
    Last Post: March 29th, 09:15 PM
  2. Replies: 0
    Last Post: February 23rd, 09:45 AM
  3. right program for creating DVD case inserts?
    By Craig_Busch@adobeforums.com in forum Adobe Photoshop Mac CS, CS2 & CS3
    Replies: 3
    Last Post: April 17th, 04:32 PM
  4. Replies: 2
    Last Post: January 14th, 09:13 AM
  5. Getting return values to PHP from external VB-program
    By Henrik Olsen in forum PHP Development
    Replies: 0
    Last Post: October 1st, 11:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139