Check Time

The simplest way to populate your database with test data.

Check Time

Postby mustarirakos » Thu Jul 15, 2010 12:59 pm

At this moment I do a lot of vitalizing with VMware ESX and the first question I always get from my customers: What is the impact on a SQL-Server database on a Virtual machine compared with a Physical machine.

Using SQL-Data Generator to import 1.000.000 records in 25 tables give a nice stress on the server. Only, I can’t really compare it as I can’t see exact how much time it takes to finish the job. I like to suggest to supply a start and finish time so we also can use SQL Data Compare to test server speed without the need of sophisticated testing tools

I already get an possible work around from your engineers with an example using some command line commands, but I prefer to have timer functionality as part of the product itself Smile
Mike Cabolet
Posts: 1
Joined: Thu Jul 15, 2010 12:41 pm
Location: chicago

Postby RBA » Thu Jul 15, 2010 2:52 pm

Hi Mike,

So what you'd like is a 'time elapsed' metric displayed in SQL Data Generator so you can use the product as a benchmarking tool?

You probably know this already but just in case I thought I'd mention that disk access on VMs is massively degraded if you use a virtual disk instead of mapping a physical disk directly. That'll be the biggest impact on disk performance.

I'm not sure if SDG would be the best tool to use for benchmarking as it only performs inserts. Is it strictly disk performance that you're interested in?

Robin Anderson
Red-Gate Software
Posts: 148
Joined: Fri Jun 05, 2009 12:13 pm
Location: Cambridge

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests