Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tinks
Starting Member
34 Posts |
 Posted - 2004-04-26 : 07:32:15
|
| Hi, I need to provide a 'script' to a client to illustrate that they need to change their environment (ie. get a faster machine, use SQL Enterprise etc). What I was asked to do was 'Is it easy for someone to create a SQL benchmark script?It could do things like create some tables, insert some rows, create indexes, retrieve rows, delete rows etc and time each phase.In this way, we could run it here, at nnn, at aaa etc to compare technical environments.Is this possible?'Now I created a script with the above but it runs very fast (less then 2 seconds)... is there anything out there that will allow me to test / benchmark performance on a server?Taryn-Vee@>-'-,--- |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-04-26 : 07:53:50
|
| Well, I guess you could create a really large loop and insert millions of rows into a table. That would put some stress on the Disk Subsystem. Once you have some rows, create some indexes and see how long that takes. Once that's done, do some selecting on that really huge table.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
tinks
Starting Member
34 Posts |
Posted - 2004-04-26 : 09:43:13
|
quote:
Originally posted by MichaelP
Well, I guess you could create a really large loop and insert millions of rows into a table. That would put some stress on the Disk Subsystem. Once you have some rows, create some indexes and see how long that takes. Once that's done, do some selecting on that really huge table.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
that seems to give me better timings then my measly 4000 recs!bit fluey and not thinking as clear as normal ... or i may have figured this out myself - thanks for the tip though ...Taryn-Vee@>-'-,--- |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-04-26 : 10:05:11
|
| Yeah, 4000 records is nothing. Put about 1-5 million rows in there and give that a go.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
|
|
Server benchmarks